Overview/Description Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in...

Overview/Description In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of review, security, and collaboration features are available in Excel 2007. Workbooks, worksheets, and specific data within worksheets, can be protected, enabling only those with access to view or make changes to them. Workbooks can be shared so that multiple people can access required data, and changes made to workbooks can be tracked, accepted or rejected, and merged. The use of...

Overview/Description Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying...

Overview/Description Word 2013 offers a variety of features that let you quickly add reference document elements often found in formal, published papers. This course explores endnotes, footnotes, how to build and update a table of contents, and citations, cross-references, and bibliographies. The course also delves into how to perform a mail merge manually or by following along with a step-by-step wizard. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013. Target Audience...