computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

Access 2003 Online Course

12 Month Subscription - $35
Live Mentor +$30

Summary:
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.

Audience:
This series is for anyone who wants to get the most out of using Access 2003.

Features:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Simulations that allow users to practice course skills, even if they don't have access to the application
●   A glossary
●  A Skill Assessment

Topics included in this course:
Access 2003 Series: Introduction to Access
Access 2003 Series: Designing and Building Tables
Access 2003 Series: Enhanced Tables and Datasheets
Access 2003 Series: Searches and Queries
Access 2003 Series: Advanced Queries and Calculations
Access 2003 Series: Access Report System
Access 2003 Series: The Internet, Forms, and the Analyzer

Access 2003 Series: Introduction to Access
Summary: Time: 2.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: Designing and Building Tables
Summary: Time: 3.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: Enhanced Tables and Datasheets
Summary: Time: 3.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: Searches and Queries
Summary: Time: 3.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: Advanced Queries and Calculations
Summary: Time: 3.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: Access Report System
Summary: Time: 5.0 hour(s)
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:
After completing this course, students will be able to:
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
top

Access 2003 Series: The Internet, Forms, and the Analyzer
Summary: Time: 3.0 hour(s)
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:
After completing this course, students will be able to:
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
top

12 Month Subscription - $35
Live Mentor +$30