Learning Access 2016

New to databases? Get an overview of Access 2016, including building tables, defining relationships, and creating queries and reports.

Introduction

• Welcome
• Use the exercise files

1. Get to Know Access 2016

• Why use an Access database
• Load a premade template database
• Enter data in the Task Management database
• Explore the Access interface
• Understand database objects
• Add data to a table
• Run a report

2. Build Your Own Database

• Define data types
• Create a table
• Import data from an Excel workbook
• Define table relationships
• Build a data entry form using the Form Wizard
• Edit the form in Design view

3. Retrieve Information from the Database

• Create a query using the Query Wizard
• Edit queries in Design view
• Create a report using the Report Wizard
• Edit the report in Layout view
• Add buttons to the form
• Adjust the database startup options

Conclusion

• Next steps