Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

The Indie Scene

The Producer: Office Automation

 

 

Click Here to Get Started

Sample Files

 

Advanced Access

Lesson Objectives: Learn how to create a Mail Merge in Word that looks up the recipients with a query in Access. This lesson will demonstrate how to filter data with queries, create merged documents, create and modify reports, and create PivotTable forms. In this lesson you will:

Practice the steps needed to create a Mail Merge Page 6

Investigate Access Report Options Page 12

Practice the steps needed to build an Address Block Page 13

Identify the Grow/Shrink Property Page 15

Use the Design Ribbon to add a Group Footer Page 18

Use the Property Sheet to Force a New Page Page 20

Learn how to Export a report to Microsoft Word Page 21

Learn how to create a PivotChart in Access Page 22

Learn how to attach files to a record Page 27

Practice the steps in the Label Wizard Page 31