Microsoft Access Training Course 2003 Introduction

Overview and objectives of the Microsoft Access Training Course

This Microsoft Access Training Course is designed to help you  create a simple databases. You will learn to design tables and queries and to create forms and reports using built-in tools.

Who is this Microsoft Access Training Course for?

If you want to be able to create simple databases or modify existing databases, this course is for you!

Microsoft Access Training Course prerequisites

You should have basic knowledge of Microsoft Windows and be able to start an application, get help, and open, close, and save files.

Microsoft Access Training Course Contents

Basic Database Concepts

Understand what a database is, Recognise the advantages of using a computer database, Know the function of the main database objects (table, query, form, report)

What is Microsoft Access?

Recognise the different elements of the Access screen, Create a new blank database, Select a database object using the Objects Bar, Open and close an existing database, Log on to an existing database, Make a backup copy of a database file

Adding and Editing Records in Microsoft Access

Enter records using a datasheet, Undo changes to a field or record, Navigate through records in a datasheet, Find a record, Check spelling in a datasheet, Replace data, Delete records from a table

Using a Datasheet  in Microsoft Access

Modify the layout and formatting of a datasheet, Sort records by a single field or by more than one field, Apply and remove a filter, Use Filter by Selection or Filter by Form, Use basic operators to construct simple criteria expressions

Designing a Table in Microsoft Access

Determine data inputs and outputs for a database, Create a table in design view, Use multiple data types, Set a primary key, Switch between design and datasheet views and different object windows, Modify basic field properties (size, format), Delete a table

Using a Form in Microsoft Access

Understand the differences between a form and a datasheet, Use AutoForm to generate a simple form, Save and close a form, Create a form with the Form Wizard, Open an existing form, Enter and edit records using a form, Navigate through records in a form, Add, delete, and modify records using a form, Find, sort, and filter records using a form, Delete a form, Add a label to a form header or footer

Using a Select Query in Microsoft Access

Understand the differences between a query and a sort or filter, Create a query using the Simple Query Wizard, Add, remove, and hide query fields, Sort query results, Run, save, close, open, and delete a query

Using Criteria Expressions in Microsoft Access

Select records by a single criterion, Create an expression, Select records using multiple criteria