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

Book Description

Teach yourself how to use the data management power of the latest version of Microsoft Access—one step at a time! Learn exactly the skills you need for Access 2003 through self-paced, easy-to-follow lessons and hands-on practice files.

Table of Contents

  1. Microsoft® Office Access 2003: Step by Step
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. What’s New in Microsoft Office Access 2003
    4. Getting Help
      1. Getting Help with This Book and Its CD-ROM
      2. Getting Help with Microsoft Office Access 2003
      3. More Information
    5. Using the Book’s CD-ROM
      1. What’s On the CD-ROM?
      2. Minimum System Requirements
      3. Installing the Practice Files
      4. Using the Practice Files
      5. Uninstalling the Practice Files
    6. Conventions and Features
    7. Taking a Microsoft Office Specialist Certification Exam
      1. About the Microsoft Office Specialist Program
      2. What Does This Logo Mean?
      3. Selecting a Microsoft Office Specialist Certification Level
      4. Microsoft Office Specialist Skill Standards
      5. The Exam Experience
        1. The Exam Interface and Controls
        2. Test-Taking Tips
        3. Certification
        4. College Credit Recommendation
      6. For More Information
    8. Microsoft Office Specialist Skill Standards
    9. About the Authors
      1. Online Training Solutions, Inc. (OTSI)
    10. Quick Reference
      1. Chapter 1 Getting to Know Microsoft Access 2003
      2. Chapter 2 Creating a New Database
      3. Chapter 3 Getting Information Into and Out of a Database
      4. Chapter 4 Simplifying Data Entry with Forms
      5. Chapter 5 Locating Specific Information
      6. Chapter 6 Keeping Your Information Accurate
      7. Chapter 7 Working with Reports
      8. Chapter 8 Making It Easy for Others to Use Your Database
      9. Chapter 9 Keeping Your Information Secure
      10. Chapter 10 Working with Pages and Modules
    11. 1. Getting to Know Microsoft Access 2003
      1. Understanding Databases
      2. Discovering What’s Special About Access
      3. Opening an Existing Database
      4. Exploring Tables
      5. Exploring Queries
      6. Exploring Forms
      7. Exploring Reports
      8. Exploring Other Access Objects
        1. Pages
        2. Macros
        3. Modules
      9. Previewing and Printing Access Objects
      10. Key Points
    12. 2. Creating a New Database
      1. Creating a Database Structure the Simple Way
      2. Checking the Work of a Wizard
      3. Creating Tables the Simple Way
      4. Refining How Data is Displayed
      5. Manipulating Table Columns and Rows
      6. Key Points
    13. 3. Getting Information Into and Out of a Database
      1. Importing Information from Excel
      2. Importing Information from a Delimited Text File
      3. Importing Information from a Fixed-Width Text File
      4. Importing Information from an Access Database
      5. Importing Information from Other Databases
      6. Importing Information from an HTML File
      7. Importing Information from an XML File
      8. Exporting Information to Other Programs
      9. Linking a Database to Information in Another Database
      10. Other Ways to Share Access Data
      11. Key Points
    14. 4. Simplifying Data Entry with Forms
      1. Creating a Form by Using a Wizard
      2. Refining Form Properties
      3. Refining Form Layout
      4. Adding Controls to a Form
      5. Using Visual Basic for Applications to Enter Data in a Form
      6. Creating a Form by Using an AutoForm
      7. Adding a Subform to a Form
      8. Key Points
    15. 5. Locating Specific Information
      1. Sorting Information
      2. Filtering Information in a Table
      3. Filtering by Form
      4. Locating Information that Matches Multiple Criteria
      5. Creating a Query in Design View
      6. Creating a Query with a Wizard
      7. Performing Calculations in a Query
      8. Key Points
    16. 6. Keeping Your Information Accurate
      1. Using Data Type Settings to Restrict Data
      2. Using Field Size Properties to Restrict Data
      3. Using Input Masks to Restrict Data
      4. Using Validation Rules to Restrict Data
      5. Using Lookup Lists to Restrict Data
      6. Updating Information in a Table
      7. Deleting Information from a Table
      8. Key Points
    17. 7. Working with Reports
      1. Creating a Report by Using a Wizard
      2. Modifying a Report
      3. Creating a Report from Scratch
      4. Adding a Subreport to a Report
      5. Previewing and Printing a Report
      6. Key Points
    18. 8. Making It Easy for Others to Use Your Database
      1. Creating a Switchboard by Using Switchboard Manager
      2. Creating a Splash Screen
      3. Setting Startup Options
      4. Keeping Your Application Healthy
      5. Key Points
    19. 9. Keeping Your Information Secure
      1. Encrypting and Decrypting a Database
      2. Assigning a Password to a Database
      3. Sharing a Database
      4. Replicating a Database
      5. Splitting a Database
      6. Setting Up a Workgroup
      7. Maintaining a Workgroup
      8. Preventing Changes to a Database
      9. Securing a Database for Distribution
      10. Key Points
    20. 10. Working with Pages and Modules
      1. Creating Static Web Pages
      2. Exploring Visual Basic for Applications (VBA)
      3. Using VBA to Create a Web Page
      4. Creating a Data Access Page with AutoPage
      5. Creating a Data Access Page Using the Page Wizard
      6. Allowing Others to Analyze Data On the Web
      7. Key Points
    21. Glossary
    22. Index
    23. SPECIAL OFFER: Upgrade this ebook with O’Reilly