Microsoft Access 2016 (77-730)

Introduction to Access 2016

• Getting Started
• Working in the Access Interface
• Summary

Creating Database Tables

• Introducing Tables
• Creating a Table
• Saving and Modifying a Table
• Summary

Working with Tables and Database Records

• Navigating Specific Records
• Adding, Updating, and Deleting Records
• Working with Primary Keys
• Finding and Replacing Data
• Sorting and Filtering Data and Setting Field Viewing Options Within a Table
• Understanding Table Relationships
• Summary

Modifying Tables and Fields

• Creating Fields and Modifying Field Properties
• Modifying Database Tables and Fields
• Summary

Creating Forms

• Creating a Form
• Sorting and Filtering Data in a Form
• Summary

Creating Reports

• Creating a Report
• Working With Reports
• Summary

Creating and Modifying Queries

• Creating a Query
• Modifying a Query
• Sorting and Filtering Data in a Query
• Format Fields Within Queries
• Summary

Using Controls in Forms and Reports

• Controls
• Defining Control Tab Order
• Formatting Controls
• Arranging Control Alignment, Size, and Position
• Adjusting Page Margins and Changing Page Orientations for Forms and Reports
• Summary

Understanding Advanced Forms

• Creating Advanced Forms
• Using Application Parts to Create Blank Forms
• Creating and Modifying a Navigation Form
• Summary

Creating Advanced Reports

• Defining Groups
• Creating Aggregate Fields
• Creating a Subform on a Report
• Creating the Print Layout
• Using the Label Wizard
• Summary

Creating Advanced Queries

• Creating Crosstab Queries
• Creating a Subquery
• Filtering and Saving a Filter as a Query
• Creating Action Queries
• Understanding Advanced Query Modification
• Summary

Displaying and Sharing Data

• Creating a Chart Using the Chart Wizard
• Formatting a Chart
• Changing Chart Types
• Saving a Database Object as Another File Type and Printing
• Summary

Importing and Exporting Data

• Importing Data
• Exporting Data
• Saving and Running Import/Export Specifications
• Summary

Understanding Database Tools

• Maintaining a Database
• Using Database Tools
• Encrypting and Decrypting a Database
• Navigating in Access Database
• Improving User Interface Design by Using Macros
• Summary

Appendix: 3D Avatar-based Simulation