Mail Merge Access Data to Several Word Docs

[lmarshall]

I am creating a database (Access 2007) for a dealership I am employed with. All paperwork for vehicles is currently done on a typewritter. So I am working to create a database that can be used to 'mailmerge' or some other function to merge the data into new forms I'm building in Word 2007.

I have started creating a database with 4 main tables
- Sales Person
- Company/Person Sold To (address,phone info)
- Vehicles ( Serial No. Make, Model, Purchasing Info, Date Sold, etc )
- Vehicle Specs - (Engine Size, Transmission ect)

I would like to migrate the data from the database to the Word forms. Is there an easy way to migrate table/subtable information into multiple Word forms? There are about 7-9 Word forms, but not all of them will be used for all vehicles whien puchased (warranty docs ect).

Can someone please point me in the right direction for this?


Thank you!

 

[fneily]

First thing with Access is to get your tables normalized. Even before approaching the computer. See the following for a start:
Fundamentals of Relational Database Design

http://r937.com/relational.html

Not knowing all the data you want to store, you could have the following tables:
tblCustomer
CustID Primary Key
Fname
Lname
Address
State
etc.

tblSaleperson
SalesID Primary Key
Fname
Lname
other salesperson info

tblVehicle
VehID Primary Key
Make
Model

tblColor
ColorID Primary Key
Description

Those would be the main tables. Now you need a junction table to bring everything together.
tblPurchase
PurID Primary Key
CustID Foreign Key
SalesID Foreign Key
VehID Foreign Key
DateSold
EngineSize (list values)
TransmissionType (List values)
ColorID
VIN
other fields that pertain to the CUSTOMER desires for the car and not included in the standard model type such as bucket seats, two or four door, etc.

Now using queries, you extract the info you need for your forms.

Then you can do a simple mail merge in Word. Access Help has an example if you need one.