You are previewing Microsoft® Office Access™ 2007 Step by Step.
O'Reilly logo
Microsoft® Office Access™ 2007 Step by Step

Book Description

Experience learning made easy—and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Build databases from scratch or from templates

  • Exchange data with other databases and Office documents

  • Create forms to simplify data entry

  • Use filters and queries to find and analyze information

  • Design rich reports that help make your data meaningful

  • Help prevent data corruption and unauthorized access



  • Your all-in-one learning experience includes:

  • Files for building skills and practicing the book’s lessons

  • Fully searchable eBook

  • Bonus quick reference to the Ribbon, the new Microsoft Office interface

  • Windows Vista Product Guide eReference—plus other resources on CD



  • For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

    Table of Contents

    1. Microsoft® Office Access™ 2007 Step by Step
    2. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    3. A Note Regarding Supplemental Files
    4. About the Authors
      1. Steve Lambert
      2. M. Dow Lambert III
      3. Joan Lambert Preppernau
      4. The Team
      5. Online Training Solutions, Inc. (OTSI)
    5. Introducing Access 2007
      1. New Features
        1. If You Are Upgrading from Access 2003
        2. If You Are Upgrading from Access 2002
        3. If You Are Upgrading from Access 2000
      2. Let’s Get Started!
    6. Information for Readers Running Windows XP
      1. Managing the Practice Files
      2. Using the Start Menu
      3. Navigating Dialog Boxes
    7. The Microsoft Business Certification Program
      1. Selecting a Certification Path
      2. Becoming a Microsoft Certified Application Specialist—Microsoft Office Access 2007
      3. Taking a Microsoft Business Certification Exam
        1. Test-Taking Tips
        2. Certification
      4. More Information
    8. Features and Conventions of This Book
    9. Using the Book’s CD
      1. What’s on the CD?
      2. Minimum System Requirements
        1. 2007 Microsoft Office System
        2. Step-by-Step Exercises
      3. Installing the Practice Files
      4. Adding the Practice File Folder to the Trusted Locations List
      5. Using the Practice Files
      6. Removing and Uninstalling the Practice Files
    10. Getting Help
      1. Errata & Book Support
      2. Getting Help with Access 2007
      3. More Information
      4. We Want to Hear from You
      5. Stay in Touch
    11. Quick Reference
      1. 1. Exploring Access 2007
      2. 2. Creating a Database
      3. 3. Populating a Database
      4. 4. Sharing and Reusing Information
      5. 5. Simplifying Data Entry by Using Forms
      6. 6. Locating Specific Information
      7. 7. Keeping Your Information Accurate
      8. 8. Working with Reports
      9. 9. Making Your Database Easy to Use
      10. 10. Securing and Sharing Information
    12. 1. Exploring Access 2007
      1. Working in Access 2007
      2. Understanding Database Concepts
      3. Opening an Existing Database
      4. Exploring Tables
      5. Exploring Queries
      6. Exploring Forms
      7. Exploring Reports
      8. Exploring Other Access Objects
        1. Macros
        2. Modules
      9. Previewing and Printing Access Objects
      10. Key Points
    13. 2. Creating a Database
      1. Creating a Database from a Template
      2. Creating a Table Manually
      3. Creating a Table from a Template
      4. Manipulating Table Columns and Rows
      5. Key Points
    14. 3. Populating a Database
      1. Importing Information from Another Access Database
      2. Importing Information from an Excel Worksheet
      3. Importing or Linking to a SharePoint List
      4. Collecting Data Through E-Mail
      5. Importing Information from a Text File
      6. Importing Information from an XML File
      7. Importing Information from an HTML File
      8. Importing Information from an Outlook Folder
      9. Importing Information from a dBASE File
      10. Key Points
    15. 4. Sharing and Reusing Information
      1. Exporting Information to Another Access Database
      2. Exporting Information to Excel
      3. Exporting Information to a SharePoint List
      4. Exporting Information to Word
      5. Exporting Information to a Text File
      6. Exporting Information to an XML File
      7. Exporting Information to an HTML File
      8. Copying Information to Other Office Programs
      9. Key Points
    16. 5. Simplifying Data Entry by Using Forms
      1. Creating a Form by Using the Form Tool
      2. Refining Form Properties
      3. Changing the Arrangement of a Form
      4. Adding Controls to a Form
      5. Entering Data in a Form by Using VBA
      6. Creating a Form by Using an AutoForm
      7. Adding a Subform to a Form
      8. Key Points
    17. 6. Locating Specific Information
      1. Sorting Information in a Table
      2. Filtering Information in a Table
      3. Filtering Information by Using a Form
      4. Locating Information That Matches Multiple Criteria
      5. Creating a Query Manually
      6. Creating a Query by Using a Wizard
      7. Performing Calculations by Using a Query
      8. Key Points
    18. 7. Keeping Your Information Accurate
      1. Restricting the Type of Data in a Field
      2. Restricting the Amount of Data in a Field
      3. Specifying the Format of Data in a Field
      4. Restricting Data by Using Validation Rules
      5. Creating a Simple Lookup List
      6. Creating a Multi-Column Lookup List
      7. Updating Information in a Table
      8. Deleting Information from a Table
      9. Preventing Database Problems
      10. Key Points
    19. 8. Working with Reports
      1. Creating a Report by Using a Wizard
      2. Modifying Report Design
      3. Creating a Report Manually
      4. Modifying Report Content
      5. Adding a Subreport to a Report
      6. Previewing and Printing a Report
      7. Key Points
    20. 9. Making Your Database Easy to Use
      1. Creating a Switchboard
      2. Creating Custom Categories
      3. Controlling the Features Available to Database Users
      4. Making Favorite Access Commands Quickly Available
      5. Key Points
    21. 10. Securing and Sharing Information
      1. Assigning a Password to a Database
      2. Preventing Changes to Database Code
      3. Securing a Database for Distribution
      4. Key Points
    22. Glossary
    23. A. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
        4. Other Titles
    24. Index
    25. About the Authors
    26. SPECIAL OFFER: Upgrade this ebook with O’Reilly