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 Student Blog 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

Learning Method

Instructor-led

Self-Paced. Study on your own schedule

Contact Us for additional information

Microsoft Access 2010 Certification Training

Contact Us

Details + Objectives

Course Code: GES831

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

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 & Support

Elizabeth Ann Nofs

Elizabeth Ann Nofs is the designer and developer of the Computer Mama series. She is the author of 44 books, including the Computer Mama Guide to Computers, the Comma Method of Computer Training, the Comma Teachers Edition, and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training. She received her Bachelor of Arts in Biology from the University of Michigan, Ann Arbor.

Requirements

Prerequisites / Requirements

Prerequisites:

Before you enroll in the Microsoft Access 2010 Certification Training course, 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 course 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 course 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 Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • 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 Materials

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

About Certification

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. 

FAQs

Expand All
Can I register for a course if I am an international student?

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

Does this course prepare for a certification?

No.

When can I start the course?

This course is open enrollment, so you can register and start the course as soon as you are ready. Access to your course can take 24-48 business hours.

How long does it take to complete this course?

This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive six (6) months to complete the course.

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

The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee may be charged.

What kind of support will I receive?

You may be assigned with an instructor or team of industry experts for one-on-one course interaction. Your support will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our instructors are successful working professionals in the fields in which they teach. You will be assigned to an Advisor for academic support.

What happens when I complete the course?

Upon successful completion of the course, you will be awarded a Certificate of Completion.

Am I guaranteed a job?

This course will provide you with the skills you need to obtain an entry-level position in most cases. Potential students should always do research on the job market in their area before registering.

Can I get financial assistance?

ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA and Pell Grant. 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. Financing is available from select schools. Learn more: https://www.ed2go.com/career/financial-assistance

How can I get more information about this course?

If you have questions that are not answered on our website, 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 any, certification exams will this course prepare me for?

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

Browse All