Sterling Computer Courses

Microsoft Access 2007 - 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 entry-level course introduces students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. They will learn the importance of establishing relationships, as well as how to establish and edit relationships and enforce referential integrity. After learning to manipulate the Access interface and create their own databases, students will discover how to create and use the basic tools of the Access application: tables, forms, filters, sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data.

Learn To:

This course covers the following topics:

Add Tables To The Relationships Window

Organize And Print Relationships

Find Records

Close Access Databases And Exit Access

Modify Columns And Rows

Delete Table Data

Examine Primary Keys

Create And Save AutoReports

Look At The Office Assistant

Delete, Move, And Hide Query Fields

Enter Data In Datasheet View

View Subdatasheets

Understand Reports

Move And Delete Controls

Understand Relationships

Preview Report Pages

Create AutoForms

Create Blank Databases From Scratch

Modify Table Data

Modify Control Properties

Ask Help A Question

Create Table Relationships

Examine The Help Task Pane

Enforce And Test Referential Integrity

View Multiple Tables

Use Filter By Form

Find Duplicate Records

Launch Microsoft Office Access 2003

Understand Tables

Create Forms Using The Form Wizard

Use AutoCorrect

Print Reports

Navigate In Reports

Create Select Queries Using A Wizard

Change The Default File Format In Access

Switch Between Views

Look At Microsoft Office Access 2003

Use The Table Wizard

Align And Space Controls

Look At Form Design View

Understand Data Types

Understand Forms

Navigate Among Records

Understand Queries

Sort Table Data

Create Single-table Queries In Query Design View

Create Tables In Design View And Set Primary Keys

Open Access Databases And Examine The Database Window

Navigate In Tables

Explore And Use The Database Wizard

Modify Page Orientation And Margins

Create Reports Using A Wizard

Understand Filters

Use Filter By Selection And Sort Records

Enter Data Using A Form

Edit Existing Relationships

Find Unmatched Records

Objectives:

This course introduces the student to the basic concepts of Access 2007.

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