Computrain IT Training

Microsoft Access Foundation

Objectives and Overview

This one-day course is designed to give you an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Who should attend?

New, recent or intending users of Microsoft Access who have little or no existing database knowledge.

Course prerequisites

A basic understanding of Windows user interface or equivalent experience with Windows recommended. Some experience of using Microsoft Word will be of help to delegates, but is not required.

Understanding Databases

Start Access and Opening an Existing Database • Moving Around in Access • Understanding Datasheet View and Design View • Using the Mouse Pointer to Navigate in Datasheet View • Using the Keyboard to Navigate in Datasheet View

Creating Tables

Creating a Database • Creating a Table Using the Table Wizard • Creating and Modifying a Table in Design View • Adding Fields to Tables • Adding and Editing Records • Printing Tables • Moving and Deleting Fields • Deleting Records

Working with Tables

Formatting a Table • Modifying Field Properties • Sorting Records in a Table • Finding Records in a Table • Using Filters with a Table • Establishing Relationships between Tables • Creating Subdatasheets • Importing Records from an Existing Source

Creating and Using Queries

Creating and Running a Query • Specifying Criteria in a Query • Using Comparison Operators in a Query • Creating a Calculated Field • Creating a Multiple-Table Query • Printing a Query

Designing a Form

Creating a Form using AutoForm • Creating a Form Using the Form Wizard • Adding Controls to a Form • Modifying Control Properties • Resizing and Moving Controls • Navigating in a Form • Entering Records into a Form • Creating Calculated Controls

Designing a Report

Creating a Report Using AutoReport • Creating a Report Using the Report Wizard • Adding a Control to a Report • Formatting a Report • Resizing and Moving Controls in a Report • Creating Calculated Controls • Previewing and Printing a Report