Microsoft® Office Access™ 2007 Plain & Simple

Larger Cover

By Curtis D. Frye

Publisher: Microsoft Press

Released: January 2007

Pages: 288

Chapter 1 Introduction: About This Book
1. No Computerese!
2. A Quick Overview
3. A Few Assumptions
4. A Final Word (or Two)
Chapter 2 What’s New in Access 2007
1. Familiarizing Yourself with the New User Interface
2. Formatting Database Objects Using New AutoFormats
3. Creating New Types of Fields
4. Collecting Data from E-mail Messages
Chapter 3 Introducing Access 2007
1. Introducing Databases
2. Starting Access
3. Surveying the Access Window
4. Opening a Database
5. Viewing Multiple Database Objects
6. Closing a Database and Exiting Access
7. Displaying and Managing Database Objects
8. Using the Access Help System
Chapter 4 Getting to Know Access Databases
1. Viewing a Sample Database
2. Working with Database Objects
3. Examining a Table
4. Examining a Form
5. Examining a Query
6. Examining a Report
7. Using the Database Templates
8. Frequently Used Object Views
Chapter 5 Creating a Database
1. Designing a Database
2. Creating a New Database
3. Creating a New Table in Design View
4. Creating a New Table by Typing
5. Adding Existing Fields to a Table
6. Setting a Primary Key
7. Getting Data from Other Access Tables
8. Relationships Explained
9. Creating Relationships between Tables
10. Enforcing Referential Integrity
Chapter 6 Customizing Fields
1. Working with Tables
2. Assigning a Data Type
3. Viewing or Changing Field Properties
4. Introducing the Expression Builder
5. Formatting Field Contents
6. Creating Input Masks
7. Assigning Required Fields and Requiring Data Entry
8. Setting Default Values
9. Indexing Field Values
10. Validating Data Entry
11. Creating a Lookup Field
12. Creating an Append-Only Memo Field
13. Creating an Attachment Field
Chapter 7 Customizing Tables
1. Finding and Replacing Text
2. Entering Data Using AutoCorrect
3. Adding and Editing Text
4. Manipulating Columns
5. Modifying Columns and Rows
6. Viewing a Subdatasheet
7. Filtering Table Records
Chapter 8 Creating Forms
1. Creating a Simple Form
2. Creating a Form Using the Form Wizard
3. Creating a Form in Design View
4. Creating a Multiple Items Form
5. Modifying an Existing Form
6. Adding and Deleting Form Controls
7. Adding a Date Picker Control
8. Creating a Subform
9. Displaying a Form and Its Datasheet Simultaneously
Chapter 9 Creating Queries
1. Introducing Query Types
2. Creating a Query Using the Query Wizard
3. Editing a Query in Design View
4. Using Criteria to Focus Query Results
5. Introducing Operators
6. Using Queries to Calculate Values
7. Finding Duplicate Records
8. Finding Unmatched Records
9. Writing Query Results to a New Table
10. Creating an Update Query
11. Creating a Crosstab Query
12. Finding the Largest and Smallest Values in a Field by Using a Query
Chapter 10 Creating Reports
1. Creating a Report Using the Report Wizard
2. Creating a Summary Report
3. Creating a Report in Design View
4. Modifying an Existing Report
5. Adding and Deleting Report Controls
6. Calculating Values in a Report
7. Introducing Report Sections
8. Grouping Report Records
9. Creating a Subreport
10. Creating Mailing Labels
Chapter 11 Beautifying Forms and Reports
1. Formatting Text
2. Applying AutoFormats
3. Setting Control Appearance
4. Adding Lines, Shapes, and Borders
5. Editing Lines and Borders
6. Showing Gridlines in a Report
7. Coloring Alternate Rows in a Form or Report
8. Adding a Totals Row to a Datasheet
9. Adding a Picture
10. Applying Conditional Formatting
11. Changing the Source of an Image
12. Setting Image Alignment and Backing Color
13. Tiling a Picture
14. Setting Image Height and Width
Chapter 12 Creating Charts in Access
1. Creating a Chart
2. Formatting Chart Elements
3. Customizing Chart Axes
4. Add Information to a Chart
5. Changing a Chart’s Type
Chapter 13 Interacting with Other Programs
1. Introducing Linking and Embedding
2. Inserting a New Object
3. Manipulating Objects
4. Inserting Excel Charts and Worksheets
5. Importing Data from Another Access Database
6. Linking to a Table in Another Access Database
7. Working with Hyperlinks
8. Importing Data from an Excel File
9. Importing Data from a Text File
10. Importing Data from an XML File
11. Exporting Data to a Text File
12. Exporting Data to Another Access File
13. Exporting Data to an XML File
14. Saving Database Objects as Web Files
15. Analyzing Data with Microsoft Excel
16. Publishing Data to Microsoft Word
17. Collecting Data from E-mail Messages
Chapter 14 Administering a Database
1. Introducing Database Security
2. Encrypting a Database
3. Locking Database Records
4. Creating a Switchboard
5. Documenting a Database
6. Setting Startup Options
Chapter 15 Customizing Access
1. Adding Buttons to the Quick Access Toolbar
2. Building a Macro
3. Running a Macro
4. Defining Macro Groups
5. Adding and Deleting Macro Actions
6. Launching a Macro from a Button
7. Displaying a Message Box
8. Running a Macro When a Form Opens
9. Changing AutoCorrect Options
Chapter 16 Presenting Table and Query Data Dynamically
1. Introducing PivotTables and PivotCharts
2. Creating a PivotTable
3. Adding and Removing PivotTable Fields
4. Pivoting a PivotTable
5. Filtering PivotTable Data
6. Formatting a PivotTable
7. Creating a PivotChart

Appendix About the Author
Appendix Choose the Right Book for You
1. Published and Upcoming Titles

Title:

Microsoft® Office Access™ 2007 Plain & Simple

By:

Curtis D. Frye

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

January 2007

Ebook:

November 2009

Pages:

288

Print ISBN:

978-0-7356-2292-0

| ISBN 10:

0-7356-2292-2

Ebook ISBN:

978-0-7356-9033-2

| ISBN 10:

0-7356-9033-2

Description

Table of Contents

Product Details

About the Author

Recommended for You

Chapter 1 Introduction: About This Book

No Computerese!

A Quick Overview

A Few Assumptions

A Final Word (or Two)

Chapter 2 What’s New in Access 2007

Familiarizing Yourself with the New User Interface

Formatting Database Objects Using New AutoFormats

Creating New Types of Fields

Collecting Data from E-mail Messages

Chapter 3 Introducing Access 2007

Introducing Databases

Starting Access

Surveying the Access Window

Opening a Database

Viewing Multiple Database Objects

Closing a Database and Exiting Access

Displaying and Managing Database Objects

Using the Access Help System

Chapter 4 Getting to Know Access Databases

Viewing a Sample Database

Working with Database Objects

Examining a Table

Examining a Form

Examining a Query

Examining a Report

Using the Database Templates

Frequently Used Object Views

Chapter 5 Creating a Database

Designing a Database

Creating a New Database

Creating a New Table in Design View

Creating a New Table by Typing

Adding Existing Fields to a Table

Setting a Primary Key

Getting Data from Other Access Tables

Relationships Explained

Creating Relationships between Tables

Enforcing Referential Integrity

Chapter 6 Customizing Fields

Working with Tables

Assigning a Data Type

Viewing or Changing Field Properties

Introducing the Expression Builder

Formatting Field Contents

Creating Input Masks

Assigning Required Fields and Requiring Data Entry

Setting Default Values

Indexing Field Values

Validating Data Entry

Creating a Lookup Field

Creating an Append-Only Memo Field

Creating an Attachment Field

Chapter 7 Customizing Tables

Finding and Replacing Text

Entering Data Using AutoCorrect

Adding and Editing Text

Manipulating Columns

Modifying Columns and Rows

Viewing a Subdatasheet

Filtering Table Records

Chapter 8 Creating Forms

Creating a Simple Form

Creating a Form Using the Form Wizard

Creating a Form in Design View

Creating a Multiple Items Form

Modifying an Existing Form

Adding and Deleting Form Controls

Adding a Date Picker Control

Creating a Subform

Displaying a Form and Its Datasheet Simultaneously

Chapter 9 Creating Queries

Introducing Query Types

Creating a Query Using the Query Wizard

Editing a Query in Design View

Using Criteria to Focus Query Results

Introducing Operators

Using Queries to Calculate Values

Finding Duplicate Records

Finding Unmatched Records