New to databases? Get an overview of the Office 365 version of Access, including building tables, defining relationships, and creating queries and reports.
Overview
Syllabus
Introduction
- Welcome
- Using the exercise files
- 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
- 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
- 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
- Next steps
Taught by
Adam Wilbert