Course outline for
Microsoft Access 2010: Part Two

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1: Advanced Form Design

TOPIC A: Add Controls to Forms

Types of Controls

Command Buttons

Quick Start Fields

Calendar/Datepicker Control

Form Layouts

Quick Styles

Tab Order

The Anchoring Tool

Activity 1-1

TOPIC B: Create Subforms

Subforms

Activity 1-2

TOPIC C: Organize Information with Tab Pages

Tab Pages

Activity 1-3

TOPIC D: Display a Summary of Data in a Form

PivotTables

PivotCharts

Activity 1-4

TOPIC E: Apply Conditional Formatting

Conditional Formatting

Activity 1-5

TOPIC F: Form Options

Form Design Options

Form Arrange Options

Form Format Options

Activity 1-6

Summary

Review Questions

Lesson 2: Field and Record Validation

TOPIC A: Field and Record Validation

Field Properties

Input Mask Wizard

Input Mask Characters

Lookup Lists

Expression Builder

Record Validation

Activity 2-1

TOPIC B: Form Validation

Control Wizards

The Combo Box Control

The List Box Control

The Option Group Control

Activity 2-2

Summary

Review Questions

Lesson 3: Using Macros to Improve User Interface Design

TOPIC A: Create Macros

Macros

The Macro Builder Window

Macro Actions

Types of Macro Actions

Action Arguments

Object Events

Activity 3-1

TOPIC B: Restrict Records Using a Condition

Macro Conditions

The Where Condition

Activity 3-2

TOPIC C: Validate Data Using a Macro

Event Properties for Data Validation

Macro Actions for Data Validation

Embedded Macros

Activity 3-3

TOPIC D: Automate Data Entry Using a Macro

Event Properties for Automating Data Entry

Macro Actions for Automating Data Entry

Activity 3-4

TOPIC E: Convert a Macro to VBA

Macros and VBA

Activity 3-5

Summary

Review Questions

Lesson 4: Advanced Database Management

TOPIC A: Link Tables to External Data Sources

External Data Sources

The Linked Table Manager

Activity 4-1

TOPIC B: Manage a Database

Exclusive Mode

Database Backup

The Compact and Repair Database Option

Activity 4-2

TOPIC C: Determine Object Dependency

Object Dependency

Activity 4-3

TOPIC D: Document a Database

The Database Documenter

Activity 4-4

TOPIC E: Analyze the Performance of a Database

Performance Analyzer

Activity 4-5

Summary

Review Questions

Lesson 5: Distributing and Securing a Database

TOPIC A: Prepare a Database for Multiple User Access

Splitting a Database

Activity 5-1

TOPIC B: Implement Security

Security Strategies in Access 2010

The Message Bar

The Trust Center Dialog Box

Trusted Locations

Activity 5-2

TOPIC C: Set Passwords

Password Protection

Database Access Modes

Activity 5-3

TOPIC D: Convert an Access Database to an ACCDE File

The ACCDE File Format

User Templates

Activity 5-4

TOPIC E: Package a Database with a Digital Signature

Digital Signatures

Digital Certificates

The Package and Sign Feature

Activity 5-5

Summary

Review Questions

Lesson 6: Managing Switchboards

TOPIC A: Create a Database Switchboard

Switchboard Manager

Activity 6-1

TOPIC B: Modify a Database Switchboard

Switchboard Modification

Activity 6-2

TOPIC C: Set Startup Options

Database Startup Options

Activity 6-3

Summary

Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson Lab 1-2

Lesson Lab 1-3

Lesson 2

Lesson Lab 2-1

Lesson 3

Lesson Lab 3-1

Lesson Lab 3-2

Lesson 4

Lesson Lab 4-1

Lesson Lab 4-2

Lesson 5

Lesson Lab 5-1

Lesson Lab 5-2

Lesson 6

Lesson Lab 6-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Appendices

Keyboard Shortcut Quick Reference Sheet

Mapping to Microsoft Office Access 2010, Exam 77-885

Glossary

Index