MOS Boot Camp – MS Access 2010

Microsoft Office Specialist certification gives you the tools to build a brighter future.

• Achieve industry-recognized certification
• Learn the computing skills companies are looking for
• Boost your workforce resume
• Differentiate yourself from other applicants
• Gain valuable experience and confidence
• Heighten your earning potential
• Prepare yourself for a successful future

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.

The Access 2010 user typically:

• is effective in creating, modifying, and personalizing objects
• is capable of working independently on database projects
• often answers questions from others about databases
• has created or modified a simple Access database
• can use templates to create basic objects

Managing the Access Environment

• Create and manage a database.
• Configure the Navigation Pane.
• Apply Application Parts.

Building Tables

• Create tables.
• Create and modify fields.
• Sort and filter records.
• Set relationships.
• Import data from a single data file.

Building Forms

• Create forms.
• Apply Form Design Tab options.
• Apply Form Arrange Tab options.
• Apply Form Format Tab options.

Creating and Managing Queries

• Construct queries.
• Manage source tables and relationships.
• Manipulate fields.
• Calculate totals.
• Generate calculated fields.

Designing Reports

• Create reports.
• Apply Report Design Tab options.
• Apply Report Arrange Tab options.
• Apply Report Format Tab options.
• Apply Report Page Setup Tab options.
• Sort and filter records for reporting.