Access 2013

Basic, MOS Edition

Topic-Level Outline

Days:  1

          Prerequisites: Windows XP or Windows 7

                         Unit 1 :  Getting started

Topic A: 0  Database Concepts

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Exploring the Access environment

B-1:                         ActivityTitle

B-2:                         ActivityTitle

B-3:                         ActivityTitle

                         Unit 2 :  Databases and tables

Topic A: 0  Planning and designing databases

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Exploring tab les

B-1:                               ActivityTitle

B-2:                               ActivityTitle

B-3:                               ActivityTitle

Topic C: 0  Creating tables

C-1:                         ActivityTitle

C-2:                         ActivityTitle

C-3:                         ActivityTitle

                         Unit 3 :  Fields and records

Topic A: 0  Changing the design of a table

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Finding and editing records

B-1:                               ActivityTitle

B-2:                               ActivityTitle

B-3:                               ActivityTitle

Topic C: 0  Organizing records

C-1:                         ActivityTitle

C-2:                         ActivityTitle

C-3:                         ActivityTitle

                         Unit 4 :  Data Entry rules

Topic A: 0  Setting field properties

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Working with input masks

B-1:                               ActivityTitle

B-2:                               ActivityTitle

B-3:                               ActivityTitle

Topic C: 0  Setting validation rules

C-1:                         ActivityTitle

C-2:                         ActivityTitle

C-3:                         ActivityTitle

                         Unit 5 :  Basic queries

Topic A: 0  Creating and using queries

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Modifying query results and queries

B-1:                               ActivityTitle

B-2:                               ActivityTitle

B-3:                               ActivityTitle

Topic C: 0  Performing operations in queries

C-1:                         ActivityTitle

C-2:                         ActivityTitle

C-3:                         ActivityTitle

                         Unit 6 :  Using forms

Topic A: 0  Creating forms

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

Topic B: 0  Using Design view

B-1:                               ActivityTitle

B-2:                               ActivityTitle

B-3:                               ActivityTitle

Topic C: 0  Sorting and filtering records

C-1:                         ActivityTitle

C-2:                         ActivityTitle

C-3:                         ActivityTitle

                         Unit 7 :  Working with reports

Topic A: 0  Creating reports

A-1:                               ActivityTitle

A-2:                               ActivityTitle

A-3:                               ActivityTitle

A-4:                               ActivityTitle

A-5:                               ActivityTitle

A-6:                               ActivityTitle

Topic B: 0  Modifying and printing reports