Certification proves a certain level of advanced competency with the programs in question. Employers don’t have to wonder if the skills stated on the resume are honest and without exaggeration. This can lead to further employment opportunities and increased pay. This course accurately and creatively provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. This online course is supported by an instructor and is available for year-round open enrollment.
This course is also an exam study guide for the following certification test:
Exam 77-885: Microsoft Access 2010
Upon successful completion of this program, learners will be able to:
• Create and Format Item Content
• Mange E-mail Messages
• Manage Contacts
• Manage Calendar Objects
• Work with Tasks, Notes, and Journal Entries
• Manage the Outlook Environment
Students who enroll in the Complete Guide to Microsoft Access 2010 should have basic computer skills, including how to turn on the computer, how to use an Internet browser, and how to select commands from a menu or toolbar. Students should know how to save files and send attachments by email as well.
The Complete Guide to Microsoft Access 2010 is for students to improve their level and breadth of knowledge with Microsoft Access functions in preparation for taking the Microsoft Certification Exam. The course includes both recall and authentic assessments to measure student understanding at an increasingly advanced level. Students will be working hands-on with the commands and completing sample projects to reinforce learning. This course does not rely on abstract learning, but on the program in context.
Students for the certification exams 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. Amongst the skills necessary, students should be especially effective at entering information and analyzing data. Successful students will have mastered how to create and edit formulas, audit equations, insert and format visual data presentations and present information in charts and tables.
The typical candidate for the exam works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage. The Access 2010 user typically is effective in creating, modifying, and personalizing objects. This candidate is capable of working independently on database projects, and can often answer questions from others about databases. Candidates should know and demonstrate how to create or modify a simple Access database and use templates to create basic objects.
Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that I wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test results
This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
This program does not require any additional purchases of supplementary materials.