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
()
Ex_Files_Access_2016_Basics.zip
(3.5 MB)