Access Advanced Training Course

Tables and Fields

• Indexes and their application
• Validation rules within tables
• Value lists
• Search fields
• Creation and utilization of OLE Object data types

Queries

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

Forms

• Building subforms
• Displaying totals
• Opening subforms in a separate window
• Configuring default values for controls
• Switching form views

Reporting

• Numerating records within groups
• Designing multi-column reports
• Developing report templates
• Creating custom "labels"

Charts

• Generating charts
• Incorporating charts into forms and reports
• Editing and customizing charts

Macros

• Developing basic macros
• Utilizing the Macros Wizard
• Incorporating conditional logic
• Linking macros to control events
• Methods for executing macros
• Constructing macro groups
• Autoexec macro
• AutoKeys macro
• Debugging macros in "single-step mode"

Switchboard Manager

Data export and import functionalities

• 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 Data Integrity

• Foreign keys and strategies for maintaining consistency
• Cascade deletion and updating of related records
• Methods for joining tables
• Performing inner, outer, right, and left joins
• Joining tables without explicit join clauses
• Verifying data integrity

Database Tools and Maintenance

• Compacting and repairing the database
• Backing up and restoring data
• Using the Database Documenter
• Database replication
• Synchronization
• Viewing object dependencies

Smart tags

Startup options