You are previewing Microsoft® Access® 2010 Plain & Simple.
O'Reilly logo
Microsoft® Access® 2010 Plain & Simple

Book Description

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You'll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.

Here's WHAT you'll learn:

  • Design and build your own database quickly

  • Use Access forms to collect information with ease

  • Create and modify tables to organize your data

  • Store files such as documents and images

  • Exchange data with other databases and documents

  • Bring your data alive with colorful reports

  • Here's HOW you'll learn it:

  • Jump in whenever you need answers

  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do

  • Handy TIPS teach new techniques and shortcuts

  • Quick TRY THIS! exercises help apply what you learn right away

  • Table of Contents

    1. Microsoft® Access® 2010 Plain & Simple
    2. 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)
    3. 2. What’s New in Access 2010?
      1. Managing Access Settings and Files in Backstage View
      2. Customizing the Access 2010 User Interface
      3. Creating Databases Using Improved Templates
      4. Building Databases by Re-Using Application Parts
      5. Creating Navigation Forms
      6. Formatting Database Objects Using Office Themes
      7. Gaining Insights into Data Using Conditional Formatting
      8. Defining Calculated Fields Using the Improved Expression Builder
    4. 3. Introducing Access 2010
      1. Introducing Databases
        1. Storing Data on Index Cards
        2. Storing Data on the Computer
        3. Storing Data in a Database
      2. Starting Access 2010
        1. Start Access 2010
        2. Create a Shortcut for Access 2010
      3. Surveying the Access 2010 Window
      4. Opening a Database
        1. Open a Database on Startup
        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 2010
        1. Close a Database
        2. Exit Access 2010
      7. Displaying and Managing Database Objects
        1. Open a Database Object
        2. Control Object Display in the Navigation Pane
      8. Using the Access 2010 Help System
        1. Get Suggested Commands from Shortcut Menus
        2. Get Microsoft Access 2010 Help
        3. Get Help on the Web
    5. 4. Creating a Database
      1. Designing a Database
        1. One Table per Object
        2. Give Every Table a Primary Key
        3. Include Foreign Keys
      2. Viewing a Sample Database
        1. Open a Sample Database
      3. Creating a New Database
        1. Begin a New Database
        2. Create a New Database Based on Another Database
      4. Creating Databases Using Database Templates
        1. Create a Database from a Template
        2. Find Database Templates Online
      5. Creating a New Table in Design View
        1. Create a Table in Design View
      6. Creating a New Table by Typing
        1. Create a New Table by Typing
      7. Creating a New Table Using a Template
        1. Add Fields from the Add & Delete Ribbon Group
        2. Add More Types of Fields
        3. Add Multiple Related Fields at One Time
      8. Creating a New Table Using Application Parts
        1. Create a Table, Forms, and Reports Using Application Parts
      9. Setting a Primary Key
        1. Assign a Primary Key
      10. Getting Data from Other Access 2010 Tables
        1. Copy a Table from Another Database
      11. Relationships Explained
        1. One-to-Many Relationships
        2. Many-to-Many Relationships
      12. Creating Relationships Between Tables
        1. Define a Relationship
      13. Enforcing Referential Integrity
        1. Enforce Referential Integrity
    6. 5. 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
    7. 6. 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 Subworksheet
        1. Open and Close a Subworksheet
        2. Create a Subworksheet
      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
    8. 7. 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 Using 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
    9. 8. 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. Creating a Parameter Query
        1. Build a Parameter Query
      8. Finding Duplicate Records
        1. Create a Find Duplicates Query
      9. Finding Unmatched Records
        1. Create a Find Unmatched Records Query
      10. Writing Query Results to a New Table
        1. Create a Make-Table Query
      11. Creating an Update Query
        1. Update Table Values with a Query
      12. Creating a Crosstab Query
        1. Build a Crosstab Query
      13. 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
    10. 9. 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 Subform or Subreport
        1. Add a Subform or Subreport
      10. Creating Mailing Labels
        1. Generate Mailing Labels
    11. 10. Beautifying Forms and Reports
      1. Formatting Text
        1. Change Text Formatting
      2. Introducing Office Themes
      3. Applying Office Themes
        1. Select an Office Theme
        2. Apply Office Theme Elements
        3. Combine Existing Elements into a New Office Theme
        4. Create a Custom Office Theme
      4. Setting Control Appearance
        1. Change Control Colors
        2. Format Controls with Special Effects
        3. Distribute Controls Horizontally
        4. Distribute Controls Vertically
        5. Align Controls
      5. Adding Lines, Shapes, and Borders
        1. Draw a Line
        2. Add a Border
        3. Change an Object’s Fill 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 Worksheet
        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
        2. Define a Data Bar 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
    12. 11. Creating Charts in Access 2010
      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
    13. 12. 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 2010 Charts and Worksheets
        1. Add an Excel 2010 Chart
        2. Add an Excel 2010 Worksheet
      5. Importing Data from Another Access 2010 Database
        1. Import One or More Tables
      6. Linking to a Table in Another Access 2010 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 2010 File
        1. Import Excel 2010 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 2010 File
        1. Export to Another Access 2010 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 Excel 2010
        1. Analyze Data in Excel 2010
      16. Publishing Data to Word 2010
        1. Export Data to Word 2010
      17. Collecting Data from E-mail Messages
        1. Send a Data Collection E-Mail Message
        2. Process Data Collection E-Mail Messages
    14. 13. 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 Navigation Form
        1. Create a Navigation Form
        2. Add an Object to a Navigation Form
        3. Change the Appearance of a Navigation Form Tab
        4. Move a Navigation Form Tab
      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
    15. 14. Customizing Access 2010
      1. Adding Commands to the Quick Access Toolbar
        1. Add a Command to the Quick Access Toolbar
        2. Remove a Command from the Quick Access Toolbar
        3. Move the Quick Access Toolbar
      2. Modifying the Ribbon User Interface
        1. Add a Command to a Ribbon Tab
        2. Reorder Commands on a Ribbon Tab
        3. Remove a Ribbon Element
        4. Create a Custom Ribbon Tab
        5. Add a New Group to a Ribbon Tab
        6. Rename a Ribbon Element
        7. Hide a Ribbon Element
        8. Redisplay a Hidden Ribbon Element
      3. Changing AutoCorrect Options
        1. Change AutoCorrect Options
        2. Add AutoCorrect Rules
        3. Delete an AutoCorrect Entry
    16. 15. 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
    17. A. About the Author
    18. Index
    19. About the Author
    20. Copyright