You are previewing Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007.
O'Reilly logo
Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Book Description

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up, and you will find clear, step-by-step screen shots that show you how to tackle more than 170 Access 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including

* Navigating the new interface

* Using templates to create databases

* Entering and editing data

* Working with tables and fields

* Creating simple or summary queries

* Linking to Excel(r) worksheets

* Helpful sidebars offer practical tips and tricks

* Full-color screen shots demonstrate each task

* Succinct explanations walk you through step by step

* Two-page lessons break big topics into bite-sized modules

Table of Contents

  1. Copyright
    1. Trademark Acknowledgments
    2. Contact Us
  2. Praise for Visual Books
  3. Credits
  4. About the Author
  5. Author's Acknowledgments
  6. How to Use This Book
    1. How to Use This Teach Yourself VISUALLY Book
    2. Who Needs This Book
    3. Book Organization
    4. Chapter Organization
    5. Using the Mouse
    6. The Conventions in This Book
  7. 1. Getting Started with Access 2007
    1. 1.1. An Introduction to Access
    2. 1.2. Start and Exit Access
    3. 1.3. Create a Blank Database
    4. 1.4. Close a Database
    5. 1.5. Create a Database Using a Template
    6. 1.6. Open a Database File
    7. 1.7. Understanding the Access 2007 Interface
    8. 1.8. Change the Navigation Pane View
    9. 1.9. Open and Close an Object
    10. 1.10. View an Object
  8. 2. Entering and Editing Data
    1. 2.1. Enter New Records
    2. 2.2. Navigate between Records
    3. 2.3. Edit Records
    4. 2.4. Attach Files to Records
    5. 2.5. Open, Save, and Remove File Attachments
    6. 2.6. Insert an OLE Object
    7. 2.7. Open, Edit, and Remove OLE Objects
    8. 2.8. Enter Data in a Multivalued Field
    9. 2.9. Delete Records
    10. 2.10. Resize Datasheet Columns and Rows
    11. 2.11. Sort Records
    12. 2.12. Display Summary Statistics
    13. 2.13. Print a Datasheet or Form
  9. 3. Working with Tables
    1. 3.1. Plan Effective Tables
    2. 3.2. Create a Table from a Template
    3. 3.3. Save a Table
    4. 3.4. Create a Table in Datasheet View
    5. 3.5. Create a Table by Copying Another Table's Structure
    6. 3.6. Create a SharePoint List
    7. 3.7. Create a Table in Design View
    8. 3.8. Understanding Primary and Composite Keys
    9. 3.9. Set the Primary or Composite Key
    10. 3.10. Rename a Table
    11. 3.11. Delete a Table
  10. 4. Working with Fields
    1. 4.1. Open a Table in Design View
    2. 4.2. Rearrange Fields
    3. 4.3. Insert and Delete Fields
    4. 4.4. Understanding Data Types
    5. 4.5. Change a Field's Data Type
    6. 4.6. Understanding Field Properties
    7. 4.7. Understanding Field Sizes
    8. 4.8. Change a Field Size
    9. 4.9. Set a Field's Format
    10. 4.10. Set a Field Caption
    11. 4.11. Set a Default Value
    12. 4.12. Make a Field Required
    13. 4.13. Index a Field
    14. 4.14. Apply Smart Tags
    15. 4.15. Create an Input Mask
    16. 4.16. Create a Validation Rule
    17. 4.17. Create a Record-Level Validation Rule
  11. 5. Working with Relationships and Lookups
    1. 5.1. Understanding Relationships
    2. 5.2. Create a Relationship between Two Tables
    3. 5.3. Edit a Relationship
    4. 5.4. Remove a Relationship
    5. 5.5. Arrange the Relationships Window
    6. 5.6. Print a Relationship Report
    7. 5.7. View Object Dependencies
    8. 5.8. Document the Database
    9. 5.9. Understanding Lookups
    10. 5.10. Create a Table for Use As a Field Lookup
    11. 5.11. Create a Field Lookup Based on a Table
    12. 5.12. Create a Field Lookup with Values That You Specify
    13. 5.13. Set Up a Multivalued Field
  12. 6. Finding and Filtering Data
    1. 6.1. Understanding Find and Replace
    2. 6.2. Find Data Using Find and Replace
    3. 6.3. Replace Data Using Find and Replace
    4. 6.4. Filter to Show Only Blank or Nonblank Entries
    5. 6.5. Filter by Selection
    6. 6.6. Filter for Multiple Values
    7. 6.7. Using Text Filters
    8. 6.8. Filter by Form
    9. 6.9. Save a Filter As a Query
  13. 7. Creating Simple Queries
    1. 7.1. Understanding Queries
    2. 7.2. Create a Query with the Simple Query Wizard
    3. 7.3. Start a New Query in Query Design View
    4. 7.4. Insert, Arrange, and Remove Query Fields
    5. 7.5. Set Field Sorting
    6. 7.6. Add an Alias to a Query Field
    7. 7.7. Understanding Criteria
    8. 7.8. Filter a Query for a Specific Value
    9. 7.9. Specify a Range of Values
    10. 7.10. Specify a List of Values
    11. 7.11. Hide a Field in the Query Results
    12. 7.12. Combine Criteria
    13. 7.13. Limit the Records Returned
  14. 8. Creating More Complex Queries
    1. 8.1. Understanding Summary Queries
    2. 8.2. Create a Summary Query with the Simple Query Wizard
    3. 8.3. Create a Summary Query in Query Design View
    4. 8.4. Understanding Calculated Fields
    5. 8.5. Create a Calculated Field
    6. 8.6. Understanding Action Queries
    7. 8.7. Run a Make Table Query
    8. 8.8. Run a Delete Query
    9. 8.9. Run an Append Query
    10. 8.10. Run an Update Query
    11. 8.11. Prompt the User for a Parameter
    12. 8.12. Understanding Parameter Syntax
  15. 9. Creating Forms
    1. 9.1. Understanding Forms
    2. 9.2. Create and Save a Form
    3. 9.3. Create a Form with the Form Wizard
    4. 9.4. Create a Form in Layout View
    5. 9.5. Create a Form in Design View
    6. 9.6. Delete a Field from Design View
    7. 9.7. Arrange Fields on a Form
    8. 9.8. Group Fields Together
    9. 9.9. Define the Tab Order on a Form
  16. 10. Modifying and Formatting Forms
    1. 10.1. Display the Header and Footer
    2. 10.2. Size Sections of a Form
    3. 10.3. Select Sections of a Form
    4. 10.4. Add a Form Title
    5. 10.5. Apply an AutoFormat Preset
    6. 10.6. Apply an AutoFormat Style
    7. 10.7. Create an AutoFormat Style by Example
    8. 10.8. Adjust Internal Margins and Padding
    9. 10.9. Add a Label
    10. 10.10. Format Label Text
    11. 10.11. Change the Background Color
    12. 10.12. Add a Hyperlink
    13. 10.13. Add a Tabbed Section
    14. 10.14. Insert a Logo or Image
    15. 10.15. Set Conditional Formatting
  17. 11. Creating and Formatting Reports
    1. 11.1. Understanding Report Views
    2. 11.2. Create a Simple Report
    3. 11.3. AutoFormat a Report
    4. 11.4. Preview and Print a Report
    5. 11.5. Create a Report with the Report Wizard
    6. 11.6. Create a Report in Layout View
    7. 11.7. Set the Page Size and Orientation
    8. 11.8. Change the Report Layout Type
    9. 11.9. Set Page Margins
    10. 11.10. Set Control Margins and Padding
    11. 11.11. Format Report Text
    12. 11.12. Size and Align Report Fields
    13. 11.13. Insert a Page Numbering Code
  18. 12. Grouping and Summarizing Data
    1. 12.1. Understanding Grouping and Summarizing
    2. 12.2. Group Report Results
    3. 12.3. Sort Report Results
    4. 12.4. Count Records
    5. 12.5. Add an Aggregate Function
    6. 12.6. Summarize a Datasheet with a PivotTable
    7. 12.7. Add Aggregate Functions to a PivotTable
    8. 12.8. Group and Ungroup PivotTable Content
    9. 12.9. Clear a PivotTable Grid
    10. 12.10. Switch a PivotTable to a PivotChart
  19. 13. Creating Mailing Labels and Charts
    1. 13.1. Create Labels
    2. 13.2. Add a Field to an Existing Line
    3. 13.3. Add a Field to a Label As a Separate Line
    4. 13.4. Color the Label Background
    5. 13.5. Color the Label Text
    6. 13.6. Apply Font Formatting to Label Text
    7. 13.7. Export Labels to Word
    8. 13.8. Open a PivotChart View
    9. 13.9. Create a PivotChart
    10. 13.10. Group Data in a PivotChart
    11. 13.11. Change the PivotChart Type
    12. 13.12. Change Chart Colors
  20. 14. Working with External Data
    1. 14.1. Import an Excel Worksheet
    2. 14.2. Link to an Excel Worksheet
    3. 14.3. Manage Linked Tables
    4. 14.4. Import a Table from Another Access Database
    5. 14.5. Import Data from a Delimited Text File
    6. 14.6. Export Data to Excel
    7. 14.7. Export Data as HTML
    8. 14.8. Export Data to a Plain Text File
    9. 14.9. Save Import or Export Specifications
    10. 14.10. Using Saved Import or Export Specifications
  21. 15. Maintaining a Database
    1. 15.1. Set a Trusted Location
    2. 15.2. Save in a Previous Version Format
    3. 15.3. Convert to the Access 2007 Format
    4. 15.4. Back Up a Database
    5. 15.5. Document a Database
    6. 15.6. Compact and Repair a Database
    7. 15.7. Password-Protect a Database