Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design 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 Autodesk Microsoft QuickBooks Windows 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 Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map How It Works How It Works About ed2go Externship Programs Financial Assistance Corporate Training Find a School Military

CONTACT US

(855) 520-6806

See all results for ""

See All Courses

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. Change School

Finance Options Available*

Learning Method

Instructor-led Self-Paced: Study on your own schedule.

Contact Us

Microsoft Access 2010 Certification Training

Learning Method

Instructor-led Self-Paced: Study on your own schedule.

Contact Us

Details + Objectives

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
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.

Program Details
  1. Beginning Microsoft Access
    1. Getting Started: How to use the online course
    2. Hello, Access: Introduction to Tables
    3. Tables and Table Design: Adding Fields
    4. Table and More Tables: Design View
    5. Forms and Form Design: Layout View
    6. Designing for Real Users: Edit the Form Properties
    7. Queries and Query Design: Ask questions
    8. More Queries: Use Criteria and Parameters
    9. Reports and Report Design: Layout View
    10. Reports and More Reports: Use Design View
    11. Managing Databases: Save and Save As
  2. Intermediate Microsoft Access
    1. Hello, Again, Hello: Introduction to one-to-many relationships
    2. One-From-Many Relationships: Create a Combo Box
    3. Forms and Subforms, Part 1: Representing one-to-many
    4. Forms and Subforms, Part 2: Creating the Search Form
    5. Forms and Subforms, Part 3: Link the Form and Subform
    6. Meet the Stars: Create a Switchboard Form
    7. The Opening Scene: Manage the database environment
    8. Dress Rehearsal: How to TEST your software
    9. Report Totals: Use a Query to calculate the Tota
    10. Report Design Options: Use Design View
  3. Advanced Microsoft Access
    1. You say Goodbye, and I say Hello!: Normalize a database
    2. Relating Tables in a Database: Key data
    3. Primary Keys and Relationships
    4. The Receipt Form, Part 1: Design the Subform
    5. The Receipt Form, Part 2: Design the Form and link the two Forms
    6. The Receipt Printout, Part 1: Design the Report
    7. The Receipt Print, Part 2: Design the Subreport and link the two Reports
    8. The Producers: Working with Dates
    9. Prepare to Share: Visualize the results and export the Reports
    10. Strategies for Archiving: Use Action Queries
    11. The Performance Network: Optimize for Multi-Users
View All Sections
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.

Prerequisites / 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.

Requirements:

Hardware Requirements: 

  • This course must be taken on a PC. A Mac is not compatible.

Software Requirements: 

  • Windows XP or later.
  • Browser: The latest version of Internet Explorer, Firefox, Chrome, or Safari (We recommend Firefox or Chrome).
  • Microsoft Access 2010 or newer.
  • Microsoft Word.
  • Microsoft Excel.
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software is not included in the cost of tuition. All software must be installed and fully operational before the course begins.

Other: Email capabilities and access to a personal email account.

Instructional material requirements: 

  • The instructional materials required for this course are included in enrollment.
  • 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

Certified By

Microsoft

Microsoft is a global leader in software development and technology solutions. Microsoft programs such as Excel, Word, Outlook, and PowerPoint are used both at home and at work. Microsoft provides certifications in these programs that range from beginner to expert level, helping professionals realize their full potential. Whether you want to learn a single program or the entire Office Suite, completing a Microsoft-certified course is the first step. 

Frequently Asked Questions
Expand All
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. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.

What happens when I complete the program?
Upon successful completion of the program, you will be awarded a certificate of completion.
Can I register for programs if I am an international student?

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

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 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?

This program is 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?
This program is self-paced and open enrollment, so you can start and finish at your own pace. Upon registering, you're given six (6) months to complete this program.
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 this program?

If you have additional questions, please feel free to contact us via LIVE CHAT or by calling us at (855) 520-6806. If you are visiting us during non-business hours, please feel free to send us a question using the Contact Us form.

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 course hours. If after a concerted effort, you are still unable to complete your program on time, your Student Advisor will help you work out a suitable completion date. Please note that a fee may be charged for an extension.

Browse All