Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Computer Applications Microsoft Microsoft Access 2010 Certification Training
Return to Microsoft
microsoft-office-access-2010

Microsoft Access 2010 Certification Training

The primary instruction in the Microsoft Access 2010 course is related to business applications of Access, as Microsoft Office is used in almost all workplaces. Nearly every business finds a use for Microsoft Office programs, including inner-office memos composed on Microsoft Word, sales presentations created with Microsoft PowerPoint, and budget spreadsheets compiled in Microsoft Excel. Teachers frequently use Microsoft Office for both teaching preparation and record-keeping as well as in student assignments. Home users may find many uses for Microsoft Office, similar to those used in the workplace. Microsoft Office is a product with great possibilities, and this course aims to familiarize you to such possibilities.

Students for the Microsoft Access 2010 certification tests should have the equivalent of six months of hands-on computer experience before taking the exam. These exam candidates should be proficient at file management. In addition, students should be able to readily identify and use the commands for at least 80% of the exam objectives in preparation for taking the timed exam.

6 Months / 120 Course Hrs
Open Enrollment

Offered in Partnership with your Preferred School

Association of Executive and Administrative Professionals Why this school? It's been chosen based on your location or if you've visited this school's website.

Financial Assistance Available*

Change School

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

Microsoft Access 2010 Certification Training

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

Microsoft Access 2010 Certification Training Details + Objective

Course Code: GES831

You Will Learn
  • Create and manage databases
  • Create tables, add fields and specify the data type
  • Create forms with a Wizard, Quick Parts, and in design view
  • Create forms for data entry as well as list view
  • Use queries to combine fields, group, sort, and total
  • Create reports and format the content, header, footer, and layout
  • Manage and maintain an Access database
  • Create a strategy for archiving data with action queries
How the course is taught
  • Self-paced, online course
  • 6 months to complete
  • Open enrollment, begin anytime
  • 120 course hours
How you will benefit
  • Become prepared to take certification Exam 77-885: MOS: Microsoft Office Access 2010
  • Become more efficient at your job as you learn to better manage databases and related information
  • Gain hands-on training using Microsoft Access that you can list on your resume
Microsoft Access 2010 Certification Training Outline
Expand All
Beginning Microsoft Access

Receive an introduction to tables. Learn how to design tables, add fields, change layouts, and edit form properties.

Beginning Microsoft Access (Continued)

Learn how to design queries, use criteria and parameters, use design view, and save works in progress.

Intermediate Microsoft Access

Cover one-to-many relationships, create a combo box, and use forms and subforms to represent one-to-many relationships.

Intermediate Microsoft Access (Continued)

Understand how to create the search form, link to forms and subforms, manage the database environment, create a switchboard form, test your software, and use a query to calculate the total.

Advanced Microsoft Access

Receive instruction regarding normalizing databases, how to process key data in tables, and how to evaluate primary keys and relationships.

Advanced Microsoft Access (Continued)

Complete the course by learning how to design and link two forms. You’ll also understand how to design a report, design a subreport, work with dates, visualize and export data results. Finally, you’ll learn how to use action queries and optimize Access for multiple users.

View All Sections
Microsoft Access 2010 Certification Training Instructors
Elizabeth Ann Nofs 

Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan. She’s the author of 44 books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005) and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training. Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.

Microsoft Access 2010 Certification Training Requirements / Prerequisites

Before you enroll in the Microsoft Access 2010 Certification Training program, you should have strong computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up your files. You should also be proficient in Microsoft Excel. This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program will also suit you if you want to learn about this software and expand your job possibilities.

This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office 2010 Products already installed: Access, Word, and Excel. It is recommended that you use the latest version of Internet Explorer in place of other Web browsers. Adobe Flash Player and Adobe Acrobat Reader are required for this program.

Click Here to download the Acrobat Reader.

Click Here to download the Flash Player.

All materials for this program are available online.

The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft Access 2010
  • Intermediate Guide to Microsoft Access 2010
  • Advanced Guide to Microsoft Access 2010
Microsoft Access 2010 Certification Training Frequently Asked Questions
Expand All
Can I use a Mac?

No, you must access this program from a PC or IBM-compatible computer.

Can I get financial assistance?

ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses.

What happens when I complete the program?

Upon successful completion of the program, you will be awarded a certificate of completion from the school you registered with.

Can I register for programs if I am an international student?

Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.

Do I have to buy additional materials?

You must have the Microsoft Access 2010 already installed on your computer before taking this program. This course cannot be completed with the Microsoft Access 2007 or 2003 software programs. Otherwise, all the materials you need are included, and their cost will be covered in your tuition.

Do I have to buy additional materials?

You must have the Microsoft Access 2010 already installed on your computer before taking this program. This course cannot be completed with the Microsoft Access 2007 or 2003 software programs. Otherwise, all the materials you need are included, and their cost will be covered in your tuition.

What, if any, certification exams will this program prepare me for?

This program teaches the exam objectives for Exam 77-885: MOS: Microsoft Office Access 2010. However, this is an elective exam and is not required for the MOS Certification.

Who will be my instructor?

Each student is paired up with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

When can I start the program?

Our programs are all open enrollment. You can register and start the program as soon as you are ready. Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

How long does it take to complete a program?

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. Most programs allow you 180 days after your register to complete them.

Am I guaranteed a job?

ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don't provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

How can I get more information about the program?

If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button toward the top of the page). If you are visiting us during non-business hours, please feel free to send us a question using the "Contact Us" form to the right. You may also call us at (855) 534-3690. We will answer your questions promptly.

What if I don't have enough time to complete my program within the time frame provided?

The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee will be charged for an extension.

What software or hardware do I need in order to take online programs and what are the system requirements?

In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don't have to use the same computer to log-in to the program every time. We recommend that you have a word-processing program (Microsoft Word is best) and the latest version of Internet Explorer.

Browse All
Talk to an admissions counselor
Got other questions? Get in touch with our admissions counselors via . During non-business hours, please feel free to send us a question using the "Contact Us" button. You can also reach us by phone at (855) 520-6806.