Microsoft Office Access 2010 QuickSteps | QuickSteps

Home >
Browse >
QuickSteps >
Microsoft Office Access 2010 QuickSteps

Microsoft Office Access 2010 QuickSteps

Authors: John Cronan

Published: May 2010

eISBN: 9780071634939 0071634932 | ISBN: 9780071634946

Contents

Acknowledgments

Introduction

Chapter 1 Stepping into Access

Understanding an Access Database

Start Access

Open Access

Understanding the Ribbon

Work with File View

Open a Database

Understanding Access Objects

Use the Navigation Pane

Understanding Access File Compatibility

Open Older Databases

Convert an Older Database After Opening It

Change the Default File Format in Access

Find a Database

Personalize Access

Customize the Ribbon

Customize the Quick Access Toolbar

Using the Keyboard in Access

Display and Use Ribbon Shortcut Keys

Change How You View Objects

Get Help

Open Help

Use the Access Help Window

End Your Access Session

Close a Database

Exit Access

Chapter 2 Creating Databases and Tables

Design a Database

Use Database Templates

Understanding How to Create an Access Database

Create a Database from a Stored Template

Build a Database on Your Own

Using Datasheet and Design Views

Close a Database After Creating It

Build the Framework with Tables

Set Up a Table in Datasheet View

Add Fields in Datasheet View

Rename Fields in Datasheet View

Close and Save a New Table in Datasheet View

Construct a Table in Design View

Understanding the Primary Key

Assign a Primary Key

Add Identifying Information to Your Database

Identify Relationships

Define Relationships

Relate Tables in the Relationships Tab

Understanding Referential Integrity

Enforce Referential Integrity

Chapter 3 Modifying Tables and Fields

Modify Tables and Table Properties

Delete a Table

Rename a Table

Renaming an Access Database

Duplicate a Table by Copying

Switching Views

Change a Table’s Properties

Fine-Tune the Fields

Change a Data Type in Datasheet View

Understanding Restrictions When Changing Data Types

Change Display of Data Through the Format Property

Understanding In put Masks

Create a Pattern for Data Entry with Input Masks

Creating a Custom Input Mask

Establish a Field’s Default Value

Limit Field Values with Validation

Require Entry but Allow a Zero-Length String

Use the Caption Field Property

Index a Data Field

Add Smart Tags

Use the Lookup Wizard

Deciding to Use a Multivalued Field

Chapter 4 Working in the Table

Enter and Edit Data

Enter Data in an Existing Table

Use Keyboard Shortcuts in a Table

Moving Through Records

Copy and Move Data

Using the Office Clipboard

Delete Records and Columns

Selecting Records, Fields, and Columns with the Mouse

Find and Replace Text

Calculating Data in a Field

Verify Spelling

Modify Automatic Corrections

Acquire Data

Import Data from Outside Sources

Collect Data from Outlook Messages

Arrange a Table

Adjust Column Width

Changing How the Current Datasheet Looks

Move and Hide Columns

Lock and Unlock Columns

Adjust Row Height

Chapter 5 Retrieving Information

Sort Data

Sort Records in a Table

Sort Records in a Form

Choosing a Filter

Filter Data

Filter by Selecting

Filter for an Input

Filter by Form

Use Operators and Wildcards in Criteria

Removing, Clearing, or Reapplying a Filter

Use Advanced Filters

Work with Queries

Create a Simple Query with a Wizard

Create or Modify a Query in Design View

View the Query Results

Save and Close a Query

Using the Expression Builder

Set Query Properties

Chapter 6 Creating Forms and Using Controls

Create Forms

Understanding Form Views

Create a Form Using the Form Tool

Work with the Split Form Tool

Create a Form with Multiple Records

Employ the Form Wizard

Creating a Multiple-Table Form

Use the Blank Form Tool

Create a Form in Design View

Adding Fields with the Field List

Add Elements to a Form

Selecting a Form Section

Use Controls

Add Bound Controls

Linking a Form to a Subform

Add Unbound Controls

Navigating in a Data Entry Form

Copy or Delete a Control

Select, Move, and Resize Controls

Understanding Layouts

Chapter 7 Working with Reports

Viewing Reports

Create Reports

Use the Report Tool to Create a Report

Use the Report Wizard to Create a Report

Understanding Grouping in Reports

Use the Blank Report Tool

Create a Report in Design View

Modify Reports

Work with Fields

Working with Data in Reports

Use the Group, Sort, And Total Pane

Calculate a Value

Accomplishing Common Tasks in Reports

Set Group Headers and Footers in a Report

Create a Summary Report

Create Labels

Chapter 8 Preparing Your Data for Presentation

Improve the Data’s Appearance

Modify Images

Use Conditional Formatting in Reports and Forms

Formatting Values with Data Bars

Add a Chart

Use Graphics

Modify the Form or Report Design

Understanding Formatting Rules

Apply Themes

Create Custom Themes

Locating and Selectively Applying Themes

Work with Rich Text Formatting

Print Your Data

Set Up the Print Job

Outputting the Print Job

Review Data Before Printing

Chapter 9 Securing, Sharing, and Administrating Access

Understanding Access 2010 Security

Apply Security to an Access Database

Create a Trusted Location

Create and Use Certificates to Trust Databases

Creating Passwords

Encrypt a Database

Keeping Data Safe

Remove Database Objects from View

Share Data

Understanding the User-Level Security Model

Export Access Data

Link Tables

Merging Data with Microsoft Word

Add a Hyperlink Field to an Existing Table

Understanding SharePoint

Save a Database as a Template

Administer a Database

Document a Database

Creating a Hyperlink to a File or Web Page

Compact and Repair a Database

Back Up a Database

Troubleshooting the Compact And Repair Database Utility

Chapter 10 Extending Access

Use Advanced Data Analysis Tools

Create a Crosstab Query with a Wizard

Create a PivotTable

Understanding Drop Zones in PivotTables

Create a PivotChart

Sorting and Filtering a Crosstab Query

Analyze Database Performance and Design

Enhance Database Functionality

Create a Navigation Form

Split a Database

Use SQL Tables in Access

Understanding SQL in Access

Move Access Data to a SQL Database

Index