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

access class microsoft training - access

Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Access

access class microsoft training - Access

ResolvedVersion Standard

Sarah has attended:
Access Introduction course
Access Intermediate course

Access

How do I set up automatic letter generation for consultation for regen estates on the database?

RE: Access

Hi Sarah,

You can store the details of the letter in tables
So perhaps 2 tables, one containing the contact details for each recipient, then the letter details in another table. You could also do it ini just one table, depending on your DB structure.


Then use a query, if needed, to extract relevant data


Then create a report that looks like a letter.
So in the Detail section you would have the letter content in a text box or label control.

Perhaps in the page header, you could put the contact details.

Remember to force each record to appear on a new page, in the way you learnt on the intermedite course. (Under properties for the report itself).

Regards

Richard

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

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.11 secs.