Microsoft Access & Design

MICROSOFT ACCESS & DESIGN

Access is the latest database from Microsoft designed specifically for a graphical environment. This 2 day course is designed to give you a further understanding of the features and functions available in Access to a level of competence sufficient for participants to produce more sophisticated database application; to be able to create a variety of data views, queries and reports including cross-tabs; and to automate their application through the use of menus, macros and buttons.

Performance & Database Design

Database Design; Indexes & Keys; Creating an Index

Which Fields should be indexed?

Multiple Field Indexes; Relational Database Design

Designing Tables; Creating a Relational Model

Different Types of Links;

Primary Keys; Relationships & Referential Integrity

Using Look-Up Fields

Table Definition Components

Field Name; Data Type; Creating a Related Table

Using Look-up Field; Relating to an AutoNumber Field

Setting Size of a Number Field; Setting a Multi-Field Primary Key

Designing Multi-Table Forms

Advantages of Forms in Access; AutoForm

Creating Multi-Table Forms; Advantages of using Subforms

Creating a Form Using Multiple Tables

The Form Design Work Surface

The Object Property Sheet; The Field List; The ToolBox

Advanced Forms Design

Calculated Fields; Expression Builder;

Field Display Types Command Buttons

Reporting

Report Wizard; Tabular Reports

Importing Data

Importing/Linking Tables from External Sources

Querying a Database

What is a Database Query? Criteria

Table Joins in Queries; Different Join Types

Parameter & Crosstab Queries

Find Duplicates & Unmatched Query

Make Table

Append / Update / Delete

Events on Forms

Attaching Macros to Events

Macros

What is a Macro? The Macro Window

Setting Conditions in Macros

Macros in a Form / Menu

Database Splitter

Compact and Repair Database

Table Analyzer!

Return to menu