◊ ACCESS 2003 ONLINE TRAINING SERIES
Online Access 2003 Training
Microsoft » Microsoft Access
Check out these great money-saving course packages:
Only $99.95
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. Access 2003: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. Access 2003: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. Access 2003: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. Access 2003: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. Access 2003: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 2003: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. Access 2003: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
Resources for Access 2003
