You are previewing Microsoft® Office Access™ 2007 Plain & Simple .
O'Reilly logo
Microsoft® Office Access™ 2007 Plain & Simple

Book Description

Get the fast facts that make learning Microsoft Office Access 2007 plain and simple! This no-nonsense guide uses easy numbered steps and concise, straightforward language that show the most expedient ways to learn a skill or solve a problem.

Table of Contents

  1. Microsoft® Office Access™ 2007 Plain & Simple
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. Acknowledgments
    3. 1. Introduction: About This Book
      1. No Computerese!
        1. Useful Tasks...
        2. ...And the Easiest Way to Do Them
      2. A Quick Overview
      3. A Few Assumptions
      4. A Final Word (or Two)
    4. 2. What’s New in Access 2007
      1. Familiarizing Yourself with the New User Interface
      2. Formatting Database Objects Using New AutoFormats
      3. Creating New Types of Fields
      4. Collecting Data from E-mail Messages
    5. 3. Introducing Access 2007
      1. Introducing Databases
        1. Storing Data on Index Cards
        2. Storing Data on the Computer
        3. Storing Data in a Database
      2. Starting Access
        1. Start Access
        2. Create a Shortcut for Access
      3. Surveying the Access Window
      4. Opening a Database
        1. Open a Database on Start-up
        2. Open a Recently Used Database
      5. Viewing Multiple Database Objects
        1. Close a Database Object
        2. Scroll within a Database Object
      6. Closing a Database and Exiting Access
        1. Close a Database
        2. Exit Access
      7. Displaying and Managing Database Objects
        1. Open a Database Object
        2. Control Object Display in the Navigation Pane
      8. Using the Access Help System
        1. Get Suggested Commands from Shortcut Menus
        2. Get Microsoft Access Help
        3. Get Help on the Web
    6. 4. Getting to Know Access Databases
      1. Viewing a Sample Database
        1. Open a Sample Database
      2. Working with Database Objects
        1. Display a Class of Objects
        2. Open an Object
        3. View an Object in Design View
        4. Save an Object
        5. Delete an Object
      3. Examining a Table
        1. View a Table
        2. Navigate in a Table
      4. Examining a Form
        1. View a Form
        2. Enter Data Using a Form
        3. Navigating Using a Switchboard
        4. Open a Switchboard
        5. Move Using a Switchboard
      5. Examining a Query
        1. View a Query
      6. Examining a Report
        1. View a Report
      7. Using the Database Templates
        1. Create a Database from a Template
        2. Find Database Templates Online
      8. Frequently Used Object Views
        1. Access Object Views
    7. 5. Creating a Database
      1. Designing a Database
        1. One Table Per Object
        2. Give Every Table a Primary Key
        3. Include Foreign Keys
      2. Creating a New Database
        1. Begin a New Database
        2. Create a New Database Based on Another Database
      3. Creating a New Table in Design View
        1. Create a Table in Design View
      4. Creating a New Table by Typing
        1. Create a New Table by Typing
      5. Adding Existing Fields to a Table
        1. Add Fields from the Field Templates Task Pane
        2. Add Fields from Existing Tables
      6. Setting a Primary Key
        1. Assign a Primary Key
      7. Getting Data from Other Access Tables
        1. Copy a Table from Another Database
      8. Relationships Explained
        1. One-to-Many Relationships
        2. Many-to-Many Relationships
      9. Creating Relationships between Tables
        1. Define a Relationship
      10. Enforcing Referential Integrity
        1. Enforce Referential Integrity
    8. 6. Customizing Fields
      1. Working with Tables
        1. Delete a Field
        2. Add a Field
        3. Arrange Fields
      2. Assigning a Data Type
        1. Pick a Data Type
          1. Available Data Types
      3. Viewing or Changing Field Properties
        1. View Field Properties
      4. Introducing the Expression Builder
      5. Formatting Field Contents
        1. Change Field Format
      6. Creating Input Masks
        1. Define an Input Mask
        2. Edit an Input Mask
      7. Assigning Required Fields and Requiring Data Entry
        1. Require Data Entry
        2. Disallow Zero-Length Strings
      8. Setting Default Values
        1. Assign a Default Value
      9. Indexing Field Values
        1. Create an Index
      10. Validating Data Entry
        1. Perform Data Validation
        2. Set Validation Text
      11. Creating a Lookup Field
        1. Define a Field as a Lookup Field
        2. Allow Multiple Selections from a Lookup Field
        3. Draw Lookup Values from a Data List
      12. Creating an Append-Only Memo Field
        1. Create an Append-Only Field
      13. Creating an Attachment Field
        1. Create an Attachment Field
    9. 7. Customizing Tables
      1. Finding and Replacing Text
        1. Find Text
        2. Replace Text
      2. Entering Data Using AutoCorrect
        1. Add Text with AutoCorrect
        2. Turn AutoCorrect On or Off
        3. Add AutoCorrect Values
      3. Adding and Editing Text
        1. Select Text
        2. Delete Text
        3. Undoing Operations
        4. Copy and Paste Text
        5. Copy and Paste Items with the Office Clipboard
      4. Manipulating Columns
        1. Relocate a Column
        2. Insert a Column
        3. Rename a Column
        4. Copy a Column
      5. Modifying Columns and Rows
        1. Change Row Height
        2. Change Column Width
      6. Viewing a Subdatasheet
        1. Open and Close a Subdatasheet
        2. Create a Subdatasheet
      7. Filtering Table Records
        1. Filter Table Records
        2. Filter by Form
        3. Remove a Filter
        4. Filter Records by the Contents of More than One Column
    10. 8. Creating Forms
      1. Creating a Simple Form
        1. Create a Simple Form
      2. Creating a Form Using the Form Wizard
        1. Step through the Form Wizard
      3. Creating a Form in Design View
        1. Create a Form in Design View
      4. Creating a Multiple Items Form
        1. Create a Multiple Items Form
      5. Modifying an Existing Form
        1. Open a Form for Editing in Design View
        2. Display the Field List
        3. Hide the Field List
        4. Add a Field to a Form
      6. Adding and Deleting Form Controls
        1. Add a Control with a Wizard
        2. Delete a Control
        3. Modify Control Properties
          1. Available Control Types
      7. Adding a Date Picker Control
        1. Add a Date Picker
      8. Creating a Subform
        1. Add a Subform
        2. Change Subform Views
      9. Displaying a Form and Its Datasheet Simultaneously
        1. Create a Split Form
    11. 9. Creating Queries
      1. Introducing Query Types
      2. Creating a Query Using the Query Wizard
        1. Create a Detail Query
        2. Create a Summary Query
      3. Editing a Query in Design View
        1. Open a Query for Editing
        2. Add a Table to a Query
        3. Add a Field to a Query
        4. Create a Query in Design View
      4. Using Criteria to Focus Query Results
        1. Set Query Criteria
      5. Introducing Operators
        1. Arithmetic Operators
        2. Comparison Operators
        3. Logical Operators
      6. Using Queries to Calculate Values
        1. Calculate a Value in a Query
      7. Finding Duplicate Records
        1. Create a Find Duplicates Query
      8. Finding Unmatched Records
        1. Create a Find Unmatched Records Query
      9. Writing Query Results to a New Table
        1. Create a Make-Table Query
      10. Creating an Update Query
        1. Update Table Values with a Query
      11. Creating a Crosstab Query
        1. Build a Crosstab Query
      12. Finding the Largest and Smallest Values in a Field by Using a Query
        1. Find the Largest Values in a Field
        2. Find the Smallest Values in a Field
    12. 10. Creating Reports
      1. Creating a Report Using the Report Wizard
        1. Step through the Report Wizard
      2. Creating a Summary Report
        1. Build a Summary Report
      3. Creating a Report in Design View
        1. Build a New Report
      4. Modifying an Existing Report
        1. Open a Report for Editing
        2. Display or Hide the Field List Task Pane
        3. Add a Field to a Report
      5. Adding and Deleting Report Controls
        1. Add a Control Using a Wizard
        2. Delete a Control
        3. Modify Control Properties
      6. Calculating Values in a Report
        1. Create a Calculated Field
      7. Introducing Report Sections
      8. Grouping Report Records
        1. Create a Grouping Level
        2. Reorder Grouping Levels
        3. Delete a Grouping Level
      9. Creating a Subreport
        1. Add a Subreport
      10. Creating Mailing Labels
        1. Generate Mailing Labels
    13. 11. Beautifying Forms and Reports
      1. Formatting Text
        1. Change Text Formatting
      2. Applying AutoFormats
        1. Select an AutoFormat
        2. Apply AutoFormat Elements
        3. Customize an AutoFormat
        4. Create an AutoFormat
      3. Setting Control Appearance
        1. Change Control Colors
        2. Format Controls with Special Effects
        3. Distribute Controls Horizontally
        4. Distribute Controls Vertically
        5. Align Controls
      4. Adding Lines, Shapes, and Borders
        1. Draw a Line
        2. Add a Border
        3. Change an Object’s Fill Color
      5. Editing Lines and Borders
        1. Resize a Line
        2. Change Line and Border Color
      6. Showing Gridlines in a Report
        1. Turn Gridlines On or Off
        2. Change Gridline Appearance
      7. Coloring Alternate Rows in a Form or Report
        1. Color Alternate Data Rows
      8. Adding a Totals Row to a Datasheet
        1. Add a Totals Row
      9. Adding a Picture
        1. Embed a Picture
        2. Change an Embedded Picture to a Linked Picture
      10. Applying Conditional Formatting
        1. Define a Conditional Format
      11. Changing the Source of an Image
        1. Define a New Image Source
      12. Setting Image Alignment and Backing Color
        1. Set a Backing Color
        2. Change a Picture’s Alignment
      13. Tiling a Picture
        1. Repeat a Picture on a Form or Report
      14. Setting Image Height and Width
        1. Set a Precise Image Height and Width
        2. Set an Image’s Resizing Property
    14. 12. Creating Charts in Access
      1. Creating a Chart
        1. Build a New Chart
      2. Formatting Chart Elements
        1. Change an Element’s Fill Color
        2. Change an Element’s Font, Size, and Style
        3. Change an Element’s Number Format
      3. Customizing Chart Axes
        1. Add a Title to an Axis
        2. Show or Hide Axis Gridlines
      4. Add Information to a Chart
        1. Show or Hide a Chart Legend
        2. Change the Legend’s Location
        3. Add a Text Box
      5. Changing a Chart’s Type
        1. Select a Different Chart Type
    15. 13. Interacting with Other Programs
      1. Introducing Linking and Embedding
      2. Inserting a New Object
        1. Embed an Existing Object
        2. Link to an Existing Object
      3. Manipulating Objects
        1. Copy an Object
        2. Paste an Object
        3. Move an Object
        4. Resize an Object
      4. Inserting Excel Charts and Worksheets
        1. Add an Excel Chart
        2. Add an Excel Worksheet
      5. Importing Data from Another Access Database
        1. Import One or More Tables
      6. Linking to a Table in Another Access Database
        1. Create a Link to a Table
      7. Working with Hyperlinks
        1. Create a Hyperlink to an Existing File
        2. Create a Hyperlink to a Web Page
        3. Create a Hyperlink to an Existing Database Object
      8. Importing Data from an Excel File
        1. Import Excel Data
      9. Importing Data from a Text File
        1. Import Text Data
      10. Importing Data from an XML File
        1. Import XML Data
      11. Exporting Data to a Text File
        1. Export Text Data
      12. Exporting Data to Another Access File
        1. Export to Another Access Database
      13. Exporting Data to an XML File
        1. Export XML Data
      14. Saving Database Objects as Web Files
        1. Save an Object as a Web File
      15. Analyzing Data with Microsoft Excel
        1. Analyze Data in Excel
      16. Publishing Data to Microsoft Word
        1. Export Data to Word
      17. Collecting Data from E-mail Messages
        1. Send a Data Collection E-Mail Message
        2. Process Data Collection E-Mail Messages
    16. 14. Administering a Database
      1. Introducing Database Security
        1. Passwords
        2. Encrypting Databases
      2. Encrypting a Database
        1. Encrypt a Database
        2. Decrypt a Database
      3. Locking Database Records
        1. Prevent More than One User from Editing a Form Record
        2. Lock Records in a Form
      4. Creating a Switchboard
        1. Create a Switchboard
        2. Add a Switchboard Page
        3. Add an Item to a Switchboard Page
      5. Documenting a Database
        1. Document a Database
      6. Setting Startup Options
        1. Change an Application Title
        2. Hide All Menus
        3. Set Startup Form
        4. Set Startup Display Options
    17. 15. Customizing Access
      1. Adding Buttons to the Quick Access Toolbar
        1. Add a Button
        2. Remove a Button
        3. Add a Group
        4. Remove a Group
      2. Building a Macro
        1. Create a Macro
      3. Running a Macro
        1. Run a Macro
        2. Step through a Macro
      4. Defining Macro Groups
        1. Create a Macro Group
      5. Adding and Deleting Macro Actions
        1. Insert a Macro Step
        2. Delete a Macro Step
      6. Launching a Macro from a Button
        1. Assign a Macro to a Button
      7. Displaying a Message Box
        1. Create a Message Box
      8. Running a Macro When a Form Opens
        1. Run a Macro When a Form Opens
      9. Changing AutoCorrect Options
        1. Change AutoCorrect Options
        2. Add AutoCorrect Rules
        3. Delete an AutoCorrect Entry
    18. 16. Presenting Table and Query Data Dynamically
      1. Introducing PivotTables and PivotCharts
        1. Pivoting
        2. Filtering
        3. PivotCharts
      2. Creating a PivotTable
        1. Create a PivotTable Form
      3. Adding and Removing PivotTable Fields
        1. Add a Field to a PivotTable
        2. Remove a Field from a PivotTable
      4. Pivoting a PivotTable
        1. Reorganize PivotTable Data
      5. Filtering PivotTable Data
        1. Select Which Field Values to Display
        2. Filter by a Field Not Displayed in the Body of a PivotTable
        3. Toggle a Filter On and Off
      6. Formatting a PivotTable
        1. Change a PivotTable’s Appearance
      7. Creating a PivotChart
        1. Step through the PivotChart Wizard
        2. Change a PivotChart Chart Type
    19. A. About the Author
    20. B. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
        4. Other Titles
    21. Index
    22. About the Author
    23. SPECIAL OFFER: Upgrade this ebook with O’Reilly