Access Level 3: Advanced Tools & Forms
Advanced Access for people who manage real data. Restructure tables, write the queries most users never reach - crosstab, subquery, unmatched - automate routine work with macros, and keep your database healthy as it grows.
Scheduled dates
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 objective
Students will restructure existing data, write advanced queries including crosstab and PivotTable analysis, automate tasks with macros, create effective reports, and maintain and document an Access database.
Prerequisites
To ensure your success, we recommend that you have experience with intermediate Access features such as action and parameter queries, subforms, and customized reports. Students can obtain this level of skill through our Access Level 1 and 2 courses.
Course outline
- Restructure the Data in a Table
- Create a Junction Table
- Improve the Table Structure
- Create SubQueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Publish Reports as PDF
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database