• MicrosoftВ® Office Access™ 2007 Step by Step
• Table of Contents
• Copyright
• About the Authors
• Introducing Access 2007
• Information for Readers Running Windows XP
• The Microsoft Business Certification Program
• Features and Conventions of This Book
  • Using the Book's CD
  • Getting Help
  • Quick Reference
• Chapter 1. Exploring Access 2007
  • Working in Access 2007
  • Understanding Database Concepts
  • Opening an Existing Database
  • Exploring Tables
  • Exploring Queries
  • Exploring Forms
  • Exploring Reports
  • Exploring Other Access Objects
  • Previewing and Printing Access Objects
  • Key Points
• Chapter 2. Creating a Database
  • Creating a Database from a Template
  • Creating a Table Manually
  • Creating a Table from a Template
  • Manipulating Table Columns and Rows
  • Key Points
• Chapter 3. Populating a Database
  • Importing Information from Another Access Database
  • Importing Information from an Excel Worksheet
  • Importing or Linking to a SharePoint List
  • Collecting Data Through E-Mail
  • Importing Information from a Text File
  • Importing Information from an XML File
  • Importing Information from an HTML File
  • Importing Information from an Outlook Folder
  • Importing Information from a dBASE File
  • Key Points
• Chapter 4. Sharing and Reusing Information
  • Exporting Information to Another Access Database
  • Exporting Information to Excel
  • Exporting Information to a SharePoint List
  • Exporting Information to Word
  • Exporting Information to a Text File
  • Exporting Information to an XML File
  • Exporting Information to an HTML File
  • Copying Information to Other Office Programs
  • Key Points
• Chapter 5. Simplifying Data Entry by Using Forms
  • Creating a Form by Using the Form Tool
  • Refining Form Properties
  • Changing the Arrangement of a Form
  • Adding Controls to a Form
  • Entering Data in a Form by Using VBA
  • Creating a Form by Using an AutoForm
  • Adding a Subform to a Form
  • Key Points
• Chapter 6. Locating Specific Information
  • Sorting Information in a Table
  • Filtering Information in a Table
  • Filtering Information by Using a Form
  • Locating Information That Matches Multiple Criteria
  • Creating a Query Manually
  • Creating a Query by Using a Wizard
  • Performing Calculations by Using a Query
  • Key Points
• Chapter 7. Keeping Your Information Accurate
  • Restricting the Type of Data in a Field
  • Restricting the Amount of Data in a Field
  • Specifying the Format of Data in a Field
  • Restricting Data by Using Validation Rules
  • Creating a Simple Lookup List
  • Creating a Multi-Column Lookup List
  • Updating Information in a Table
  • Deleting Information from a Table
  • Preventing Database Problems
  • Key Points
• Chapter 8. Working with Reports
  • Creating a Report by Using a Wizard
  • Modifying Report Design
  • Creating a Report Manually
  • Modifying Report Content
  • Adding a Subreport to a Report
  • Previewing and Printing a Report
  • Key Points
• Chapter 9. Making Your Database Easy to Use
  • Creating a Switchboard
  • Creating Custom Categories
  • Controlling the Features Available to Database Users
  • Making Favorite Access Commands Quickly Available
  • Key Points
• Chapter 10. Securing and Sharing Information
  • Assigning a Password to a Database
  • Preventing Changes to Database Code
  • Securing a Database for Distribution
  • Key Points
• Glossary
• Choose the Right Book for You
  • Published and Upcoming Titles
• Index
  • A
  • B
  • C
  • D
  • E
  • F
  • H
  • I
  • J
  • K
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • X
  • Y
  • Z