The core-level Microsoft Office Access 2010 user should be able to navigate Microsoft Office Access 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Access 2010. The core-level user should be able to use Microsoft Office Access 2010 to create and edit database tables, forms, reports, queries etc for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life.
Learners taking this course should already be familiar with Microsoft Office Access 2003, Microsoft Office Access 2007, or some other database application. Learners who are familiar with Access 2003 and unfamiliar with the ribbon must complete Course ‘Introduction to the New Microsoft Office Fluent User Interface’.
At the course completion
This course provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.
Topics covered in this course include:
- Database Basics
- Creating a Database
- Defining a Primary Key
- Creating Datasheet Relationships
- Creating a Complex Query
- Using Lookup Fields
- Creating and Editing a Query in SQL View
- Creating a Report
- Creating Pivot Objects
- Creating and Editing a Macro
- Handling Errors in a Macro
- Creating and Editing a Module
- Packaging a Database
- Sharing a Database
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.
The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.
- Managing the Access Environment
- Building Tables
- Building Forms
- Creating and Managing Queries
- Designing Reports