need help!!!!!!!!!

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I know nothing about access and would like some help on setting something
up. I have attached a spreadsheet that I use for a coffee club at work. I
would like to set it up so I could just enter data for each person and have
it go to a form that I can print out. The way I am doing it now works just
fine but there are more people I need to add and I am running out of space
in excel. I suppose I could start another sheet but I would like to get a
little fancier. Maybe it is alot of work but any ideas would be
appreciated.
 
I know nothing about access and would like some help on setting something
up. I have attached a spreadsheet that I use for a coffee club at work. I
would like to set it up so I could just enter data for each person and have
it go to a form that I can print out. The way I am doing it now works just
fine but there are more people I need to add and I am running out of space
in excel. I suppose I could start another sheet but I would like to get a
little fancier. Maybe it is alot of work but any ideas would be
appreciated.
Click to expand...

Like most of the volunteers here, I will not download or open binaries
from an unvouched source. Note also that most of the folks who post
questions need help - a meaningful subject line such as "Moving from
Excel to Access" would be a lot more useful.

Access is NOT A BIG SPREADSHEET. It's perfectly capable of doing what
you describe - but you will not do it the same way. You should create
several tables by doing an exercise called "Normalization": identify
the Entities (real-life persons, things or events such as Members,
Payments, or whatever you record for the coffee club), and then
identify the entities' Attributes (LastName, FirstName, etc. for
members). Each type of Entity gets its own table. You can then create
Forms for data entry and editing, and Reports for printing.
 
Back
Top