Access 2007:

Topic-Level Outline

             Days:           1

Prerequisites:           Microsoft Windows XP: Basic or Microsoft Windows Vista: 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:           Using the Navigation Pane

           B-4:           Examining a database table

           Topic C: 0   Getting help

             C-1:             Using Help

             Unit 2 :           Databases and tables

           Topic A: 0   Planning and designing databases

           A-1:           Planning a database

           A-2:           Creating a database from a template

           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 templates

             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 table

             C-6:             Adding a record

             C-7:             Copying, modifying, and deleting a table

             C-8:             Creating a composite key

             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

           A-4:           Using the Attachment data type

           A-5:           Adding a total row

           Topic B: 0   Finding and editing records

           B-1:           Finding and replacing a value

           B-2:           Undoing changes

           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 Allow Zero Length property

           A-3:           Setting the Field Size property

           A-4:           Setting the Append Only 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:             Creating validation rules

             C-2:             Setting validation text

             Unit 5 :           Basic queries

           Topic A: 0   Creating and using queries

           A-1:           Planning a query

           A-2:           Using the 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 a query by adding criteria

           A-7:           Creating a query from a filter

           Topic B: 0   Modifying query results and queries

           B-1:           Editing query results

           B-2:           Adding fields to a query

           B-3:           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

             C-8:             Using the Min and Max functions

             Unit 6 :           Using forms

           Topic A: 0   Creating forms

           A-1:           Examining a form

           A-2:           Creating a basic form

           A-3:           Creating a form using the Form Wizard

           Topic B: 0   Using Design view

           B-1:           Creating a form in Design view

           B-2:           Adding controls

           B-3:           Modifying properties

           B-4:           Applying conditional formatting

           Topic C: 0   Sorting and filtering records

             C-1:             Using a form to sort records

             C-2:             Using a form to filter records

             Unit 7 :           Working with reports

           Topic A: 0   Reports

           A-1:           Examining a report

           A-2:           Creating a basic report

           A-3:           Creating a report using the Report Wizard

           A-4:           Creating a report using Design view

           Topic B: 0   Modifying and printing reports

  B-1:  Modifying a report in Design view

  B-2:  Modifying a report in Layout view

  B-3:  Grouping, sorting, and filtering a report

  B-4:  Adding summary fields using the Report Wizard

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

  B-6:  Printing a report