Author Description

Note: This is the color version of the Student reference manual designed for instructor-led computer training. Can also be used as a self-paced tutorial for learning the intermediate concepts of Microsoft Access 2016. 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