Vi ste ovdje
Overview/Description
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson ObjectivesCreating Basic Tables in Access 2010
recognize the correct naming convention for tables
create tables in Design view...
Overview/Description
Outlook 2010 has now adopted a Ribbon, similar to the other products in the Office suite, which provides an intuitive interface with most commands readily available. The Outlook interface is highly customizable as well. This course discusses how to modify the Ribbon to suit your preferences, as well as ways that views and panes can be customized. Configuring Exchange e-mail accounts are also discussed.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson ObjectivesCustomizing Outlook 2010 and Managing Accounts
customize the Outlook 2010...
Overview/Description
Word 2010 enables you to efficiently create attractive and organized documents using a variety of automated and pre-built features. You can quickly and easily use any of the Word 2010 styles to give your document a polished appearance, or you can create your own styles so you can use a custom appearance over and over. In addition, Word 2010 enables you to create documents using pre-built templates that are bundled with Word, saving you time and effort in choosing a layout and color scheme for your files. This course introduces Quick Styles and templates, and also explores...
Overview/Description
Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect....
Overview/Description
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson ObjectivesData Manipulation and Simple Relationships in Access 2010
modify how data is...
Overview/Description
We all know that to create an effective Word document, your text must be clear and organized, but we sometimes neglect the overall attractiveness of our documents. This course demonstrates powerful drawing and graphic features of Word 2010 - features that can boost the appeal of virtually any document! The course focuses on the processes and tools that allow you to add pictures, Clip Art, screenshots, and SmartArt to your documents. It also explores drawing components such as shapes, WordArt, and text boxes.
Target Audience
Individuals and business users with basic...
Overview/Description
Word 2010 makes it easy to apply formatting to documents by providing a live visual preview of various formatting options. This allows you to view a variety of formatting changes before actually committing to them. This course explains the Font formatting options, as well as the Mini toolbar and Live Preview features. In addition, the creation and formatting of bulleted, numbered, and multilevel lists are demonstrated.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson ObjectivesFormatting and Working with Text...
Overview/Description
The default installation of Outlook 2010 allows you to easily send and receive messages among colleagues and friends. There are, however, many options that help you make creative, more visually appealing messages, as well as options that change how messages are sent. This course discusses sending e-mail in different message formats as well as formatting options that can be applied to the text and background of an e-mail. Also covered are how to check your message's spelling and grammar, how to track outgoing messages, how to add voting buttons, and how to set importance...
Overview/Description
Word 2010 enables you to create forms quickly and easily, so that they can be used by other users of Word 2010. Forms contain editable form controls that you can link to external data sources, and Word 2010 contains security features to protect forms from tampering by other users. Another method of capturing document information is by using fields. You can use fields to add information about a file into the document. For example, you can insert an Author field to insert the author's name, or use a LastSavedBy field to enter the name of the person who last saved the...
Overview/Description
Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help...