Scheduled dates
No public dates scheduled yet
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course outline
Getting Started with Access
- Identify the Elements of the Access Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
Building the Structure of a Database
- Create a New Database
- Create a Table
- Manage Tables
- Establish Table Relationships
Managing Data in a Table
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
Querying a Database
- Create a Query
- Add a Calculated Field to a Query
Designing Forms
- Create a Form
- View and Edit Data Using an Access Form
Generating Reports
- Create a Report
- Add a Control to a Report
- Format the Controls in a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print