Access Level 3: Advanced Tools & Forms

Level 3Full Day1 DayVersion 365Official CPE Provider

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