database

[Mary K]

I am real new to access. I need to make a customer service database. I'm
not sure what I should use. Tables, forms, or reports. I need to be able to
enter customers name, address, phone number and a comment area of what the
call was for. I have to be able to pull this up again if they call back and
be able to add more information in the comment (note) area so it continues
on. If someone could help me with this it would be great. Thank you in
advance.

 

[Rick B]

I'd probably use the "Service Call Management" template on the Microsoft
website as a starting point, and modify it to meet my needs.

http://office.microsoft.com/en-us/templates/CT011366681033.aspx

Just FYI, you use tables, forms and reports. Each of those objects has a
particular purpose.

 

[Rick B]

FYI, there is also a "Contact Management" database on that site. When you
say "call" I am not sure if you mean service call, or phone call. If phone
call, use the Contact Management template.

 

[Mary K]

Thank you I will try that. I think this is want I need. Thanks again.

 

[John Vinson]

On Tue, 19 Sep 2006 06:03:03 -0700, Mary K <Mary

I'm not sure what I should use. Tables, forms, or reports.

That's a bit like saying that you want to drive a car, and you're not
sure what you should use: engine, transmission, or steering gear.

You'll use all three. Store the data in (properly normalized!) tables;
enter and edit it using Forms; print it using Reports.


John W. Vinson[MVP]

 

[Mary K]

Like I said I'm real new to access. Thank you for the information I
understand it a little better. I wasn't sure how you used each section.
Thanks