Microsoft Access Training: Introduction

Description

On completion of the course the delegates will understand basic database concepts and terminology, and be able to produce their own Access database, design and create tables, select specific records from queries and produce reports.

Pre-Requisites

No prior experience of Access is required for this course, though delegates are expected to be familiar with a Microsoft Windows environment.

Course Content

Introduction

What is a database?
Preparing a database

Creating a Database

Blank database
Table design view/datasheet view
Creating a table, inserting fields, data types and field properties

Modifying a Table

Adding and deleting a record
Changing column widths
Freezing columns
Hiding and moving columns
Changing field properties

Sort, Find and Filter

Sort alphabetically in a table
Finding and editing records
Filter by selection and form

Creating Queries

Creating a new query
Selecting criteria
Modifying a query
Using relational operators

Creating a Report

Using report wizard
Tabular reports
Modifying a report

Format

This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.

Duration

This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.