Access 2002:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 2000: Basic or equivalent experience

Unit 1 : Database concepts

Topic A: 0 Database concepts and terminology

A-1: Using database terminology

Topic B: 0 Exploring the Access environment

B-1: Starting and examining the Access window

B-2: Opening a database

B-3: Examining the database window

B-4: Examining a database table

Topic C: 0 Planning and designing databases

C-1: Planning a database

C-2: Exploring database relationships

Topic D: 0 Getting help

D-1: Using the Ask a Question box

D-2: Using the Office Assistant

Topic E: 0 Closing a database and Access

E-1: Closing a database and Access

Unit 2 : Access basics

Topic A: 0 Exploring tables and forms

A-1: Discussing views

A-2: Examining a table in Datasheet view

A-3: Navigating in a table in Datasheet view

A-4: Examining a table in Design view

A-5: Identifying the primary key

A-6: Navigating in a form

A-7: Examining a form in Design view

Topic B: 0 Examining queries

B-1: Planning a query

B-2: Examining a query in Design view

B-3: Running the query and viewing the results

Topic C: 0 Exploring reports

C-1: Examining a report

C-2: Examining a report in Design view

Unit 3 : Creating databases

Topic A: 0 Creating a database

A-1: Verifying object names

A-2: Creating a database by using the Database Wizard

A-3: Creating a blank database

Topic B: 0 Using the Table Wizard

B-1: Creating a table and setting a primary key using the Table Wizard

Topic C: 0 Working in Design View

C-1: Creating a table in Design view

C-2: Adding text fields to a table

C-3: Adding fields of other data types

C-4: Entering field descriptions

C-5: Adding a Memo field

C-6: Setting the primary key

C-7: Saving the design and viewing the table

C-8: Adding a record

Unit 4 : Working with fields and records

Topic A: 0 Changing the design of a table

A-1: Examining field names

A-2: Changing the name of a field

A-3: Deleting and inserting fields

A-4: Moving a field

A-5: Setting field properties

Topic B: 0 Adding and deleting records

B-1: Adding a new record

B-2: Deleting a record

Topic C: 0 Finding and editing records

C-1: Finding and replacing a value

C-2: Undoing changes

C-3: Using spelling checker

Topic D: 0 Sorting and filtering records

D-1: Sorting records by a single field

D-2: Sorting records by multiple fields

D-3: Filtering records

Unit 5 : Querying tables

Topic A: 0 Creating and using queries

A-1: Creating a simple query by using the Simple Query Wizard

A-2: Creating a simple query in Design view

A-3: Sorting query results

A-4: Filtering query results

A-5: Saving a query

Topic B: 0 Modifying query results and queries

B-1: Editing query results

B-2: Modifying a query by adding more fields

B-3: Modifying a query by removing fields

B-4: Using comparison operators

B-5: Using the OR condition

B-6: Using the AND condition

B-7: Using the * wildcard

B-8: Finding records with empty fields

Topic C: 0 Using calculations in queries

C-1: Using calculations in a query

C-2: Totaling a group of records

C-3: Calculating values with the Avg and Count functions

Unit 6 : Creating and using forms

Topic A: 0 Creating forms by using AutoForm

A-1: Creating a form by using AutoForm

A-2: Navigating in a form by using the navigation bar

A-3: Using a form for data entry

Topic B: 0 Using the Form Wizard

B-1: Creating a form by using the Form Wizard

Topic C: 0 Using Design view

C-1: Creating a form in Design view

C-2: Adding a title to a form

C-3: Adding controls

C-4: Modifying properties

Topic D: 0 Finding, sorting, and filtering records

D-1: Using a form to find records

D-2: Using a form to sort records

D-3: Using a form to filter records

Unit 7 : Creating and using reports

Topic A: 0 Using the Report Wizard and queries

A-1: Using the Report Wizard to create a report

A-2: Create a report by using a query

Topic B: 0 Creating, modifying, and printing reports

B-1: Modifying the appearance of a report by using Design view

B-2: Grouping information in a report

B-3: Adding summary fields by using the Report Wizard

B-4: Modifying the layout and style of a report

B-5: Changing field properties

B-6: Printing a report

Unit 8 : Importing, exporting, and linking objects

Topic A: 0 Importing Access objects

A-1: Importing an object from a database

A-2: Importing multiple objects

Topic B: 0 Exporting Access objects

B-1: Exporting objects

Topic C: 0 Exporting and importing XML documents

C-1: Exporting and importing XML documents

Topic D: 0 Linking Access objects

D-1: Linking objects

D-2: Updating a link

Appendix A : MOUS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives