Mark Allanson
|
| posted on 31/8/05 at 03:08 PM |
|
|
Any MS Office experts out there?
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
If you can keep you head, whilst all others around you are losing theirs, you are not fully aware of the situation
|
|
|
|
|
Smooth Torquer
|
| posted on 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
|
| posted on 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
|
| posted on 31/8/05 at 04:45 PM |
|
|
Can you recommend any online tutorials that speak normal english?
If you can keep you head, whilst all others around you are losing theirs, you are not fully aware of the situation
|
|
|
britishtrident
|
| posted on 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
|
| posted on 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.
Who the f**K tightened this up!
|
|
|
IWantOne
|
| posted on 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
|
| posted on 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
If you can keep you head, whilst all others around you are losing theirs, you are not fully aware of the situation
|
|
|
IWantOne
|
| posted on 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
|
| posted on 6/9/05 at 09:58 PM |
|
|
Thanks, much appreciated
If you can keep you head, whilst all others around you are losing theirs, you are not fully aware of the situation
|
|
|
