Access Level 3: Advanced Tools & Forms

Level 3Full Day1 DayVersion 365Official CPE Provider

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.

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

5 lessons · 22 topics

1Structuring Existing Data

Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure

2Writing Advanced Queries

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

3Simplifying Tasks with Macros

Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

4Creating Effective Reports

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish Reports as PDF

5Maintaining an Access Database

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals