Access Advanced Training Course

Tables and Fields

• Indexes and their application
• Table validation rules
• Value lists
• Lookup fields
• Creating and utilizing the OLE Object data type

Queries

• Queries utilizing the Union operator
• CrossTab queries
• Logical, date, text, conversion, and aggregate functions
• Identifying duplicate and unmatched records

Forms

• Constructing subforms
• Displaying totals
• Opening subforms in a separate window
• Setting default values for controls
• Switching between form views

Reports

• Nesting records within groups
• Generating multi-column reports
• Designing report templates
• Creating custom "labels"

Charts

• Chart creation
• Embedding charts within forms and reports
• Editing and customizing charts

Macros

• Building simple macros
• Using the Macro Wizard
• Incorporating conditions
• Assigning macros to control events
• Methods for executing macros
• Organizing macro groups
• Utilizing the AutoExec macro
• Utilizing the AutoKeys macro
• Debugging macros in "single step mode"

Switchboard Manager

Data export and import procedures

• Exporting tables and queries
• Exporting reports as snapshots
• Exporting reports to Microsoft Word
• Importing data from external databases
• Importing text files (CSV)
• Importing Excel spreadsheets
• Linking tables from other databases

Database Relational Model and Integrity

• Foreign keys and consistency maintenance strategies
• Cascade delete and update actions for related records
• Methods for joining tables
• Performing inner, outer right, and left joins
• Joining tables without explicit join clauses
• Validating data integrity

Database Tools and Maintenance

• Compacting and repairing the database
• Backup and restore procedures
• Using the Database Documenter
• Database replication
• Synchronization
• Viewing object dependencies

Smart tags

Startup configurations