I need to make a form to gather information about crashed cars, about 50 fields in total, and then be able to print out in a variety of templates for
different clients requirements.
Anyone know an easy way of doing this?
Thanks in anticipation
Mark
You could create an MS Access database to capture the data in its various fields. Then you could create a report in Access to print out the data.
If you wanted the print outs to be more formatted the Access reports allow, you can use Word to create your template, and then use the Mail Merge
function to automatically enter the required data from your database in the correct places.
I'll do my best to explain in greater detail if you require it.
HTH
Sam
[Edited on 31/8/05 by Smooth Torquer]
quote:
Originally posted by Smooth Torquer
You could create an MS Access database to capture the data in its various fields. Then you could create a report in Access to print out the data.
If you wanted the print outs to be more formatted the Access reports allow, you can use Word to create your template, and then use the Mail Merge function to automatically enter the required data from your database in the correct places.
I'll do my best to explain in greater detail if you require it.
HTH
Sam
[Edited on 31/8/05 by Smooth Torquer]
Can you recommend any online tutorials that speak normal english?
Start with one of the MSAcess sample databases, don't do anything too fancy to start with you can get away with just a flat file database that
is one that stores its data in a single spread sheet like file.
You can view and enter the data through Access forms and print a view the data via reports.
If this were me I'd be tempted to do this in Excel.
You can then sort and filter the data depending on what you want the report to show.
I've found in the past that those "teach yourself...." software titles are quite easy going. and as I recall they are quite cheap in pc
world and staples too.
if you give me some idea of the fields and report layouts, i will write you a database. its a dirty job but someone has to do it!!!!
Thanks for the offer, but I will have to maintain and modify the system, so I really need to do it myself - just need a few pointers
the bst software is Access. you need to determine what fields you need. write them down and make sure you happy. then you can make a table. from the
table..when your happy, you can make a form. reports will follow when you have some data in the table...any problems, drop me a mail.
ady
Thanks, much appreciated