Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sallys enquiry database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Sally's Enquiry database

Sally's Enquiry database

ResolvedVersion Standard

Sally has attended:
Access Intermediate course
Access Advanced course

Sally's Enquiry database

How can I link the data in the database to a word document and for it to know what to write in the letter based on what information had been requested.

RE: Sally's Enquiry database

Hi Sally, Thank you for your question, in answer I can only surmise that you are looking for some sort of mail merge operation, if you wish to use the data fields in Word, you will need to undertake this route.
There are a number of solutions in Word that you can investigate, for example; if you go to the menu command Insert>Field and Select Mail Merge, you will find options that will allow you to insert individual fields into your document at specific points, of course this is very dependant on your requirements and like all mail merge operations will apply data that you filter and/or sort. I hope that sets you on the way to finding your solution, best regards Pete.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.