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

Book Description

Easy Microsoft Office Access 2003 takes the work out of learning this powerful database by using short, easy-to-follow lessons that show you how to accomplish basic tasks quickly and efficiently! It is the perfect book for beginners who want to learn Microsoft's database application through a visual, full-color approach. More than 100 hands-on lessons are designed to teach the easiest, fastest, or most direct way to accomplish common Access tasks. The book is suited for new Access users, as well as those upgrading from an earlier version.

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Author
  3. Acknowledgments
  4. We Want to Hear from You!
  5. It's as Easy as 1-2-3
  6. Introduction
  7. 1. Learning Access Basics
    1. Database Window
    2. Starting Access
    3. Opening a Sample Database
    4. Using the Menu Bar
    5. Using Toolbars
    6. Using the Objects Bar
    7. Getting Help
    8. Closing a Database
    9. Quitting Access
  8. 2. Creating Databases and Tables
    1. Creating a Database from a Template
    2. Creating a New Blank Database
    3. Opening an Existing Database
    4. Creating a Table Using a Wizard
    5. Creating a Database Table from Scratch
    6. Displaying a Table in Design View
    7. Adding a New Field
    8. Changing a Field Name
    9. Setting a Field's Data Type
    10. Setting the Field Size for a Text Field
    11. Setting the Field Size for a Number Field
    12. Adding a Field Description
    13. Deleting a Field
    14. Setting the Primary Key
    15. Saving the Data Table
  9. 3. Entering Data
    1. Opening and Closing a Table in Datasheet View
    2. Entering Data in a Table
    3. Displaying Records
    4. Creating a New Record
    5. Selecting an Entry
    6. Selecting Records and Columns
    7. Freezing and Unfreezing Columns
    8. Hiding and Unhiding Columns
    9. Resizing Columns
    10. Rearranging Columns
    11. Editing a Record
    12. Deleting a Record
    13. Copying an Entry
    14. Copying an Entire Record
    15. Sorting Records in Datasheet View
    16. Finding Data
    17. Replacing Data
    18. Formatting the Datasheet
    19. Changing the Font
    20. Checking Spelling
    21. Previewing and Printing a Table
  10. 4. Editing a Database's Table Structure
    1. Viewing Field Properties
    2. Using Display Formats
    3. Using an Input Mask
    4. Adding a Field Caption
    5. Entering a Default Value
    6. Requiring an Entry
    7. Indexing a Field
    8. Applying a Smart Tag
    9. Creating a Yes/No Field
    10. Creating a Hyperlink Field
    11. Creating a Memo Field
    12. Creating an Object Field
    13. Adding an Entry to an Object Field
  11. 5. Creating and Using Forms
    1. Creating a Form Using an AutoForm
    2. Creating a Form Using a Wizard
    3. Saving a Form
    4. Opening a Form
    5. Using a Form to Add a New Record
    6. Using a Form to Display Records
    7. Using a Form to Edit Data
    8. Using a Form to Select Records
    9. Using a Form to Delete a Record
    10. Using a Form to Search for a Record
    11. Filtering Data by Selection
    12. Filtering Data by Form
    13. Viewing a Form in Design View
    14. Selecting a Form Control
    15. Deleting a Field from a Form
    16. Resizing a Form Control
    17. Moving a Form Control
    18. Adding a Field to a Form
    19. Changing the Tab Order
    20. Viewing and Formatting Form Controls
    21. Formatting Forms
  12. 6. Creating Queries
    1. Creating a Select Query with a Wizard
    2. Building a Query from Scratch
    3. Viewing the Query Design
    4. Entering Criteria to Query for an Exact Match
    5. Entering Criteria to Query for a Range of Matches
    6. Entering Multiple Criteria with the OR Operator
    7. Entering Criteria to Match More Than One Field
    8. Sorting Query Results
    9. Adding a Field to a Query
    10. Removing a Field from a Query
    11. Saving a Query
    12. Running a Query
    13. Creating a New Table with Query Results
    14. Deleting Records with a Query
  13. 7. Creating Reports
    1. Creating an AutoReport
    2. Creating a Report Using a Wizard
    3. Saving a Report
    4. Opening a Report
    5. Viewing a Report's Design
    6. Selecting a Report Control
    7. Deleting a Field from a Report
    8. Resizing a Report Control
    9. Moving a Report Control
    10. Adding a Field to a Report
    11. Adding Labels to a Report
    12. Adding Headers or Footers to a Report
    13. Drawing on a Report
    14. Adding a Picture to a Report
    15. Sorting and Grouping Data in a Report
    16. Using a Report AutoFormat
    17. Setting Up the Page
    18. Previewing a Report
    19. Printing a Report
  14. 8. Managing Your Database
    1. Renaming an Object
    2. Deleting an Object
    3. Password-Protecting a Database
    4. Backing Up the Database
    5. Viewing Database Properties
    6. Setting Up Relationships
    7. Editing Relationships
    8. Using Subdatasheets
  15. Glossary