Microsoft Access Intermediate Training Course

Click here to Buy MS Office today!

Microsoft Access Intermediate

Course Aims

This course is designed to show users how to improve their Access databases. We will learn how to create more advanced queries, connect to other data sources and design friendlier user interfaces.

Pre-requisites

Users should be able to do the following within an Access database:-

• Create Tables

• Create simple Select Queries

• Create Forms and Sub Forms

An understanding of database design and relationships is recommended, although this topic is refreshed at the start of this course.

Course Outline:

Database Design Refresher

Designing a database

Primary and Foreign Keys

Relationships and Referential Integrity

The Lookup Wizard

Using the Lookup Wizard

Pros and Cons of using Lookups

Amending a Lookup

Connecting to Other Data Sources

Importing Data

Linking Data

Connecting to Access Data

Connecting to Excel Data

Connecting to ODBC Data

Splitting a Database

Select Queries

Changing a Queries Join type

Finding unmatched data

Hiding duplicate data

Top Values

Parameter Queries

Using Functions in Queries

Iif() function

Date() function

DateAdd() function

Format() function

Other Queries Techniques

Crosstab Queries

Provide query parameters from a Form

Making a parameter optional

Form Design

Changing Form Properties

Tab Order

Conditional Formatting

Creating Switchboards

Using Command Buttons

Creating Search boxes

Report Design

Creating Summary fields

Creating Conditional Summaries

Using Sub Reports

Inserting Charts into Reports

Displaying parameters in a report