The class provided much hands on practice and explained the high level concepts necessary to produce valid structured... More Testimonials »

Access 2003 eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses
Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this Access 2003 eLearning course individually as well. Just click on the "Register Now" button below.

Access 2003 eLearning Course Series (22 hours)

The Access 2003 series of courses starts off with an overview of both database concepts in general and Access in particular. Learners then find out how to design, build, and use Access tables. Further topics include using queries, find, filter, and sort to unearth answers from data. Learners finally move on to the Access report system and delve into wizards, timesaving tips, and even a bit of programming.

Self-Paced Access 2003 eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn Access 2003 online with these interactive online Access 2003 courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Access 2003 courses
  • Retake the Access 2003 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Access 2003:1 Introduction to Access (Time: 2 hours)

This eLearning course provides an overview of the Access 2003 Interface, toolbars and menus. It also covers how to open, close, save, backup, and request help.

Course Objectives

  • Start Access
  • Open an existing database
  • Modify reporting results
  • Save, close and back up a database
  • Use the toolbar and menus
  • Use Access help

Course Topics

  • Opening an existing database
  • Using the database window
  • Modifying and reporting results
  • Saving, closing and backing up the database
  • Understanding the interface
  • Using the toolbar and menus
  • Accessing help

2. Access 2003:2 Designing and Building Tables (Time: 3 hours)

This eLearning course shows learners how to use Access 2003 to design and build tables and an index. It also covers working with fields, primary keys, and records.

Course Objectives

  • Build a simple database
  • Create and open a table
  • Set up a primary key
  • Build relationships between tables
  • Create an index
  • Add, modify and delete records

Course Topics

  • Understanding database terminology
  • Working with fields
  • Differentiating flat files and relational databases
  • Building a database
  • Creating tables
  • Organizing with a primary key
  • Building table relationships
  • Creating an index
  • Opening databases and tables
  • Adding, modifying, and deleting records

3. Access 2003:3 Enhanced Tables and Datasheets (Time: 3 hours)

This eLearning course shows learners how to use Access 2003 to format tables and use masks and validations. It also covers working with columns and rows, changing fonts, using table fields and field names.

Course Objectives

  • Format a table
  • Use masks and validations
  • Work with columns and rows
  • Change fonts on the datasheet
  • Add and remove table fields
  • Change field names

Course Topics

  • Formatting tables
  • Using input masks
  • Creating validations
  • Navigating the datasheet
  • Modifying columns and rows
  • Organizing columns and rows
  • Changing fonts and the look of the datasheet
  • Adding and removing table fields
  • Changing field names

4. Access 2003:4 Searches and Queries (Time: 3 hours)

This eLearning course shows learners how to use Access 2003 to build simple, select and multiple-table queries using wizards or by hand. It also covers filtering records.

Course Objectives

  • Sort and filter records in a database
  • Build a simple query
  • Use the select query and select query wizard
  • Set up multiple-table queries
  • Build a multiple-table query by hand

Course Topics

  • Using the find command
  • Sorting the database
  • Filtering records
  • Defining queries
  • Building a simple query
  • Using the select query
  • Using the simple query wizard
  • Setting up multiple-table queries
  • Using the wizard for multiple-table queries
  • Building a multiple-table query by hand

5. Access 2003:5 Advanced Queries and Calculations (Time: 3 hours)

This eLearning course shows learners how to use Access 2003 to construct calculations and use Boolean operators (AND/OR) to build advanced queries. It also covers how to use the Total Row and Expression Builder, and to modify data.

Course Objectives

  • Use Boolean operators in queries
  • Create advanced queries and calculations
  • Replace, delete, and update data

Course Topics

  • Using the AND operator
  • Using the OR operator
  • Defining the total row
  • Using total row options
  • Developing simple calculations
  • Performing complex calculations
  • Using the expression builder
  • Replacing data
  • Deleting data
  • Updating data

6. Access 2003:6 Access Report System (Time: 5 hours)

This eLearning course shows learners how to use Access 2003 to view, organize, and customize reports. It also covers the use of AutoReport, and the Label, Chart, and Report wizards.

Course Objectives

  • Use AutoReport
  • Print reports and labels
  • Use the report wizard
  • Modify the report printing features

Course Topics

  • Using AutoReport
  • Viewing the report in print preview mode
  • Customizing the report with page layout
  • Printing labels with the label wizard
  • Adding charts with the chart wizard
  • Using the report wizard
  • Moving to design view
  • Working with the formatting toolbar
  • Viewing and modifying the report
  • Organizing reports with headers and footers
  • Grouping records
  • Fine-tuning the report layout
  • Controlling headers and footers

7. Access 2003:7 The Internet, Forms, and the Analyzer (Time: 3 hours)

This eLearning course shows learners how to use Access 2003 to build hyperlinks and publish data to the Web. It also covers building forms, importing and exporting data, and using database analysis tools.

Course Objectives

  • Build and use hyperlinks
  • Publish Access data to the Web
  • Build a form with the Form Wizard
  • Build a form with the AutoForm Wizard
  • Import and export Access data
  • Use the Table Analyzer

Course Topics

  • Building hyperlinks
  • Publishing data on the internet
  • Defining forms
  • Building forms using the form wizard
  • Building forms using the AutoForm wizard
  • Enhancing forms
  • Importing and exporting data
  • Using the table analyzer
  • Ten tips for maximizing a database
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723