Vi ste ovdje
Overview/Description
You can use Microsoft Access 2010 to manage your data efficiently using advanced techniques. There are many methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates advanced techniques for retrieving and validating data in Access 2010. These include such features as lookup fields and using the Expression Builder to aid in the validation of controls. How to attach files to tables and forms, and edit them, is also demonstrated.
Target Audience
A broad range of...
Overview/Description
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Target Audience
Individuals and business users...
Overview/Description
No one wants to be embarrassed by glaring grammatical mistakes and misspellings in a document. To help you catch these errors, Word 2010 includes editing tools that enable you to spot and fix your typos as you work. It also enables you to use other proofing features such as a thesaurus, research options, and word count statistics to help you proof your work. In addition, you can make changes while reviewing your work using a feature that tracks all of your edits, and you can also leave comments during your review. This course explores all of these proofing features, from...
Overview/Description
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options â saving, printing, and sharing â are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and...
Overview/Description
Once you've created an attractive, well-structured document, how do you save it for future use? Word 2010 enables you to save your documents in many formats, including the standard .docx file extension, along with the well-recognized .doc extension. You can also save your documents as PDF or XPS files to make them uneditable and give them standardized appearances for sharing. In addition, you can choose to save and send your document using e-mail, Microsoft SkyDrive, upload your document as a blog post, or save it on SharePoint. If you want to print your document, you can...
Overview/Description
Microsoft SharePoint Server 2010 contains a number of new features and enhancements specifically geared at improving the end user experience. These include enhanced remote file-editing capabilities using Web Apps and mobile devices, improvements to team sites, and enhancements in social computing. This course explores the SharePoint Server 2010 interface, including the introduction of the Ribbon, already available in Office, as well as changes to team sites and common interface elements. In addition, this course examines enhancements in social computing via My Sites,...
Overview/Description
Microsoft SharePoint 2010 provides several security options for ensuring that only users or groups who should be able to access specific contents can do so. Security can be configured at the item level, and can be managed for individual users or groups. This course examines SharePoint securing, and describes managing SharePoint groups, changing the inheritance for a site, managing permission levels, and configuring item-level security. It also discusses the concept of sandbox solutions. SharePoint Business Intelligence solutions allow you to collect, store, and analyze...
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in...
Overview/Description
Word 2010 provides many options for structuring your documents quickly and easily. This course demonstrates how to use headings to restructure the outline of a document using the Navigation Pane. If you're creating large documents with many pages, you might want to add page numbers to make your information easy to locate. The course explores how to add page numbers along with other structural components, such as page and sections breaks, headers, and footers.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson...
Overview/Description
Subforms and subreports allow you to display related data from separate sources in a single interface in Access 2010. This course will demonstrate how to use Access 2010 to create and use subforms and subreports. It also explores how to apply conditional formatting to tables, forms, and reports using the streamlined conditional Formatting Rules Manager.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson ObjectivesSubforms, Subreports, and Conditional Formatting in Access 2010
create subforms
set the default view of a subform
create...