Access 2002-2003

Introduction Level Course

Description
This course aims to provide participants with the skills and knowledge to build multi-table databases in Access. It is a complete course at the end of which participants will have constructed a working, practical database application.

Learning Outcomes

Upon completing this course, participants will be able to:

• Start Access and understand the interface
• Plan and understand the structure of a database table
• Design a database structure
• Create the database file and tables for a relational database
• Set relationships between tables
• Add records to tables
• Import data from other sources into a database
• Work with records in a table
• Perform table data validations
• Create queries in a relational database
• Create a wide range of Select queries
  

Pre-requisites

• Understanding of computers and the ability to use them comfortably. 

Course Content

Access Orientation

Overview of Access 

Starting Access 

The Access Screen

The Database Window

Working With Database Objects

Working With The Menus

Using Keyboard Shortcuts

Short and Long Menus

Exiting From Access 

Database Theory

Overview Of Databases

How Access Stores Data

Spreadsheets Versus Databases

The Advantage of Tables

Database Objects in Access 

Database Design

Designing a Relational Database

Scoping The System

Determine The Inputs

Normalise The Table

First Normal Form

Second Normal Form

Third Normal Form

A Series of Related Tables

Creating The Database

Creating A Database Application

Creating A New Database File

Creating A New Table

Creating A Primary Key

Saving The Table

Modifying A Table Structure

Creating A Table From A Shortcut

Working With Numbers

Creating The Additional Structures

Setting Relationships

Table Relationship Overview

Accessing The Relationships Window

Creating Relationships

Saving The Relationships

Editing A Relationship

Printing The Relationships

Adding Records

Data Entry Overview

Adding Records Directly To A Table

Adding Records With An AutoForm

Data Entry Key Violations

Data Integrity Violations

Importing Records

Overview Of Importing Records

Importing From A Spreadsheet

Importing From A Text File

Backing Up A Table

Importing And Key Violations

Deleting An Unwanted Table

Data Integrity Issues

Working With Records

Managing Data Overview

Navigating Records In A Table

Editing A Record

Deleting Records

Finding And Replacing

Undoing An Error

Compacting A Database

Tables And Sub Datasheets

Assigning A SubDatasheet

Validating Data

Data Validation Overview

Default Values

Required Fields

Validation Rules And Text

Creating A Look-Up

Testing The Validations

Creating Relational Queries

Querying Overview

Creating A Query Design

Understanding The Query Design Window

Selecting Fields For Output

Adding Tables To A Query

Working With Fields In A Query Grid

Selecting Records

Saving And Reusing A Query

Modifying A Saved Query

Select Queries

Overview of Select Queries

Creating AND Queries

Creating OR Queries

Creating Ranges

Opposite Values

Using Wildcards

Problem Selects