Access 2000:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 95: Basic, Windows 98: Basic, or equivalent experience

Unit 1 : Database concepts

Topic A: 0 Database concepts and terminology

A-1: Using database terminology

Topic B: 0 Starting with Access

B-1: Starting Access

B-2: Opening a database

Topic C: 0 The Access environment

C-1: Examining the Microsoft Access window

C-2: Examining the Database window

C-3: Identifying the elements of a database

C-4: Examining a database table

Topic D: 0 Planning and designing databases

D-1: Planning a database

D-2: Exploring database relationships

Topic E: 0 Getting help

E-1: Using the Help feature

E-2: Using the Content tab

E-3: Using the Answer Wizard

E-4: Using the Help index

E-5: Getting help through the Office Assistant

Topic F: 0 Closing a database and exiting Access

F-1: Closing a database and exiting Access

Unit 2 : Access basics

Topic A: 0 Exploring tables and forms

A-1: Examining a table in Datasheet view

A-2: Navigating in a table in Datasheet view

A-3: Examining a table in Design view

A-4: Identifying the primary key

A-5: Navigating in a form

A-6: Examining a form in Design view

Topic B: 0 Exploring queries

B-1: Planning a query

B-2: Examining a query in Design view

B-3: Running a 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 blank database

Topic B: 0 Using the Table Wizard

B-1: Creating a table and setting a primary key by 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 in a table

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 to a table

B-2: Deleting a record from a table

Topic C: 0 Finding and editing records

C-1: Finding a replacing a value

C-2: Undoing changes

C-3: Using the spelling checker

Topic D: 0 Sorting and filtering records

D-1: Sorting records on a single field

D-2: Sorting records on multiple fields

D-3: Filtering records

Unit 5 : Querying tables

Topic A: 0 Viewing specific fields

A-1: Creating and running a simple query

A-2: Sorting query results

A-3: Filtering query results

A-4: 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: Using comparison operators

B-4: Selecting records by using an OR condition

B-5: Selecting records by using an AND condition

B-6: Using the * wildcard operator

B-7: Finding records with empty fields

Topic C: 0 Calculations in queries

C-1: Using calculations in a query

C-2: Totaling a group of records

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 the 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

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

A-2: Creating a report by using a query

Topic B: 0 Using reports to perform calculations

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 appearance of a report

B-5: Changing field properties

B-6: Printing a report

Unit 8 : Importing and exporting 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