Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Audience Profile
Candidates for this exam typically work in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. Candidates should have experience with the following:
  • Writing transact SQL queries
  • Programming the database
  • Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
  • Database performance tuning and optimization
  • Designing databases at both the conceptual and logical levels
  • Implementing databases at the physical level
  • Might be involved in designing and troubleshooting the data access layer of the application
  • Gathering business requirements
Credit Toward CertificationExam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008: counts as credit toward the following certification(s):

Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.


Повеќе информации за курсот можете да најдете на следниот линк.


Microsoft SQL Server 2008, Database Development

Audience Profile
Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:
  • IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution
  • IT professionals who manage systems that run SQL Server 2008 R2
  • Developers who build applications that use SQL Server 2008 R2
  • IT professionals who work with third-party applications that are built on SQL Server 2008 R2
Credit Toward CertificationWhen you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification(s):

Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.


Повеќе информации за курсот можете да најдете на следниот линк.

MOS: Microsoft Office OneNote 2010

Audience Profile
The audience profile for the OneNote Exam is a student, office worker or instructor who needs to navigate the Office software at the feature and functionality level.
These users use OneNote as a digital notebook to facilitate their work and use it to integrate with other Microsoft 2010 Office applications. They have the ability to use it for project management, organizing research, collaboration, and to access information from multiple locations. They have the skills and knowledge to effectively problem solve many issues that arise. They effectively use many of the common features and functions to organize and display digital information.

The core OneNote 2010 user typically:
    • is accustomed to making decisions about his or her own work
    • is a competent user of Microsoft 2010 Office applications
    • knows how to leverage his or her work for multiple purposes
    • knows how to use the major features and functions of OneNote to enhance project and task management
    • understands how to collaborate via OneNote
Credit Toward CertificationWhen you pass Exam 77-853: OneNote 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): OneNote 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office 365

Audience Profile
This exam validates the skills students, office workers or instructors need to navigate Office 365 at the feature and functionality level. The Office 365 User should be able to navigate Office 365 software at the feature and functionality level, including: Outlook Web App (OWA), Lync collaboration functionality, SharePoint online, and Office web apps.

They should be familiar with and know how to use at least 80% of the features and capabilities of Office 365, including but not limited to: Simultaneously edit documents with colleagues, Conduct online meetings with colleagues, partners, and customers, including audio, video, and screen sharing; Share calendar with colleagues, partners, and customers; and Manage and share documents, task lists, and schedules to keep workgroups in sync using My Sites and TeamSites.
Credit Toward CertificationWhen you pass Exam 77-891: Office 365, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Office 365
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft SharePoint 2010

Audience Profile
Candidates for this exam are users who provide structure for information, extend out-of-the-box site features, solve business problems through composite applications, and facilitate collaboration with other site users.

Users perform all site user tasks. They optimize Web Part pages for team use by adding and configuring Web Parts from the Web Part gallery. They customize dashboards to target the information presented. Users focus on adapting SharePoint sites to their teams’ needs and improving productivity.
Credit Toward CertificationWhen you pass Exam 77-886: SharePoint 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): SharePoint 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Access 2010

Preparing for an Exam
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.
 
 
Credit Toward CertificationWhen you pass Exam 77-885: Access 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Access 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office PowerPoint 2010

Preparing for an Exam
The typical candidate for the exam is a student, office worker, or instructor who needs to navigate PowerPoint 2010 at the feature and functionality level.
Exam Topics Covered
Users create complex slide shows, such as product plans, reports, and marketing materials. They create slide shows based on custom templates generated by others and frequently reuse slides. Their slides include sophisticated data presented in visual formats.  These users know how to pause and move back and forth in slide shows, jump to specific slides, drill down to supporting data, and mark up slides.
 
Credit Toward CertificationWhen you pass Exam 77-883: PowerPoint 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): PowerPoint 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Outlook 2010

Preparing for an Exam
The typical candidate for the exam is a student, office worker, or instructor who is able to navigate Outlook 2010 at the feature and functionality level.
Exam Topics Covered
Users can format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, and appointments from incoming messages. They create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users.
 
Credit Toward CertificationWhen you pass Exam 77-884: Outlook 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Outlook 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Excel 2010 Expert

Preparing for an Exam
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam.Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration,preparationscoring, and policies, including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
 
Audience Profile
Candidates for this exam should have Expert-level Microsoft Office Excel 2010 users are able to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Expert users are proficient with advanced formulas, functions, and data analysis tools. Expert users can manipulate data for analysis, presentation, and collaboration. In addition, expert users can manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.
Credit Toward CertificationWhen you pass Exam 77-888: Excel 2010 Expert, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Excel 2010 Expert
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Word 2010 Expert

Preparing for an Exam
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam.Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration,preparationscoring, and policies, including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
 
Audience Profile
Expert-level Microsoft Office Word 2010 users are able to proficiently and confidently use Word 2010 software at the feature and functionality levels.  Expert users work with the advanced features of Word 2010 to enhance professional documents, create documents ready for publication, and collaborate effectively on group editing projects. Expert users manipulate Word options to customize their environment to meet varying needs and enhance their productivity.
Credit Toward CertificationWhen you pass Exam 77-887: Word 2010 Expert, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Word 2010 Expert
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.