Microsoft Office Access 2013

Intermediate

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