Overview
-
New to databases? Get an overview of Access 2016, including building tables, defining relationships, and creating queries and reports.
Syllabus
-
Introduction
- Welcome
- Use the exercise files
- 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
- 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
- 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
- Next steps
