Intermediate Access Training Classes in Denver Colorado

This class builds on the concepts taught in Access Basic and covers more advanced features with the program. The class does not cover VBA or SQL integration concepts.

Training Class Goal

Students coming from this class will have skills for developing more advanced Access databases and extracting advanced reports from their databases.

Prerequisites

Basic Access skills including: navigation, creating and using databases in both design and datasheet view, creating basic reports, queries and forms.

Training Topic Covered

• Relational databases
• Database normalization
• Table Relationships
• Referential integrity
• Creating lookup fields
• Sub-datasheets
• Complex queries
• Joining tables in a query
• Using calculated fields
• Summarizing and grouping values
• Advanced form design
• Adding unbound controls
• Graphics
• Adding combo boxes
• Reports and printing
• Customized headers and footers
• Calculated values
• Labels
• Charts in forms and reports
• PivotTables and PivotCharts