Access Advanced Training Course

Tables and Fields

• Indexes and their usage
• Validation rules in tables
• Lists of values
• Search field
• Creating and Using OLE Object data type

Queries

• Queries with Union operator
• Crosstab queries
• Logical, date, text, convert, aggregate functions
• Finding duplicates and unmatched records

Forms

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

Reporting

• Records numbering in groups
• Creating a multi-column reports
• Creating report templates
• Creating user "labels"

Charts

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

Macros

• Creating simple macro
• Macros Wizard
• Adding conditions
• Assigning macros to control events
• Ways to run macros
• Creating a macro group
• Autoexec macro
• AutoKeys macro
• Testing macro in the "single step mode"

Switchboard Manager

Export and import data

• 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 the Database Integrity

• Foreign keys and ways to maintain consistency
• Cascade deletion and updating related records
• Ways to join tables
• Joining internal, external right and left
• Joining tables without the clause "join"
• Testing integrity

Tools and Maintenance of the database.

• Compacting and repairing database
• Backing up and restoring
• Database Documenter
• Database Replication
• Synchronization
• Viewing dependencies between objects

Smart tags

Startup options