Microsoft Access 2010 Certification Training

Participate in the Microsoft Access 2010 online course to improve your level of knowledge with Microsoft Access functions, while you prepare to take the Microsoft Certification Exam. The book, The Complete Guide to Microsoft Access 2010 ebook includes both recall and authentic assessments to measure your understanding at an increasingly advanced level. You will work hands-on with the commands, as you complete sample projects to reinforce your learning. This course does not rely on abstract learning but on the program in context.

Objective

By completing the Microsoft Outlook Online Training Program, you will be able to do the following:

  • 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

This program teaches the exam objectives for the following optional certification test, which is not required for MOS Certification:

  • Exam 77-885: MOS: Microsoft Office Access 2010.

Details

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.

Upon registering, you're given six months to complete this program.

  • Registration + Fees

    Begins: Open enrollment | REGISTER

    Course: OMAX800.01

    Tuition: $945

  • Outline

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

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

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

     

  • Requirements

    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

    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.

  • Instructor

    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.

  • FAQs

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

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

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

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

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

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

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

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

    9. Can I use a Mac?

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

    10. 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 1-855-520-6806. We will answer your questions promptly.

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

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

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