Access 2003: Basic

Second Edition

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 :  Microsoft Office Specialist exam objectives map

                               Topic A: 0  Comprehensive exam objectives