Microsoft Access 2016 - Intermediate

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