Microsoft Access 2000 Step by Step

Part 1 Entering and Viewing Data in Microsoft Access 2000

Lesson 1 Using Forms

Opening a Database

Understanding Forms

Entering and Updating Data

Entering Data Efficiently and Correctly

Finding Records

Adding and Removing Record Text

One Step Further: Replacing Data

Lesson 1 Quick Reference 26

Lesson 2 Using Tables and Subforms

Viewing a Datasheet

Viewing Multiple Tables with a Subform

One Step Further: Refining Datasheet Views

Lesson 2 Quick Reference 40

Lesson 3 Using Filters and Reports

Viewing Only the Information You Need

Refining Your View of the Data

Preserving Your View in a Report

Creating Mailing Labels

One Step Futher: Creating More Complex Filters

Lesson 3 Quick References 61

Review and Practice pg 63

PART 2 Creating and Expanding Databases

Lesson 4 Managing Database Change

Modifying Database Tables

Changing a Table in Design View

Improving Data Entry and Display

Connecting a New Table to a Database

One Step further: Combining Data from Related Tables Using a Query

Lesson 4 Quick Reference 93

Lesson 5 Keeping Database Information Reliable

Validating Data in a Form

Validating Records Across Related Tables

Resolving Many-to-Many Relationships

One Step Further: Using Subdatasheets

Lesson 5 Quick Reference 119

Lesson 6 Working with External Data

Gathering Data from External Sources

Creating a Link to an External Data Source

Importing a Table

One Step Further: Making Data Available to Other Sources

Lesson Quick Reference 131

Review and Practice 133

PART 3 Turning Data into Meaningful Information

Lesson 7 Using Queries

Understanding Queries

Creating a Query with the Query Wizard

Modifying a Query in Design View

Refining a Query with Criteria

Presenting a Query More Effectively

Joining Related Tables in the Query Window

One Step Further: Fine-tuning Queries

Lesson 7 Quick Reference 150

Lesson 8 Analyzing Your Data

Turning Raw Data into Meaningful Information

Creating Descriptive Column Names

Using Queries with Calculated Fields to Analyze Data

Summarizing and Calculating with a Crosstab Query

One Step Further: Presenting Data in a Chart 175

Lesson 8 Quick Reference 150

Lesson 9 Merging Data onto One Form

Creating Custom Forms with the Form Wizard

Adding a Calculated Control to a Form

Lesson 9 Quick Reference 193

Review and Practice 195
Turning Data into Meaningful Information 201
Presenting a Form More EffectIvEly 203

Lesson 10 Presenting a Form More Effectively

Enhancing Form Wizard and AutoForm Forms

Adding a Headline to a Form Header

Maintaining the Consistency of Form Formatting

Refining the Appearance of a Form

Adding a Picture to a Form

One Step Further: Using AutoFormat

Lesson 10 Quick Reference 210

Lesson 11 Presenting an Effective Report

Summarizing Data by Using a Detail Report

Understanding the Design of the Report

Customizing the Design of a Report

Hiding Duplicated or Unnecessary Information

One Step Further: Creating and Refining a Custom AutoReport

Lesson 11 Quick Reference 236

Lesson 12 Presenting Grouped Data in a Report

Summarizing Data by Grouping Records

Summarizing Data with a Grouped Report

Customizing a Group Header and Footer

Rearranging the Order of a Grouped Report

Keeping Related Groups Together

Customizing Page Numbers

One Step Further: Refining the Group Header

Lesson 12 Quick Reference 254

Review and Practice pg 255

PART 5 Taking Your Database to the World

Lesson 13 Making Connections

Understanding Hyperlinks, Hypertext and HTML

Connecting Through Cyberspace

Adding Hyperlinks to Your Database

Publishing a Database Object as a Web Page

Understanding Data Access Pages

One Step Further: Adding a Microsoft Office Web Component

Lesson 13 Quick Reference 281

Review and Practice 283