Microsoft Access 2016 - Intermediate

Note: This is the color 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...
More Description

Note: This is the color 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