Note: This is the black & white version of the instructor guide designed for instructor-led classroom training and is meant to be used with our companion student training manuals for Microsoft Access 2016: Intermediate.

For the black and white instructor guide, search for ISBN-13: 978-1544689333 For the color instructor guide, search for ISBN-13: 978-1544711706 For the color student manual, search for ISBN-13: 978-1544689234 For the black and white student manual, search for ISBN-13: 978-1544689111

To download the exercise files that accompany this title, please visit http: //www.ezref.com/exercise-files/

For information regarding unlimited printing with the ability to customize our courseware, please visit our website: www.ezref.com

Topics Covered for Microsoft Access 2016 - Intermediate (6-8 hours): Importing Spreadsheets Publishing a Database Object Creating a Primary Key Converting Field Types Changing Field Sizes Custom Display Formats Input Masks Using the Lookup Wizard Assigning Captions Setting Default values Using the Expression Builder Creating Validity Rules & Text Creating Queries Saving/Opening Queries Using Wildcards Compound Queries Creating calculated Controls Using Summary Operators Querying Multiple Tables Action Queries Creating Permanent Relationships Enforcing Referential Integrity Creating Custom Reports Saving/Opening Reports Creating Custom Forms Saving/Opening/Printing Forms Database Properties