Microsoft Access 2010 Certification Training

OVERVIEW

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.

III. Advanced
Microsoft Access
A. You say Goodbye, and I say Hello!: Normalize a
database
B. Relating Tables in a Database: Key data
C. Primary Keys and Relationships
D. The Receipt Form, Part 1: Design the Subform
E. The Receipt Form, Part 2: Design the Form and
link the two Forms
F. The Receipt Printout, Part 1: Design the Report
G. The Receipt Print, Part 2: Design the Subreport
and link the two Reports
H. The Producers: Working with Dates
I. Prepare to Share: Visualize the results and
export the Reports
J. Strategies for Archiving: Use Action Queries
K. 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.

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.

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.

Bay de Noc Community CollegeContinuing Education and Professional Development2001 North Lincoln RoadEscanaba, MI 49829 US