Access 2007 - Intermediate

Overview

About this course

Self-paced lessons on intermediate Access 2007: relational concepts, table design, calculations, multi-table and action queries.

Curriculum

Curriculum

11 modules

Introduction

Understanding Relationships
Enforcing Referential Integrity
Modifying and Deleting Relationships

Understanding Field Components
Accessing Field Properties
Using Text-Based Field Types
Using Numeric Field Types
Using Other Field Types
Setting Formats
Setting Input Masks
Adding Captions
Setting Default Values
Setting Validation Rules
Working with Required Property
Working with Indexed Property
Working with Unicode Compression Property

Performing Calculations with Queries
Concatenating Text
Calculating Totals in a Query

Understanding Multi-Table Queries
Creating a Multi-Table Query
Grouping and Counting Totals
Referencing Calculated Fields in Another Query
Fixing WHERE Clause Errors
Calculating the Top Five Customers

Understanding Action Queries
Using Make Table and Append Queries
Using Update Queries
Using Delete Queries

Understanding Parameter Queries
Using a Simple Parameter Query
Using Parameter Queries with Wildcards
Finding Date Ranges
Creating Multi-Parm Queries

Understanding Forms
Understanding The Hidden Table
Resizing Controls
Performing Calculations with Bound Text Boxes
Setting Control Properties

Creating a Combo Box
Creating a Calculated Control
Adding Label and Formatting Control

Using the Report Wizard
Using a Calculated Control to Concatenate Text
Creating Other Calculated Controls
Making the Control Source a Parameter Query
Using Report Bands
Using the GroupSort Panel

Course Recap

Who it's for

Who it's for

Users of Access 2007 building their skills.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.