For experienced database programmers and first-time database users alike, Microsoft Access version 2002 delivers powerful tools for managing and analyzing data. With Extensible Markup Language (XML) support, developers can create sophisticated enterprise-wide database solutions that integrate easily with the Web. New users can find comprehensive tools that make building databases more intuitive. Features such as Microsoft PivotTable® and Microsoft PivotChart® technologies greatly improve data-analysis capabilities. Like the rest of Microsoft Office XP, Access 2002 can help you work smarter.

[Part 1]  [Part 2]  [Part 3]

Part 1

Prerequisites

A knowledge of personal computer fundamentals, experience in working within the Microsoft Windows environment, a reasonable degree of keyboard proficiency and experience in using a mouse.

Objectives

After completing this course, students will be able to:

• Start Access

• Display Help information

• Create a new database and a new table

• Enter records in Datasheet view

• Print the datasheet of a table

• Create a form

• Enter records in Form view

• Edit records in Datasheet view and in Form view

• Use the Find feature

• Delete records in Datasheet view and in Form view

• Modify the Datasheet view of a table

• Sort the records in a table

• Filter the records in a table

• Create a simple query

• Create a query in Design view

• Modify a query

• Create a simple tabular report

• Create a grouped tabular report

• Modify a report

• Use the Spelling Checker

• Copy, rename and delete database objects

• Import spreadsheet data into an Access table

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

[Part 1]  [Part 2]  [Part 3]

Top of Page

Part 2

Prerequisites

Part 1 or equivalent knowledge.

Objectives

After completing this course, students will be able to:

• Specify a required field in a table

• Define a default field value in a table

• Add a Memo field to a table

• Display multiple tables on the Access desktop

• Resize and reposition the Table window

• Create a relationship between two tables in a database

• Display and use a subdatasheet

• Design a custom form

• Add a calculated control to a form

• Create a query to extract information from multiple tables

• Find unmatched records in a table

• Create a report of information in multiple tables

• Add a calculated control to a report

• Create a data access page

• Add a hyperlink to a data access page

• Use the Database Wizard

• Add a Lookup field to a table

• Define an input mask for a field

• Export an Access datasheet to Microsoft Excel

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

[Part 1]  [Part 2]  [Part 3]

Top of Page

Part 3

Prerequisites

Part 2 or equivalent knowledge.

Objectives

After completing this course, students will be able to:

• Validate field entries

• Create a custom input mask

• Create a master-detail form

• Add a picture to a form

• Display the current date on a form

• Create an advanced filter

• Create a parameter query

• Create a query to generate summary information

• Create an action query

• Create a master-detail report

• Create and run a macro

• Create a command button

• Write an event procedure

• Set database startup options

• Set a database password

• Encrypt and decrypt a database

• Use the Database Splitter Wizard and the Linked Table Manager

• Create a replica of a database

• Add a PivotTable and a PivotChart to a data access page

• Create a switchboard

• Export Access data to an XML document

• Import an XML document into Access

• Save an Access database in an MDE file

• Create an Access workgroup

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

[Part 1]  [Part 2]  [Part 3]

Top of Page