Sterling Computer Courses

Microsoft Access 2000 - Level 3

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 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 in the course, 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 A Select Query In Design View

Understanding Form Design View

Set Validation Text

Define Data Validation Criteria

Modify An Input Mask

Create And Modify Lookup Fields

Optimize Data Type Usage (double, long, int, byte, etc.)

Create A Form In Design View

Insert A Graphic On A Form

Modify Control Properties

Customize Form Sections (headers, footers, detail)

Modify Form Properties

Use The Subform Control And Synchronize Forms

Create A Switchboard

Apply Filters (filter by form and filter by selection) In A Query's Recordset

Create A Totals Query

Create A Parameter Query

Specify Criteria In Multiple Fields (AND vs. OR)

Modify Query Properties (field formats, caption, input masks, etc.)

Create An Action Query - Update Query

Create An Action Query - Delete Query

Create An Action Query - Append Query

Optimize Queries Using Indexes

Specify Join Properties For Relationships

Insert A Graphic On A Report

Modify Report Properties

Create And Modify A Report In Design View

Modify Control Properties

Set Section Properties

Use The Subreport Control And Synchronize Reports

Establish One-to-one Relationships

Establish Many-to-many Relationships

Set Cascade Update And Cascade Delete Options

Create Hyperlinks

Use The Group And Sort Features Of Data Access Pages

Create A Data Access Page

Set And Modify A Database Password

Set Startup Options

Use Add-ins (Database Splitter)

Use Add-ins (Analyzer)

Use Add-ins (Link Table Manager)

Encrypt And Decrypt A Database

Use Simple Replication (copy for a mobile user)

Run Macros Using Controls

Create A Macro Using The Macro Builder

Convert Database To A Previous Version

Export Database Records To Excel

Drag And Drop Tables And Queries To Excel

Present Information As A Chart (MS Graph)

Link To Existing Data

Objectives:

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

Create lookup fields

Define relationships

Modify form properties and use the subform control

Create and run macros

Use Access tools while integrating Access with other applications

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