A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

help transition to access from excel



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2010, 02:46 PM posted to microsoft.public.access.tablesdbdesign
Ernie
external usenet poster
 
Posts: 67
Default help transition to access from excel

I am transitioning from excel to access for the reason of the spreadsheet is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys. The
problem is I have customers with more than one auto policy and more than one
one person in a house hold with policys ex. husbands auto, wifes auto, family
homeowners, husbands auto, wifes life policy, husbands business policy, sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks

  #2  
Old March 8th, 2010, 05:06 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default help transition to access from excel

Ernie

Be aware that Access is not Excel on steroids. The tips & tricks you may
have learned for using Excel may actually make your transition to Excel more
difficult.

And the user-interface that Excel presents is relatively well-known.

Access is not a bookcase (like Excel), it is a power-saw. If you want an
easy-to-use user-interface, especially one customized to your particular
situation, YOU have to build it.

That said, have you searched on-line for that kind of template? Remember,
you'll need to understand enough about Access to know when and how to change
the template to match your needs.

I'm not trying to discourage you, I'm trying to be realistic about what's
involved.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks



  #3  
Old March 8th, 2010, 06:41 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default help transition to access from excel

Correction ...

.... may make your transition to ACCESS more difficult ...

Jeff

"Jeff Boyce" wrote in message
...
Ernie

Be aware that Access is not Excel on steroids. The tips & tricks you may
have learned for using Excel may actually make your transition to Excel
more difficult.

And the user-interface that Excel presents is relatively well-known.

Access is not a bookcase (like Excel), it is a power-saw. If you want an
easy-to-use user-interface, especially one customized to your particular
situation, YOU have to build it.

That said, have you searched on-line for that kind of template? Remember,
you'll need to understand enough about Access to know when and how to
change the template to match your needs.

I'm not trying to discourage you, I'm trying to be realistic about what's
involved.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using
the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks





  #4  
Old March 8th, 2010, 06:58 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default help transition to access from excel

Hello Ernie,

Are you interested in having someone create this database for you? I provide
help with Access, Excel and Word applications for a small fee. I could
design the tables and import your Excel data and you take it from there or I
could create the entire database including importing the Excel data for you.
Let me create the database for you and you could have the database up and
running in a short time. Contact me and I will be happy to give you a quote
of my fees for whatever help you want.

Steve



"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks



  #5  
Old March 8th, 2010, 07:04 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default help transition to access from excel - stevie PIMPS again

"Steve" wrote in message
...

Are you interested in having someone create this database for you? If not,
I do not provide help with Access, Excel and Word applications for a small
fee. I usually try to guoge my victims. I could design the tables and
import your Excel data if I knew what I was talking about and you take it
from there or I could create the entire database including importing the
Excel data for you. Let me create the database for you and you would not
have the database up and running in a short time. Contact me and I will be
happy to give you a quote of my unreasonable fees for whatever help you
will not get.

Steve





Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP


  #6  
Old March 8th, 2010, 07:41 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default help transition to access from excel

Ernie,
Be aware that Steve trolls here for business, many deem as dubious
quality, whereas this forum is for FREE advise by others.

--
Build a little, test a little.


"Steve" wrote:

Hello Ernie,

Are you interested in having someone create this database for you? I provide
help with Access, Excel and Word applications for a small fee. I could
design the tables and import your Excel data and you take it from there or I
could create the entire database including importing the Excel data for you.
Let me create the database for you and you could have the database up and
running in a short time. Contact me and I will be happy to give you a quote
of my fees for whatever help you want.

Steve



"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks



.

  #7  
Old March 8th, 2010, 08:18 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default help transition to access from excel

Ernie

This newsgroup provides FREE asssistance. The Code of Conduct prohibits
solicitation.

Before you decide to do business with someone offering service-for-a-fee,
ask yourself if you want to do business with someone who knowingly
disregards the rules.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks



  #8  
Old March 9th, 2010, 02:46 AM posted to microsoft.public.access.tablesdbdesign
Ernie
external usenet poster
 
Posts: 67
Default help transition to access from excel

Thank you:

Jeff Jon and Karl for your advice. I appreciate your comments and Oppinions.

Thanks

Ernest


"Jeff Boyce" wrote:

Ernie

This newsgroup provides FREE asssistance. The Code of Conduct prohibits
solicitation.

Before you decide to do business with someone offering service-for-a-fee,
ask yourself if you want to do business with someone who knowingly
disregards the rules.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Ernie" wrote in message
...
I am transitioning from excel to access for the reason of the spreadsheet
is
only getting igger and harder to use.

I am an Insurance agent and I am trying to set up a new database using the
templates as munc as I can. I want to have the ability to access the
customers information (contact management) and their account or policys.
The
problem is I have customers with more than one auto policy and more than
one
one person in a house hold with policys ex. husbands auto, wifes auto,
family
homeowners, husbands auto, wifes life policy, husbands business policy,
sons
auto policy. How do I set this up.

I also want to track the payments for the policys.

Is there a existing template I can use.

How do I set up the table (s)

Can the information be imported from the spreadsheet?

Thanks



.

  #9  
Old March 9th, 2010, 06:58 PM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default help transition to access from excel


"Steve" schreef in bericht ...
Hello Ernie,

Are you interested in having someone create this database for you? I provide help with Access, Excel and Word applications for a
small fee. I could design the tables and import your Excel data and you take it from there or I could create the entire database
including importing the Excel data for you. Let me create the database for you and you could have the database up and running in a
short time. Contact me and I will be happy to give you a quote of my fees for whatever help you want.


--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.