Microsoft Office Access 2013


Topic-Level Outline

                         Days:  1

          Prerequisites:  Microsoft Office Access 2013 Basic, or equivalent

                         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

                               Topic C: 0  Referential integrity

                         C-1:                         Planning table relationships

                         C-2:                         Working with orphan records

                         C-3:                         Setting cascading deletes

                         C-4:                         Using cascading updates

                         Unit 2 :  Related tables

                               Topic A: 0  Creating lookup fields

                               A-1:                               Creating a lookup field

                               A-2:                               Creating a multi-valued 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

                               A-4:                               Arranging controls in tables

                               A-5:                               Formatting the page layout

                               A-6:                               Grouping controls

                               A-7:                               Grouping controls

                               Topic B: 0  Graphics

                               B-1:                               Adding an image to a form

                               B-2:                               Embedding a logo in a form header

                               B-3:                               Adding a background image to a form

                               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

                         E-5:                         Creating a navigation form

                         Unit 5 :  Reports and printing

                               Topic A: 0  Report formatting

                               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

                               A-7:                               Formatting reports in columns

                               A-8:                               Adding a background image

                               A-9:                               Using Application Parts

                               Topic B: 0  Calculated values and subreports

                               B-1:                               Working with the DateDiff function

                               B-2:                               Using the IIf function

                               B-3:                               Creating a subreport

                               Topic C: 0  Printing

                               C-1:                               Printing a table

                               C-2:                               Printing a database document

                               Topic D: 0  Label printing

                         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