Sterling Computer Courses

Microsoft Access 2002 - Level 1

Duration: Approx. 6 hours.

This product is an online product and is a Single user, 1 Year licence.

Screenshots:

(click on a screenshot for a bigger picture) Images are representative of this product.

Overview:

This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective database should be designed and set up. After they learn how to create their own databases in Access, students will receive instruction in how to create and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data. This course will also cover the new features in Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane. The material is presented through explanatory text, real-world scenarios, and interactive steps.

Learn To:

This course covers the following topics:

Look At Access

Launch Access

Explore Task Panes

Open Access Databases And Examine The Database Window

Look At The Office Assistant

Disable The Office Assistant

Change The Access 2002 Default File Format

Close Access Databases And Exit Access

Understand Relational Databases

Understand Database Design

Explore And Use The Database Wizard

Create Blank Databases From Scratch

Understand Tables

Examine Primary Keys

Use The Table Wizard

Understand Data Types

Create Tables In Design View And Set Primary Keys

Change And Save Field Properties

Enter Data In Datasheet View

Modify Columns In Datasheet View

Modify Table Data

Sort Table Data

Delete Table Data

Understand Relationships

Add Tables To The Relationships Window

Create Table Relationships

Enforce Referential Integrity

Edit Existing Relationships

Organize And Print Relationships

View Subdatasheets

Understand Forms

Create Forms Using The Form Wizard

Navigate Among Records

Enter Data Using A Form

Look At Form Design View

Add Form Controls And Modify Control Properties

Use Multiple Undo

Understand Filters

Use Filter By Selection And Remove Filters

Use Filter By Form

Understand Queries

Look At Query Design View

Create Single-table Queries In Query Design View

Look At Query Wizards

Use The Simple Query Wizard To Create Select Queries

Understand Reports

Create And Save AutoReports

Use The Report Wizard To Create And Format Reports

Preview Report Pages

Print Reports

Examine The Ask A Question Feature

Ask Help A Question

Examine The Help Window

Use The Answer Wizard

Use The Help Mouse Pointer

Objectives:

Once you have completed this course, you will be able to:

Work with tables

Create relationships

Use forms

Filter data

Explore queries

Price:

~~Normal Price: £80.00 (excl. VAT)~~

Special Offer Price: £50.00 (excl. VAT)

YOU SAVE: £30.00 (37.5%)

To purchase this online course, click the "Buy Now" button below. If you have bought a course from us before please enter your username before clicking "Buy Now". If you are a new customer, leave this field blank.

General:

Home Course Log-in Instructions Contact Us

Online Course Categories:

PC Basics Microsoft Office Microsoft Outlook Misc.

Sister Sites:

Associated Training Corporate Site Associated Training Associated E-Training Sterling Safety Training Sterling Financial Training UK Business Training Sterling Languages Sales Training Courses UK Management Training Courses UK Communication Skills Training Media First

To contact us, please e-mail: contact@sterlingcomputercourses.co.uk

Sterling Computer Courses.co.uk is a division of:

Sterling Consultancy (UK) Ltd
10 Wheatcroft Business Park
Landmere Lane, Edwalton
Nottingham
NG12 4DG

Telephone: 0115 984 9940 | Fax: 0115 921 5352