Learning Access for Office 365

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

Introduction

• Welcome
• Using the exercise files

1. Get to Know Access 2016

• Why use an Access database
• Load a 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 wizard
• Edit the form in Design view

3. Retrieve Information from the Database

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

Conclusion

• Next steps