Access 2003:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 2000: Basic or equivalent experience

Unit 1 : Getting started

Topic A: 0 Database concepts

A-1: Identifying database components

A-2: Identifying the advantages of relational databases

Topic B: 0 Exploring the Access environment

B-1: Starting Access 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 Getting help

C-1: Using the Type a question for help box

C-2: Using the Office Assistant

Topic D: 0 Closing a database and Access

D-1: Closing a database and Access

Unit 2 : Databases and tables

Topic A: 0 Planning and designing databases

A-1: Planning a database

A-2: Using the Database Wizard

A-3: Creating a blank database

Topic B: 0 Exploring tables

B-1: Discussing views

B-2: Examining a table in Datasheet view

B-3: Navigating in a table in Datasheet view

B-4: Examining a table in Design view

Topic C: 0 Creating tables

C-1: Creating a table by using the Table Wizard

C-2: Creating a table in Design view

C-3: Adding fields and descriptions to a table

C-4: Setting the primary key

C-5: Saving the design and viewing the table

C-6: Adding a record

Unit 3 : Fields and records

Topic A: 0 Changing the design of a table

A-1: Modifying field names

A-2: Deleting and inserting fields

A-3: Moving a field

Topic B: 0 Finding and editing records

B-1: Finding and replacing a value

B-2: Undoing changes

B-3: Using the spelling checker

Topic C: 0 Organizing records

C-1: Sorting records by a single field

C-2: Sorting records by multiple fields

C-3: Using Filter By Selection

C-4: Using Filter By Form

C-5: Using Filter Excluding Selection

C-6: Using Advanced Filter/Sort

C-7: Deleting a record

Unit 4 : Data entry rules

Topic A: 0 Setting field properties

A-1: Setting the Required property

A-2: Using the AllowZeroLength property

A-3: Setting the FieldSize property

A-4: Setting the SmartTags property

Topic B: 0 Working with input masks

B-1: Creating an input mask

B-2: Working with the Input Mask Wizard

Topic C: 0 Setting validation rules

C-1: Setting default values

C-2: Creating validation rules

C-3: Setting validation text

Topic D: 0 Using indexes

D-1: Creating a single-field index

D-2: Creating a multiple-field index

Unit 5 : Simple queries

Topic A: 0 Creating and using queries

A-1: Planning a query

A-2: Using the Simple Query Wizard

A-3: Creating a query in Design view

A-4: Saving and running the query

A-5: Sorting query results

A-6: Filtering query results

Topic B: 0 Modifying query results and queries

B-1: Editing query results

B-2: Adding fields to a query

B-3: Removing fields from a query

B-4: Finding records with empty fields

Topic C: 0 Performing operations in queries

C-1: Using comparison operators

C-2: Using the OR condition

C-3: Using the AND condition

C-4: Using the * wildcard

C-5: Using calculations in a query

C-6: Totaling a group of records

C-7: Using the Avg and Count functions

Unit 6 : Using forms

Topic A: 0 Creating forms

A-1: Examining a form

A-2: Creating a form by using AutoForm

A-3: Using the navigation bar

A-4: 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

C-5: Inheriting 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 : Working with reports

Topic A: 0 Creating reports

A-1: Examining a report

A-2: Creating reports by using AutoReport

A-3: Creating reports by using the Report Wizard

A-4: Creating a report by using Design view

A-5: Creating a report by using a query

Topic B: 0 Modifying and printing reports

B-1: Modifying a report in Design view

B-2: Grouping information in a report

B-3: Checking errors in reports

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

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

B-6: Changing field properties

B-7: Printing a report

Appendix A : MOS exam objectives map

Topic A: 0 Comprehensive exam objectives