Sterling Computer Courses

Microsoft Access 2003 - Level 3

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 advanced course broadens the intermediate 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, including tables, queries, forms, reports, and data access pages. In addition, the course introduces students to advanced development features so that they can provide user-friendly databases to their users. The students will learn how to develop data entry tools and automated processes, how to enforce database security, and how to implement maintenance features. The material in the course is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered.

Learn To:

This course covers the following topics:

Move And Delete Fields

Modify Multiple Data Types

Create And Use Hyperlinks In Tables

Understand The Lookup Wizard

Create And Use Lookup Lists

Generate And Use Value Lists

Understand Input Masks

Apply And Use Input Masks

Understand Field Properties

Add Captions To Fields

Add Default Values

Understand Smart Tags

Propagate Field Properties

Specify Field Size And Format

Understand Indexes

Index Fields

Examine Importing And Exporting

Import Data To Existing Tables

Export Data From Access To Other Applications

Learn About XML

Import XML Files To New Tables

Export Database Data Into XML Files

Create Multi-table Queries

Examine Operators And Expressions

Specify Criteria

Create Crosstab Queries

Display Queries In PivotChart View

Look At The Expression Builder

Add Calculated Fields Using The Expression Builder

Format Calculated Fields

Understand Aggregate Functions

Use Aggregate Functions In Queries

Understand Form Sections

Add Headers And Footers To Forms

Understand Controls

Add Bound Controls To Forms

Create Calculated Controls

Add Option Groups Using A Wizard

Define Tab Order

Change Form Properties

Understand Report Sections

Create Reports In Design View

Add Calculated Controls To Reports

Add Controls To Headers And Footers

Format Controls In Reports

Align, Resize, And Space Controls

Look At Data Access Pages

Save Forms And Reports As Data Access Pages

Create Data Access Pages Using A Wizard

Create Hyperlinks In Data Access Pages

View Object Dependencies

Use The Documenter

Print Database Objects

Compact And Repair Databases

Back Up Database Files In Microsoft Office Access 2003

Objectives:

This course will broaden students skills within 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.

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