An introduction to Access 97/2000

Overview / who should attend and why?

This course is designed to introduce the user to the basic functions of Access.  Targeted at anyone who needs to learn the basic skills necessary to start using Microsoft Access.

No previous experience of using Access or any other database is required for the introductory course.

Course Objectives

• Start and exit from Access
• Create a new database and a new table
• Use the autoform wizard to create a form
• Enter and edit records in both datasheet view and form view
• Print the datasheet of a table
• Search through and sort records
• Create and run a query
• Use the autoreport wizard and report wizard to create a report

Course Content

Getting started

• What is Access? Starting Access; the Access application window
• Working with Access menus; basic Access terminology
• Examining Access objects
• Resetting the database folder; displaying help information
• Exiting from Access

Setting up a new database

• Designing and creating a new database and a new table
• Entering records in datasheet view
• Printing the datasheet of a table
• Navigating through records in datasheet view
• Closing a table; closing a database

Creating a form/modifying and manipulating data

• Reopening a database; reopening a table
• Creating a form
• Navigating through records in form view; closing a form
• Reopening a form
• Switching between form view and datasheet view
• Entering records in form view
• Using the find feature
• Editing and deleting records in datasheet view and form view
• Modifying the datasheet view of a table
• Sorting the records in a table

Displaying selected records

• Creating and applying a filter
• Creating, running and modifying a query
• Including a numeric condition and calculated field in a query

Creating a report

• Creating a simple and grouped tabular report
• Modifying a report

Additional Access features

• Using the spelling checker
• Copying, renaming and deleting database objects
• Importing spreadsheet data into an Access table

Modifying the design of a table

• Displaying a table in design view
• Specifying a required field; defining a default field value
• Setting a primary key and adding a memo field to a table
• Additional table design topics

Working with multiple tables

• Displaying multiple tables on the Access desktop
• Resizing and repositioning the table window

Relating tables

• Creating a relationship between two tables

Working with a custom form

• Designing a custom form
• Adding a header, footer and calculated control to a form
• Using a custom form to enter data

Costs / Duration and Location

• The cost of this training course is £400 + VAT 
• The duration is two days 9:00 till 16:00
• Various dates and locations, see course calendar or contact us for further information