Sterling Computer Courses

Microsoft Access 2000 - Level 1

Duration: Approx. 4 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. All skills will be taught using true-life scenarios, examples, review exercises, and concept graphics to help reinforce the material presented.

Learn To:

This course covers the following topics:

Looking At Access

Understanding Relational Databases

Determine Appropriate Data Inputs For Your Database

Determine Appropriate Data Outputs For Your Database

Use The Office Assistant

Select An Object Using The Objects Bar

Opening Database Objects

Create A Database Using A Wizard

Create A Database In Design View

Create Table Structure

Establish Table Relationships

Navigate Through Records In A Table, Query, Or Form

Create Tables By Using The Table Wizard

Set Primary Keys

Modify Field Properties

Use Multiple Data Types

Modify Tables Using Design View

Understanding Forms

Create A Form With The Form Wizard

Use The Control Toolbox To Add Controls - Forms

Modify Format Properties (font, style, font size, color, caption, etc.) Of Controls

Switch Between Object Views

Enter Records Using A Datasheet

Enter Records Using A Form

Delete Records From A Table

Find A Record

Sort Records

Apply And Remove Filters (filter by form and filter by selection)

Specify Criteria In A Query

Display Related Records In A Subdatasheet

Create And Modify A Multi-table Select Query

Establish Relationships

Enforce Referential Integrity

Understanding Reports

Create A Report With The Report Wizard

Preview And Print A Report

Import Data To A New Table

Print Database Relationships

Objectives:

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

Work with tables

Enter, import, sort, and delete data

Create relationships

Use forms and filter data

Explore queries and use reports

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