Microsoft® Access® 2010 24-Hour Trainer

CONTENTS

Introduction

LESSON 1: INSTALLING ACCESS 2010

Lesson Setup

How to Get Access 2010

Purchasing Directly from Microsoft

System Requirements

Side-By-Side Installations

Default Versus Complete Installations

Installing Access 2010

Try It

Lesson Requirements

Hints

Step-by-Step

Summary

LESSON 2: GETTING STARTED IN ACCESS 2010

Lesson Setup

Starting Access 2010

Opening a Database from within Access

Opening a Database File from Windows

Microsoft Access File Types

Try It

Lesson Requirements

Step-by-Step

Summary

LESSON 3: CREATING A NEW DATABASE APPLICATION

Lesson Setup

Options for Creating Databases in Access 2010

Creating a Blank Database

Creating a Database from Template

Try It

Lesson Requirements

Hints

Step-by-Step

Summary

LESSON 4: ACCESS DATABASE OBJECTS

Lesson Setup

Access Database Objects

Access Tables

Access Queries

Access Forms

Access Reports

Access Macros

VBA Code in Access

Try It

Lesson Requirements

Step-by-Step

Summary

LESSON 5: THE ACCESS 2010 RIBBON

Lesson Setup

Ribbon Overview

Ribbon Tabs

Contextual Ribbon Tabs

Ribbon Sections

Section Expanders

The Quick Access Toolbar (QAT)

Custom Ribbons

Keyboard Shortcuts

Try It

Lesson Requirements

Step-by-Step

Summary

LESSON 6: THE ACCESS 2010 BACKSTAGE

Lesson Setup

The Backstage View

Touring the Backstage Features

The Basic Backstage Controls

Customizing the Backstage

Try It

Lesson Requirements

Step-by-Step

Summary

LESSON 7: THE ACCESS 2010 NAVIGATION PANE

Lesson Setup

The Navigation Pane Overview

Navigation Pane Grouping Types ...