Sterling Computer Courses

Microsoft Access 2002 - 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 strives to broaden and develop 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 Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various maintenance features are covered, teaching students ways to better manage multi-user databases. 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:

Create And Modify Lookup Fields

Understand Input Masks

Create And Modify Custom Input Masks

Understand Validation

Set Validation Parameters

Understand How To Optimize Data Type Usage

Understand Multiple-field Primary Keys

Create Multiple-field Primary Keys

Examine One-to-many And One-to-one Relationships

Establish One-to-many Relationships

Examine Many-to-many Relationships

Establish Many-to-many Relationships

Look At Cascade Updates And Deletes

Use Cascade Updates And Cascade Deletes

Look At Relationship Joins

Specify Join Properties

Specify Criteria In Multiple Fields

Apply Filters To Queries

Create Parameter Queries

Look At Action Queries

Create Update Queries

Understand Aggregate Functions

Use Aggregate Functions In Queries

Create Forms In Design View

Examine Subforms And Subreports

Add Subform Controls To Forms

Look At Switchboards

Create Switchboards

Set Startup Options

Create Reports In Design View

Add And Modify Images

Group And Sort Report Data

Add Subreport Controls To Reports

Look At The Data Access Page Designer

Create Data Access Pages In Design View

Group Data In Data Access Pages

Explore Access PivotTables And PivotCharts

Add PivotTables To Data Access Pages

Add PivotCharts To Data Access Pages

Become Familiar With XML

Import XML Documents Into Access Databases

Export Database Data Into XML Documents

Examine Security Issues

Set Database Passwords

Modify Database Passwords

Encrypt And Decrypt Databases

Understand The Table Analyzer Wizard

Explore Database Replication

Replicate Databases

Use The Database Splitter

Explore Data Linkage And The Linked Table Manager

Link Tables From Different Databases

Create MDE Files

Compact And Repair Databases

Become Familiar With VBA

Understand Modules

Create Modules

Create Buttons And Assign Modules

Objectives:

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

Customize field properties

Define relationships

Create advanced queries

Produce reports

Create forms

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