1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"Webucator's hands-on approach gave the department confidence in implementing CSS across the site. Th..." More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ ONLINE ACCESS 2003 TRAINING

Save money by buying series in packages. This course series is included with the following package:

Packages include 24/7 access to subject matter experts.

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

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online Access 2003 Training

Only $99.95
12-month subscription

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.

Access 2003 Series (22 hours)

ONLINE Access 2003 TRAINING FEATURES

  • 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. Introduction to Access

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

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

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. Designing and Building Tables

Time: 3 hours
This 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.

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

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. Enhanced Tables and Datasheets

Time: 3 hours
This 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.

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

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. Searches and Queries

Time: 3 hours
This 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.

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

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. Advanced Queries and Calculations

Time: 3 hours
This 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.

Objectives

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

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 Report System

Time: 5 hours
This 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.

Objectives

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

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. The Internet, Forms, and the Analyzer

Time: 3 hours
This 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.

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

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
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA