Access - intermediate (In-House)

Ensure the integrity of their databases

Manage field properties

Use the query functions effectively

Save time with the query expression builder

Create different types of query more quickly

Design better forms

Link expressions in forms

Create better and more useful reports

Import and export tables more easily

Identifying relationships

Identifying criteria for data integrity

Applying referential integrity

Managing relationship join types

Field properties overview

Using input mask field

Using default value fields

Using field validation rules

Running aggregate function calculations

Running sum, average, count, max and min functions

Grouping calculated data

Using query operators and expressions

Adding calculated fields to a query

Using the query expression builder

Creating make table queries

Creating append queries

Creating update queries

Creating delete queries

Adding form controls

Aligning and arranging form controls

Adding pictures and labels to forms

Adding new fields to a form

Controlling tab order

Adding command buttons

Adding a combo box control

Formatting data using conditional formatting

Using the form expression builder

Working with a property sheet within a form

Linking expressions within a form

Creating reports with the report wizard

Inserting report fields

Formatting fields

Inserting report headers and footers

Working with a property sheet within a report

Creating groups with the report wizard

Sorting grouped data

Grouping alphabetically

Grouping on date intervals

Creating sub reports

Adding calculations to groups

Importing tables into Access

Exporting tables from Access

Importing and linking data in Access