The eLearning Center for Millersville University

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.

Introduction to Access
Time: 2.0 hour(s)
Summary:
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

Designing and Building Tables
Time: 3.0 hour(s)
Summary:
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

Enhanced Tables and Datasheets
Time: 3.0 hour(s)
Summary:
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

Searches and Queries
Time: 3.0 hour(s)
Summary:
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

Advanced Queries and Calculations
Time: 3.0 hour(s)
Summary:
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

Access Report System
Time: 5.0 hour(s)
Summary:
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

The Internet, Forms, and the Analyzer
Time: 3.0 hour(s)
Summary:
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