GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

QuickCert's Access 2010 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Access 2010 Exam 77-885, you achieve Microsoft Certified Application Specialist (MOS) status in Access 2010.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2010.

As a Microsoft Certified Partner, QuickCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert MOS Microsoft Certified Application Specialist Exam Training Course: Access 2010 Package Includes:

Delivery Format	Instructor Led Modules	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

MOS Microsoft Certified Application Specialist Exam Training Course: Access 2010 Curriculum:

Access 2010

 

Course Introduction
Instructor Introduction
Access Overview
Course Outline

Section 1: Access Basics
Section Overview
What Does Access Do?
Access Application Window
Database Objects
Basic Database and Table Management
Customizing Access
Keyboard Shortcuts
Section Review

Section 2: Designing a Database
Section Overview
Database Design Process
Normalizing Data
Setting Primary and Foreign Keys
Section Review

Section 3: Building a Database
Section Overview
Creating A New Database
Creating Tables
Inserting Field's in Tables
Setting Up Field Properties
Formatting the Datasheet View
Creating Relationships
Keyboard Shortcuts
Section Review

Section 4: Managing Table Data
Section Overview
Updating and Deleting Records
Finding and Replacing Values
Adding a Total Row
Using Sub-datasheets
Sorting Data
Filtering Data
Keyboard Shortcuts
Section Review

Section 5: Creating Selection Queries
Section Overview
Creating Queries Using the Query Wizard
Creating Queries Using the Query Design View
Adding Criteria
Add Calculated Fields to Query
Section Review

Section 6: Creating and Managing Forms
Section Overview
Form Basics and Creating Forms
Contextual Tabs Design and Layout View
Managing Table Data with Forms
Modifying the Look and Design
Design Tab Controls
Section Review

Section 7: Creating and Managing Reports
Section Overview
Creating Reports, Report Views, and Managing Report Sections
Adding Calculated Fields and Formatting The Report Controls
Section Review

Section 8: Controlling Data Entry
Section Overview
Setting Field Properties
Validation Rules
Input Mask
Create Lookup Field
Review

Section 9: Finding and Joining Data
Section Overview
Inner and Outer Joins
Joining Unrelated Tables and Relating Data Within Tables
Section Review

Section 10: Creating Flexible Queries
Section Overview
Select Query Properties
Parameter Queries
Using Wild Cards
Creating Action Queries
Section Review

Section 11: Enhancing Forms
Section Overview
Using the Form Layout View and Improving Form Appearance
Restricting Data Entry
Command Buttons and Creating Subforms
Section Review

Section 12: Customizing Reports
Section Overview
Organizing Report Information and Setting Report Control Properties
Page Layout and Controlling Pagination
Summarize Info and Sub-reports
Mailing Labels
Section Review

Section 13: Sharing Access Data
Section Overview
Importing and Exporting Data
Sharing Data and Merging Data with Word
Section Review

Section 14: Structuring Existing Data
Section Overview
Analyzing Tables and Junction Tables
Improving Table Structure
Section Review

Section 15: Writing Table Queries
Section Overview
Multi Table Query
Creating Unmatched Queries
Create Duplicate Queries
Create Duplicate Queries and Grouping and Summarizing
Crosstab Query
Creating Pivot tables and Pivot Charts
Section Review

Section 16: Using Macros
Section Overview
Planning and Creating Macros
Attach Macros to Command Buttons
Restrict Records Displayed Using Where Condition
Require Data Entry with Macros
Automate Data Entry
Section Review

Section 17: Making Forms More Effective
Section Overview
Form Format Properties
Active X Controls and Tabbed Pages
Display Pivot Chart Table on Forms
Section Review

Section 18: Improving Reports
Section Overview
Include Chart In Report and Concatenating
Arranging Data In Columns, Grouping, and Parameter Reports
Report Events and Canceling a Blank Report from Printing
Section Review

Section 19: Creating a Startup Interface
Section Overview
Creating and Modifying a DB Switchboard
Setting and Modifying Startup Options
Section Review

Section 20: DataBase Maintenance
Section Overview
Database Maintenance Tools
Section Review

Section 21: Distributing and Securing a Database
Section Overview
Splitting a Database
Implementing Security and Trust center
Setting Passwords
Converting Files and Signing with Digital Signatures
Section Review
Course Review

 

 

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo