Microsoft Access 2010
Microsoft Exam 77-885
Course outline
About this Exam The typical candidate for the exam works as a user support
professional, trainer, teacher, professor, database user, or database creator
who needs to create or maintain a basic Access database. Users can create,
modify, and extend functionality of basic database objects, including tables,
queries, forms, and reports. Users can also construct and modify basic
relationships among database entities and can instruct others in basic Access
functionality and usage. |
Credit Toward Certification When you pass Exam 77-885: Access 2010, you complete the
requirements for the following certification(s): Microsoft Office Specialist (MOS): Access 2010 |
Skills Being Measured This exam measures your ability to accomplish the technical
tasks listed below. |
Managing
the Access Environment ·
Create and manage a database. o
This objective may include but is
not limited to: using Save Object As, Open, Save and Publish, Compact &
Repair Database, and Encrypt with Password commands, creating a database from
a template, and setting Access options ·
Configure the Navigation Pane. o
This objective may include but is
not limited to: renaming objects, deleting objects, and setting Navigation
options ·
Apply Application Parts. o
This objective may include but is
not limited to: using Blank Forms, Quick Start, and user templates Building
Tables ·
Create tables. o
This objective may include but is
not limited to: creating tables in Design View ·
Create and modify fields. o
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. o
This objective may include but is
not limited to: using Find, Sort, and Filter commands ·
Set relationships. o
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. o
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. o
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. o
This objective may include but is
not limited to: using the Themes, Controls, Header/Footer, and Tools groups ·
Apply Form Arrange Tab options. o
This objective may include but is
not limited to: using the Table, Move, and Position groups ·
Apply Form Format Tab options. o
This objective may include but is
not limited to: using the Background and Control Formatting groups Creating
and Managing Queries ·
Construct queries. o
This objective may include but is
not limited to: using Select, Make Table, Append, and Crosstab query types ·
Manage source tables and
relationships. o
This objective may include but is
not limited to: using the Show Table and Remove Table commands, and creating
ad hoc relationships ·
Manipulate fields. o
This objective may include but is
not limited to: adding, removing, and rearranging fields, and using Sort and
Show options ·
Calculate totals. o
This objective may include but is not
limited to: using the Total row and using Group By ·
Generate calculated fields. o
This objective may include but is
not limited to: performing calculations, using the Zoom box, and using
Expression Builder Designing
Reports ·
Create reports. o
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. o
This objective may include but is
not limited to: using the Themes, Grouping & Totals, Controls,
Header/Footer, and Tools groups ·
Apply Report Arrange Tab options. o
This objective may include but is
not limited to: using the Table, Move, Position, and Sizing & Ordering
groups ·
Apply Report Format Tab options. o
This objective may include but is
not limited to: adding color, background images, and conditional formatting ·
Apply Report Page Setup Tab options. o
This objective may include, but is
not limited to: using the Page Size andPage Layout
groups ·
Sort and filter records for
reporting. o
This objective may include but is
not limited to: using the Find, Sort, and Filter commands, and using view
types |