Access 2010:

Topic-Level Outline

                         Days:  1

          Prerequisites:  Access 2010: Basic, or equivalent experience

                         Unit 1 :  Relational databases

                               Topic A: 0  Database normalization

                               A-1:                               Discussing the first normal form

                               A-2:                               Discussing the second and third normal forms

                               A-3:                               Using the Table Analyzer

                               A-4:                               Identifying object dependencies

                               Topic B: 0  Table relationships

                               B-1:                               Establishing a one-to-one table relationship

                               B-2:                               Establishing a one-to-many table relationship

                               B-3:                               Establishing a many-to-many table relationship

                               B-4:                               Printing table relationships

                               Topic C: 0  Referential integrity

                         C-1:                         Planning table relationships

                         C-2:                         Working with orphan records

                         C-3:                         Setting cascading deletes

                         C-4:                         Testing cascading deletes

                         C-5:                         Using cascading updates

                         Unit 2 :  Related tables

                               Topic A: 0  Creating lookup fields

                               A-1:                               Creating a lookup field

                               A-2:                               Creating a multivalued lookup field

                               Topic B: 0  Modifying lookup fields

                               B-1:                               Modifying lookup field properties

                               B-2:                               Changing a text box to a combo box

                               Topic C: 0  Subdatasheets

                         C-1:                         Using a subdatasheet

                         Unit 3 :  Complex queries

                               Topic A: 0  Joining tables in queries

                               A-1:                               Creating a query with the Simple Query Wizard

                               A-2:                               Creating a join in Design view

                               A-3:                               Creating an outer join

                               A-4:                               Creating a join with an intermediate table

                               A-5:                               Creating a self-join query

                               A-6:                               Finding records that do not match between tables

                               A-7:                               Finding duplicate records

                               A-8:                               Deleting tables from a query

                               Topic B: 0  Using calculated fields

                               B-1:                               Creating a calculated field

                               B-2:                               Changing the format of a displayed value

                               B-3:                               Using the Expression Builder

                               Topic C: 0  Summarizing and grouping values

                         C-1:                         Creating a query to display summary values

                         C-2:                         Using queries to concatenate values

                         Unit 4 :  Advanced form design

                               Topic A: 0  Adding unbound controls

                               A-1:                               Drawing a rectangle around a control

                               A-2:                               Changing the tab order

                               A-3:                               Grouping controls

                               Topic B: 0  Adding graphics

                               B-1:                               Adding a graphic to a form

                               B-2:                               Embedding a graphic in an unbound object frame

                               Topic C: 0  Adding calculated values

                               C-1:                               Binding a control to a calculated field

                               C-2:                               Creating a calculated control

                               Topic D: 0  Adding combo boxes

                               D-1:                               Adding a combo box to a form

                               D-2:                               Modifying the properties of a combo box

                               Topic E: 0  Advanced form types

                         E-1:                         Creating a multiple-item form

                         E-2:                         Creating a split form

                         E-3:                         Creating a datasheet form

                         E-4:                         Creating a subform

                         Unit 5 :  Reports and printing

                               Topic A: 0  Customized headers and footers

                               A-1:                               Adding a report header

                               A-2:                               Adding a report footer

                               A-3:                               Applying conditional formatting

                               A-4:                               Keeping parts of a report on the same page

                               A-5:                               Adding controls to group footers

                               A-6:                               Forcing a new page

                               Topic B: 0  Calculated values

                               B-1:                               Working with the DateDiff function

                               B-2:                               Using the IIf function

                               Topic C: 0  Printing

                               C-1:                               Printing a table

                               C-2:                               Printing a database document

                               Topic D: 0  Labels

                         D-1:                         Creating labels

                         Unit 6 :  Charts

                               Topic A: 0  Charts in forms

                               A-1:                               Creating a chart in a form

                               A-2:                               Modifying a chart in a form

                               Topic B: 0  Charts in reports

                         B-1:                         Adding a chart to a report

                         B-2:                         Modifying a chart in a report

                         Unit 7 :  PivotTables and PivotCharts

                               Topic A: 0  PivotTables

                               A-1:                               Examining PivotTable view

                               A-2:                               Adding fields to a PivotTable

                               Topic B: 0  Modifying PivotTables

                               B-1:                               Creating totals

                               B-2:                               Moving fields in a PivotTable

                               B-3:                               Showing and hiding details in a PivotTable

                               B-4:                               Formatting fields

                               Topic C: 0  PivotCharts

                               C-1:                               Creating a PivotChart

                               Topic D: 0  PivotTable forms

                                                                                                                                                                                           D-1:                                                                                                                                                                                           Creating a PivotTable form