Sterling Computer Courses

Microsoft Access 2002 - Level 2

Duration: Approx. 5 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 intermediate 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 Access, 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. The material 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:

Edit Field Names

Move And Delete Fields

Modify Multiple Data Types

Understand Field Properties

Add Captions To Fields

Add Default Values

Understand Indexes

Examine Importing And Exporting

Import Data To Existing Tables

Export Data From Access To Other Applications

Understand The Lookup Wizard

Create And Use Lookup Lists

Generate And Use Value Lists

Understand Input Masks

Use The Input Mask Wizard To Apply And Use Input Masks

Create Multi-table Queries

Examine Operators And Expressions

Specify Criteria

Delete, Move, And Hide Query Fields

Look At The Expression Builder

Use The Expression Builder To Add Calculated Fields

Understand Form Sections

Add Headers And Footers To Forms

Understand Controls

Add Bound Controls To Forms

Create Calculated Controls

Add Options Groups Using The Option Group Wizard

Understand Report Sections

Add Headers And Footers To Reports

Move And Resize Controls

Change Report Format Properties

Add Bound Controls To Reports

Add And Modify Unbound Controls In Reports

Add Calculated Controls To Reports

Look At Data Access Pages

Use The Page Wizard To Create A Data Access Page

Save Forms And Reports As Data Access Pages

Understand Hyperlinks

Create And Use Hyperlinks In Tables

Look At Data Backups

Back Up Databases

Restore Databases

Use The Documenter

Objectives:

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

Modify table structure

Modify table field properties

Import and export data

Use the Lookup wizard and Input Mask wizard

Create and modify 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.

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