Access 2016 Intermediate Quick Reference

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use intermediate level features of Microsoft Access 2016. See topics below.

See also our related guide: Access 2016 Introduction.

Table Design: Preventing Data Entry Errors, Find and Sort More Quickly With Indexing, Joining Tables to Create Relationships, Deleting a Table Join, Preventing Orphaned Data with Referential Integrity.

Query Design: Dynamic Criteria with Parameter Queries, Examples of User Input Criteria, Performing Calculations, Summarizing Selected Data.

Form Design: Adding Form Controls, Modifying Form Controls, Sorting Records, Setting Tab Order.

Report Design: Summarizing by Group, Printing Options (Page Breaks, Columns, Publish to Word). Merging Data with a Word Document.