Access Advanced Training Course

Tables and Fields

• Indexes and their application
• Validation rules within tables
• Value lists
• Search fields
• Creating and utilizing OLE Object data types

Queries

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

Forms

• Creating subforms
• Viewing totals
• Opening subforms in a new window
• Setting default values for controls
• Changing form views

Reporting

• Numbering records within groups
• Creating multi-column reports
• Developing report templates
• Creating user "labels"

Charts

• Creating charts
• Embedding charts in forms and reports
• Editing and modifying charts

Macros

• Creating simple macros
• Using the Macros Wizard
• Adding conditions
• Assigning macros to control events
• Methods for running macros
• Creating macro groups
• Autoexec macro
• AutoKeys macro
• Testing macros in "single step mode"

Switchboard Manager

Data export and import

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

Database Relational Model and Database Integrity

• Foreign keys and methods for maintaining consistency
• Cascade deletion and updating related records
• Methods for joining tables
• Joining tables using internal, external, right, and left joins
• Joining tables without the "join" clause
• Testing integrity

Database Tools and Maintenance.

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

Smart tags

Startup options