Course Title:

Duration:

Prerequisites:

Overview of Intermediate Concepts

As a basis for further training

Building a Relational Database

Designing a Relational Database
Normalisation of Data; De-Normalisation
Primary and Secondary Keys
Setting up Indexes; Creating an Index
Multiple Field Indexes; Maintaining Data Integrity
Setting Field Properties; Using Validation Rules
Setting Table Relationships
Creating Input Masks; Using Lookup Fields
Optimising Data Type Usage
An Example Relational Model
Types of Relationship Links; Primary and Foreign Keys
Relationships and Referential Integrity

Creating Relational Queries

Working with Related Tables in Queries
Setting Joins Types in Queries
Find Unmatched Query; Find Duplicates Query
Filtering a Query Recordset
Optimising Queries

Calculating in Queries

Summary queries; Crosstab Queries
Modifying Query Properties

Action Queries

Action Queries; Make Table Queries
Insert Queries; Delete Queries; Update Queries

Database Management Tools

Database Management; Setting a Database Password
Encrypting and Decrypting a Database
Compacting a Database
Repairing a Database
Replicating a Database
Using Add-ins
Converting a Database to a Previous Version

Advanced Forms Features

Using Advanced Forms Features
Multi-Table Forms; The Form Worksurface
The Toolbox; Bound and Unbound Controls
Inserting Graphics on Forms
Creating a Calculated Control
The Expression Builder
Customising headers, Footers and Detail Sections
Synchronising Forms
Creating a Switchboard

Producing Reports

Creating Reports
Applying Sorting and Grouping to Reports
Performing Calculations on Reports
Creating Custom Report Pages
Using the Chart Wizard; Using the Label Wizard

Customising Menus and Toolbars

Creating Custom Menus and Toolbars
Customising Menus and Toolbars

Macros and Command Buttons

Creating a Macro
Macro Examples
Designing Application Menus
Creating a Menu Form
Setting Startup Defaults

Multi-User Databases

Shared Databases
Setting Default Locking Properties
Creating Groups and Users
Setting user Permissions
Assigning Ownership

Access Introduction | Access Intermediate | Access VBA

Back to Top