help with a table question!

[Morgan04]

Hi everyone:
First, am I in the right forum? I am new here and have not worked with
Access for a few years. So this question might sound stupid to you but
bear with me, please...
My boss at work wants me to design something like this. Is this
possible in Access? If not how and where should I go??
He wants us to be able to have a table so we can register customers
when they come in and be able to print each record seperately. However,
he wants to be able to write over each record as we go along (to save
time) but the program should be able to save each record!!
Also, we should be able to make a report of all the customers at the
end of the day(everything we have typed) and also be able to extract
certain information from the table such as just their name & phone #
(this is possible in Access, right?)
I know it is a lot but please help me out if you can. I am lost...
Thanks so much....

 

[John Nurick]

Hi Morgan,

Yes, it's possible - but not until you and your boss work out in a bit
more detail what your objectives are.

It sounds as if you need at a minimum one table for Customers, with name
and address and phone number and so on, and another for Visits or
Transactions or something, with a one to many relationship (each
Customer can have many Transactions). Each Transaction record would
store things like date and time, the member of staff involved, and
whatever else is necessary.

 

[Morgan04]

Thanks for answering. I have figured something out. I have 23 fields and
when I made the report to include all the fields, it cuts off the words
and it is not in 1 page. How can I make the fields smaller so the words
won't cut off?

 

[Morgan04]

Back again. I have another question. How do I make drop down boxes in
Access? Is it possible?

 

[John Nurick]

Yes: they're called ComboBox

Back again. I have another question. How do I make drop down boxes in
Access? Is it possible?

 

[Morgan04]

Thanks everyone. I think I got something. I couldn't find anything on
combo box but I found something in the wizard that does that..