Board logo

Any MS Office experts out there?
Mark Allanson - 31/8/05 at 03:08 PM

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


Smooth Torquer - 31/8/05 at 03:26 PM

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]


Hellfire - 31/8/05 at 03:39 PM

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]


Ditto above - if using MS products this would seem the easiest (though no necessarily the best long term) to be going on with.


Mark Allanson - 31/8/05 at 04:45 PM

Can you recommend any online tutorials that speak normal english?


britishtrident - 31/8/05 at 05:29 PM

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.


DorsetStrider - 31/8/05 at 11:22 PM

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.


IWantOne - 1/9/05 at 07:29 AM

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!!!!


Mark Allanson - 2/9/05 at 09:36 PM

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


IWantOne - 4/9/05 at 07:00 PM

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


Mark Allanson - 6/9/05 at 09:58 PM

Thanks, much appreciated