Access 2019 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 2019 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). Adding Modern Charts to Forms and Reports.