Access 2010:

Topic-Level Outline

                         Days:  1

          Prerequisites:  Windows 7: Basic or equivalent experience

                         Unit 1 :  Getting started

                               Topic A: 0  Database concepts

                               A-1:                               Identifying database components

                               A-2:                               Identifying 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 a table in Datasheet view

                               B-4:                               Examining a table in Design view

                               Topic C: 0  Creating tables

                         C-1:                         Creating a table from a table template

                         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

                         C-9:                         Using the Data Type gallery

                         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 Totals 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 by 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  Creating reports

                               A-1:                               Examining a report

                               A-2:                               Creating a basic report

                               A-3:                               Creating a report by using the Report Wizard

                               A-4:                               Creating a report in 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 by using the Report Wizard

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

  B-6:  Printing a report