Microsoft® Office Access 2003 Step by Step

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