Access 2007 - Advanced

Overview

About this course

Self-paced lessons on advanced Access 2007: application design, subforms, dialog boxes, passing values to queries, controls and macros.

Curriculum

Curriculum

12 modules

Introduction

The Access Development Phases
Putting the Entire Database on a Server
Splitting the Database
Creating a Database Project

Creating a Subform Automatically
Creating a Subform Manually
Linking a Subform
Referencing Controls in a Subform

Understanding Dialog Boxes
Creating a Dialog Box
Setting Dialog Box Properties
Setting Dialog Events

Examining the Query and Form
Using the Expression Builder

Using the Option Group Control
Using the Command Button Control
Using the Combo Box Control

Understanding Macro Types
Creating a Simple Macro

Understanding Macro Groups
Creating a Macro Group

Understanding Conditional Macros
Creating a Conditional Macro
Using the StopMacro Command
Fixing Syntax Errors
Handling a False Condition
Validating Input

Importance of Documenting the Database
Using the Database Documenter
Setting Autostart Options
Setting a Password

Data First
Table Properties
Form Design
Follow Windows
Close Buttons
Simple is Best

Course Recap

Who it's for

Who it's for

Users maintaining Access 2007 databases.

Before you start

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