You are previewing Microsoft Office Access 2003 in a Snap.
O'Reilly logo
Microsoft Office Access 2003 in a Snap

Book Description

Microsoft Access is a database development and maintenance program, but it can be confusing when trying to learn how to complete the tasks required to create an application. Microsoft Access 2003 In a Snap can quickly show you how to complete a specific task in an easy-to-follow format complete with illustrated steps. Sections of the book are organized into task categories such as Table Creation, Queries and Form Design. Intended to keep you focused and on-target, this book does not spend time explaining database architecture or application design. If you are the casual Access user or if you use it in your day-to-day work life, this book is a great reference tool!

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Author
  3. Acknowledgments
  4. We Want to Hear from You!
  5. I. Introduction to Relational Databases and Access 2003
    1. 1. Start Here
      1. What Is a Relational Database?
      2. What Types of Things Can I Do with Microsoft Access?
        1. Access As a Development Platform for Personal Applications
        2. Access As a Development Platform for Small-Business Applications
        3. Access As a Development Platform for Departmental Applications
        4. Access As a Development Platform for Corporationwide Applications
        5. Access As a Front End for Enterprisewide Client/Server Applications
        6. Access As a Development Platform for Intranet/Internet Applications
      3. Starting Microsoft Access
      4. Opening an Existing Database
      5. The Access Desktop
      6. The Database Window
      7. A Preview of the Database Components
        1. Tables: A Repository for Data
        2. Relationships: Tying the Tables Together
        3. Queries: Stored Questions or Actions You Apply to Data
        4. Forms: A Means of Displaying, Modifying, and Adding Data
        5. Reports: Turning Data into Information
        6. Pages: Forms Viewed in a Browser
        7. Macros: A Means of Automating a System
        8. Modules: The Foundation of the Application Development Process
      8. Closing an Access Database
      9. Viewing and Navigating Table Data
        1. Opening an Access Table
        2. Navigating Around a Table
        3. Closing a Table
  6. II. Work with Existing Databases and Objects
    1. 2. Working with an Existing Table
      1. 1. Edit Table Data
      2. 2. Add Records to a Table
      3. 3. Delete Records from a Table
      4. 4. Find and Replace Text in a Table
      5. 5. Filter Table Data
      6. 6. Modify the Appearance of a Datasheet
      7. 7. Spell-Check Your Data
      8. 8. Using the AutoCorrect Feature
    2. 3. Working with an Existing Query
      1. 9. Open a Query in Datasheet View
      2. 10. Open a Query in Design View
      3. 11. Add Fields to a Query
      4. 12. Order a Query Result
      5. 13. Refine a Query with Criteria
      6. 14. Save a Query
      7. 15. Print a Query Result
      8. 16. Close a Query
    3. 4. Working with an Existing Form
      1. 17. Open a Form
      2. 18. Work with Data
      3. 19. Find Data
      4. 20. Replace Data
      5. 21. Sort Data
      6. 22. Filter Data
      7. 23. Close a Form
      8. 24. Highlight Important Data with Conditional Formatting
    4. 5. Working with an Existing Report
      1. 25. Open and View a Report
      2. 26. Move from Page to Page
      3. 27. Zoom In and Out
      4. 28. View Multiple Pages
      5. 29. Print a Report
      6. 30. Close a Report
      7. 31. Print Database Objects
  7. III. Create Your Own Database and Objects
    1. 6. Use Wizards to Create a Database
      1. 32. Use a Database Template to Create a Database
      2. 33. Create a New Empty Database
      3. 34. Create a Table Using the Table Wizard
      4. 35. Create a Query Using the Query Wizard
      5. 36. Create a Form Using the Form Wizard
      6. 37. Create a Report Using the Report Wizard
    2. 7. Design and Create Your Own Tables
      1. 38. About Task Analysis
      2. 39. About Database Analysis and Design
      3. 40. About Relational Database Design
      4. 41. About the Application Development Process
        1. Prototyping
        2. Testing
        3. Implementation
        4. Maintenance
      5. 42. Build a New Table
      6. 43. About Selecting the Appropriate Field Type for Your Data
        1. Text Fields: The Most Common Field Type
        2. Memo Fields: For Long Notes and Comments
        3. Number Fields: For When You Need to Calculate
        4. Date/Time Fields: For Tracking When Things Happened
        5. Currency Fields: For Storing Money
        6. AutoNumber Fields: For Unique Record Identifiers
        7. Yes/No Fields: For When One of Two Answers Is Correct
        8. OLE Object Fields: For Storing Just About Anything
        9. Hyperlink Fields: For Linking to the Internet
      7. 44. Set a Primary Key
    3. 8. Create Your Own Relationships
      1. 45. About the Types of Relationships
        1. One-to-Many Relationships
        2. One-to-One Relationships
        3. Many-to-Many Relationships
      2. 46. Establish Relationships
      3. 47. Establish Referential Integrity
    4. 9. Create Your Own Queries
      1. 48. Create Queries
      2. 49. Order a Query Result
      3. 50. About Refining a Query with Advanced Criteria
        1. Working with Dates in Criteria
      4. 51. Update Query Results
      5. 52. About Building Queries Based on Multiple Tables
        1. Pitfalls of Multitable Queries
        2. AutoLookup in Multitable Queries
      6. 53. Create Calculated Fields
      7. 54. Get Help from the Expression Builder
    5. 10. Create Your Own Forms
      1. 55. Create a Form in Design View
      2. 56. Add Controls
      3. 57. About Selecting Controls
      4. 58. Move, Size, and Delete Controls
      5. 59. Align Controls
      6. 60. About Selecting the Correct Control
        1. Labels
        2. Text Boxes
        3. Combo Boxes
        4. List Boxes
        5. Check Boxes
        6. Option and Toggle Buttons
        7. Option Groups
      7. 61. Change the Tab Order of Controls
      8. 62. About Form Properties
        1. Working with the Properties Window
        2. Working with the Important Form Properties
          1. The Format Properties of a Form
          2. The Data Properties of a Form
      9. 63. Work with Combo Boxes and List Boxes
    6. 11. Create Your Own Reports
      1. 64. Create a Report in Design View
      2. 65. About Working with Report Sections
      3. 66. About Working with Controls
        1. Selecting Report Objects
        2. Moving Report Objects
        3. Aligning Objects with One Another
        4. Using Snap to Grid
        5. Using Power-Sizing Techniques
        6. Controlling Object Spacing
        7. Selecting the Correct Control for the Job
          1. Labels
          2. Text Boxes
          3. Lines
          4. Rectangles
          5. Bound Object Frames
          6. Unbound Object Frames
          7. Image Controls
          8. Other Controls
      4. 67. Create Groups and Totals Reports
      5. 68. About Working with Report Properties
        1. Working with the Properties Window
        2. The Format Properties of a Report
        3. The Data Properties of a Report
      6. 69. Create Reports Based on Multiple Tables
  8. IV. Power Access Techniques
    1. 12. Power Table Techniques
      1. 70. About Working with Field Properties
        1. The Field Size Property
        2. The Format Property
        3. The Caption Property
        4. The Default Value Property
        5. The Validation Rule and Validation Text Properties
        6. The Required Property
        7. The Allow Zero Length Property
        8. The Input Mask Property
      2. 71. Look Up Values in a Table or Query
      3. 72. About Working with Table Properties
      4. 73. Improve Performance with Indexes
    2. 13. Power Query Techniques
      1. 74. Apply Advanced Filters
      2. 75. Create and Run Parameter Queries
      3. 76. Create and Run Action Queries
      4. 77. Incorporate Aggregate Functions
      5. 78. Refine Your Queries with Field, Field List, and Query Properties
    3. 14. Access and the Internet
      1. 79. Export to HTML
      2. 80. Export to XML
      3. 81. Import from HTML
      4. 82. Import from XML
      5. 83. Create and Modify Data Access Pages
      6. 84. Save PivotTables and PivotCharts to Data Access Pages
    4. 15. Database Administration
      1. 85. Back Up and Restore a Database
      2. 86. Compact and Repair a Database
      3. 87. Encode and Decode a Database
      4. 88. Convert a Database to Another Version
      5. 89. Create an MDE File
      6. 90. Use the Database Splitter
    5. 16. Finishing Touches
      1. 91. Add Toolbars
      2. 92. Add Menu Bars
      3. 93. Build Switchboards
      4. 94. About Setting Startup Options
  9. Contents at a Glance
    1. Part I: Introduction to Relational Databases and Access 2003
      1. Chapter 1: Start Here
    2. Part II: Work with Existing Databases and Objects
      1. Chapter 2: Working with an Existing Table
      2. Chapter 3: Working with an Existing Query
      3. Chapter 4: Working with an Existing Form
      4. Chapter 5: Working with an Existing Report
    3. Part III: Create Your Own Database and Objects
      1. Chapter 6: Use Wizards to Create a Database
      2. Chapter 7: Design and Create Your Own Tables
      3. Chapter 8: Create Your Own Relationships
      4. Chapter 9: Create Your Own Queries
      5. Chapter 10: Create Your Own Forms
      6. Chapter 11: Create Your Own Reports
    4. Part IV: Power Access Techniques
      1. Chapter 12: Power Table Techniques
      2. Chapter 13: Power Query Techniques
      3. Chapter 14: Access and the Internet
      4. Chapter 15: Database Administration
      5. Chapter 16: Finishing Touches
  10. Key Terms