You are previewing MOS 2010 Study Guide for Microsoft® Access®.
O'Reilly logo
MOS 2010 Study Guide for Microsoft® Access®

Book Description

Demonstrate your expertise with Microsoft Access 2010 with a MOS certification. Use this Study Guide and downloadable practice files to help advance your proficiency with Access and earn the credential that proves it.

Table of Contents

  1. MOS 2010 Study Guide for Microsoft® Access®
  2. A Note Regarding Supplemental Files
  3. Taking a Microsoft Office Specialist Exam
    1. Microsoft Office Specialist Certification
    2. Selecting a Certification Path
    3. Test-Taking Tips
    4. Certification Benefits
    5. For More Information
  4. Using This Book to Study for a Certification Exam
    1. Features and Conventions of This Book
  5. Using the Book’s Companion Content
  6. Modifying the Display of the Ribbon
  7. How to Get Support and Provide Feedback
    1. Errata & Book Support
    2. We Want to Hear from You
    3. Stay in Touch
  8. 1. Exam 77-885 Microsoft Access 2010 Specialist
    1. 1. Using the Access Workspace
      1. 1.1 Create and Manage a Database
        1. Creating a Database by Using a Template
        2. Using the Save Object As Command
        3. Using Open Dialog Box Options
        4. Working on the Save & Publish Page
          1. Using the Save Database As Option
          2. Using the Save Object As Option
          3. Publishing a Database to Access Services
        5. Compacting and Repairing a Database
        6. Encrypting a Database File
        7. Setting Access Options
          1. General
          2. Current Database
          3. Datasheet
          4. Object Designers
          5. Proofing
          6. Language
          7. Client Settings
          8. Add-Ins
          9. Trust Center
      2. 1.2 Configure the Navigation Pane
        1. Renaming Objects
        2. Deleting Objects
        3. Setting Options for the Navigation Pane
      3. 1.3 Use Application Parts
        1. Insert a Blank Form
        2. Using Quick Start Elements
        3. Applying a User Template
      4. Objective Review
    2. 2. Building Tables
      1. 2.1 Create Tables in Design View
        1. Getting Started
        2. Creating a Lookup Field
        3. Setting Table Properties
          1. Creating a Table Validation Rule
          2. Inserting a Subdatasheet
        4. Defining Indexes
        5. Creating a Data Macro
      2. 2.2 Create and Modify Fields
        1. Inserting, Deleting, and Renaming Fields
          1. Working with Fields in Datasheet View
          2. Working with Fields in Design View
        2. Hiding and Freezing Fields
        3. Setting and Updating Field Properties
          1. Setting Field Properties in Design View
          2. Setting Field Properties in Datasheet View
      3. 2.3 Sort and Filter Records
        1. Finding Records
        2. Sorting Records
        3. Filtering Records
      4. 2.4 Set Relationships
        1. Specifying a Primary Key
        2. Setting Relationships
      5. 2.5 Import Data from a Single Data File
        1. Importing Data into a New Table
          1. Importing Data from Excel
          2. Importing Data from Another Access Database
          3. Importing a Text File
        2. Appending Records
        3. Using Linked Tables
          1. Linking to a Table in Another Access Database
          2. Linking to an Excel Worksheet or a Text File
        4. Managing Linked Tables
      6. Objective Review
    3. 3. Building Forms
      1. 3.1 Create Forms
        1. Building a Form with the Form Wizard
        2. Creating a Blank Form
        3. Creating and Modifying a Form with Form Design Tools
        4. Building a Navigation Form
      2. 3.2 Apply Form Design Options
        1. Applying Themes to a Form
        2. Adding Form Controls
          1. Working with Control Properties
          2. Using Control Wizards
          3. Adding a Subform
        3. Using a Form Header and Footer
        4. Updating Forms from the Tools Group
          1. Setting Form Properties
          2. Setting the Tab Order for a Form
      3. 3.3 Arrange Fields and Objects on a Form
        1. Sizing and Ordering Controls in Design View
        2. Working with Control Layouts in Layout View
      4. 3.4 Format Forms
        1. Modifying a Form’s Background
        2. Formatting Form Controls
        3. Applying Conditional Formatting
          1. Checking Values in the Current Record or Using an Expression
          2. Using Data Bars
      5. Objective Review
    4. 4. Creating and Managing Queries
      1. 4.1 Construct Queries
        1. Selecting Records with a Query
          1. Using the Simple Query Wizard
          2. Using the Query Designer
        2. Using a Make-Table Query
        3. Appending Records with a Query
        4. Updating and Deleting Records with a Query
        5. Viewing Data in a Crosstab Query
          1. Using the Crosstab Query Wizard
          2. Creating a Crosstab Query in Design View
      2. 4.2 Manage Source Tables and Relationships
        1. Adding and Removing Data Sources for a Query
        2. Working with Joins and Relationships in a Query
      3. 4.3 Manipulate Fields
        1. Changing the Fields in a Query
        2. Showing and Hiding Query Fields
        3. Specifying the Sort Order for a Query
      4. 4.4 Calculate Totals
        1. Grouping Query Records
        2. Summarizing Data in a Query
      5. 4.5 Generate Calculated Fields
        1. Adding an Expression to a Query
        2. Entering an Expression in the Zoom Dialog Box
        3. Getting Help with the Expression Builder
      6. Objective Review
    5. 5. Designing Reports
      1. 5.1 Create Reports
        1. Running the Report Wizard
        2. Building a Report in Layout View
        3. Using Report Design Tools
      2. 5.2 Apply Report Design Tab Options
        1. Applying a Theme to a Report
        2. Grouping Report Fields and Calculating Totals
        3. Working with Controls on a Report
        4. Using a Subreport
        5. Adding Information to a Report’s Header and Footer
        6. Managing Report Fields and Properties
      3. 5.3 Apply Report Arrange Tab Options
        1. Arranging Reports in Design View
        2. Working with Report Layouts
      4. 5.4 Apply Report Format Tab Options
        1. Adding a Background Image to a Report
        2. Formatting Report Controls
        3. Highlighting Report Data with Conditional Formatting
      5. 5.5 Apply Report Page Setup Tab Options
        1. Specifying the Page Size for a Report
        2. Changing the Page Layout for a Report
      6. 5.6 Sort and Filter Records for Reporting
        1. Using Report View Types
        2. Filtering Records in Report View
      7. Objective Review
  9. About the Author
  10. Copyright