Access 2010 - Intermediate

Overview

About this course

Self-paced lessons on intermediate Access 2010: table relationships, advanced table design and action queries with imported data.

Curriculum

Curriculum

8 modules

Introduction

Understanding Table Relationships
The 1 to 1 Relationship
The 1 to Many Relationship
The Many to Many Relationship
Creating a 1 to 1 Relationship
Enforcing Referential Integrity
Creating a 1 to Many Relationship
Creating a Many to Many Relationship

Reviewing the Field Data Types
Setting the Format Property
Using the Input Mask Property
Setting Default Values and Validation Rules
Using the Required and Indexed Properties
Reviewing the Unicode Compression

Importing vs. Linking External Data
Using the Delete Query
Using the Update Query
Using the Make Table Query
Using the Append Query

Calculating Numbers
Calculating Totals and Using Group By
Concatenating Text
Creating Parameter Queries
Using Wildcards with Your Parameter Entry

Reviewing the Invisible Table
Removing a Single Control from the Table
Locking and Hiding a Control
Modifying the Layout
Adding an Unbound Control
Adding Calculated Controls
Adding a Combo Box Control
Changing a Control Type

Using the Report Wizard
Reviewing the Report Bands
Manipulating Controls in a Report
Adding Parameters to a Report
Using a Parameter Query with a Report
Using the Group/Sort Panel

Course Recap

Who it's for

Who it's for

Users of Access 2010 building their skills.

Before you start

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