Access Advanced 2007 - 2010

Access Application Design

· Planning an application

· Building a graphical user interface

· Connecting database objects

Relational Database Design

· Designing Tables

· Normalisation

· Establishing relationships between tables

Designing Macros

· Creating Macros

· Macro Groups

· Conditions in Macros

· Stepping through a Macro

Designing Macros for Forms & Reports

· Events

· Setting Values

· Print Forms

· Finding Records

· Validating Data

· Designing Macros to Filter

· Import/Export Data

· Filter Macros

Export & Import Macros

Customising Access Startup

· Startup Options

· Autoexec Macros

· Splash Screen

· Custom Menus & Toolbars

· Building a custom menu

· Building custom toolbars

· Assigning menus & toolbars to forms

Security

· User-Level Security

· Documentation:

· Documenting your application

· Using the Database Documenter