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.