Sterling Computer Courses

Microsoft Access 2003 - Level 2

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 strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Microsoft Office Access 2003, including tables, queries, forms, reports, and data access pages. The course also shows how to work with individual fields to ensure that overall database structure is consistent and correct. In addition, students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. Finally, students will be introduced to a few methods of managing and backing up database files.

Learn To:

This course covers the following topics:

Format Calculated Fields

Export Data From Access To Other Applications

Format Controls In Reports

Add Calculated Fields Using The Expression Builder

Change Form Properties

Create Crosstab Queries

Add Captions To Fields

Understand Report Sections

Index Fields

Create And Use Hyperlinks In Tables

Look At Data Access Pages

Understand The Lookup Wizard

Align, Resize, And Space Controls

Create Reports In Design View

Create Multi-table Queries

Apply And Use Input Masks

Specify Field Size And Format

Create Hyperlinks In Data Access Pages

Understand Aggregate Functions

Save Forms And Reports As Data Access Pages

Display Queries In PivotChart View

Look At The Expression Builder

Add Option Groups Using A Wizard

Generate And Use Value Lists

Add Bound Controls To Forms

Understand Field Properties

View Object Dependencies

Understand Controls

Add Controls To Headers And Footers

Import Data To Existing Tables

Examine Operators And Expressions

Export Database Data Into XML Files

Learn About XML

Back Up Database Files In Microsoft Office Access 2003

Use Aggregate Functions In Queries

Examine Importing And Exporting

Compact And Repair Databases

Create And Use Lookup Lists

Understand Smart Tags

Add Headers And Footers To Forms

Specify Criteria

Print Database Objects

Create Calculated Controls

Define Tab Order

Create Data Access Pages Using A Wizard

Add Default Values

Use The Documenter

Import XML Files To New Tables

Understand Form Sections

Understand Indexes

Add Calculated Controls To Reports

Propagate Field Properties

Modify Multiple Data Types

Understand Input Masks

Move And Delete Fields

Objectives:

This course will enable students to develop their skills in Access 2003.

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.

Existing customer username (e.g.C4U9283479)

Related Links:

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 Sterling Consultancy

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