Printable form with linked Database

[Guest]

I need to create a form (A SERVICE CALL SHEET) that is printable (to be given
to service call man) and that enters the data from that form to a database
and stores the information.
I currently hand write service calls into store bought service call books
and then enter the information I have hand written into an Excel Spreadsheet
when the svc. call guy brings it back. I would like to be able to enter the
information one time into a form on the computer and be able to print that
form as the service call and have that information be automatically entered
into the database. I would also like to be able to save this information
separated by billing period.(monthly).
Am I asking too much? Is this the right program to do that in? Help????
Thanks, Linda J.

 

[Douglas J. Steele]

Access can certainly do what you appear to be asking for.

However, typically you don't print forms: you print reports. Forms are
essentially the way you input data, and reports are how you get it back out
again.

The critical first step is to identify all of the entities with which you're
dealing, so that you can design the database correctly. If you're not
familiar with data modelling, Jeff Conrad has a bunch of good links on the
topic at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101