Microsoft Access 2010

Managing the Access Environment

  • Create and manage a database.
    • This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact and Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options
  • Configure the Navigation Pane.
    • This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options
  • Apply Application Parts.
    • This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates

Building Tables

  • Create tables.
    • This objective may include but is not limited to: creating tables in Design View
  • Create and modify fields.
    • This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties
  • Sort and filter records.
    • This objective may include but is not limited to: using Find, Sort, and Filter commands
  • Set relationships.
    • This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships
  • Import data from a single data file.
    • This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table

Building Forms

  • Create forms.
    • This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms
  • Apply Form Design Tab options.
    • This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups
  • Apply Form Arrange Tab options.
    • This objective may include but is not limited to: using the Table, Move, and Position groups
  • Apply Form Format Tab options.
    • This objective may include but is not limited to: using the Background and Control Formatting groups

Creating and Managing Queries

  • Construct queries.
    • This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types
  • Manage source tables and relationships.
    • This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships
  • Manipulate fields.
    • This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options
  • Calculate totals.
    • This objective may include but is not limited to: using the Total row and using Group By
  • Generate calculated fields.
    • This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder

Designing Reports

  • Create reports.
    • This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard
  • Apply Report Design Tab options.
    • This objective may include but is not limited to: using the Themes, Grouping and Totals, Controls, Header/Footer, and Tools groups
  • Apply Report Arrange Tab options.
    • This objective may include but is not limited to: using the Table, Move, Position, and Sizing and Ordering groups
  • Apply Report Format Tab options.
    • This objective may include but is not limited to: adding color, background images, and conditional formatting
  • Apply Report Page Setup Tab options.
    • This objective may include, but is not limited to: using the Page Size andPage Layout groups
  • Sort and filter records for reporting.

This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types