Microsoft Applications

You will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.

You will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.

You will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports.

Manage database objects, create macros and graphics reports, understand modules, and maintain a database.

Create complex queries, forms, and reports; share Access information with other programs; and add objects to a form.

Design, create, edit, and analyze databases using Microsoft Access.

This course is designed for the experienced Access user to learn the basics of VBA programming and to write procedures using the VBA language.

You will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will also learn how to work with PivotTables and PivotCharts, import and export data, query external databases, and run and record macros.

You will learn how to use multiple worksheets and workbooks efficiently, and start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. You will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file.

You will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. Finally, you will create and modify charts, and learn how to manage large workbooks.

You will create procedures that run in response to specific events, work with control structures, develop user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Perform "what if" analysis, create pivot tables, exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel.

Manage workbooks, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet.

Work with spreadsheets, including charts, formulas, and functions.

You will learn how to customize Outlook and work with address books, search and filter mail folders, and apply and customize categories. You will also work with personal, public, and offline folders and organize folders and set rules.

You will create e-mail accounts and send e-mail messages using several techniques. you will also learn how to manage e-mail messages, contacts, tasks, and meeting requests. Finally, you will customize Outlook for maximum efficiency.

Create and send e-mail and attachments; manage contacts, tasks, appointments, events, and meetings; organize folders; and use signatures.

You will customize PowerPoint by modifying the Quick Access Toolbar and creating macros, apply themes and templates, and work with SmartArt graphics and tables. You will add multimedia content and interactive elements to slides, learn about presentation distribution options including PDF and HTML. Finally, you will integrate PowerPoint with Word and Excel.

You will create new presentations that include text, graphics, WordArt, tables, charts, and diagrams. you will also edit and format slide content, and apply transition effects.

Enhance charts, work with objects and hyperlinks, and use slide show features.

Create and modify a presentation, enhance a presentation with pictures and charts, and customize a presentation with slide masters.

In this course you will learn how to create a new project file, create and modify task lists, create a Work Breakdown Structure, and work with task relationships. You'll also learn how to create a base calendar, assign resources to tasks, create task calendars, and create and modify tables. You will use filters and groups, and they'll sort task and resource data. Finally, you will learn how to resolve resource conflicts. (Textbook Included)

Track project work, save a baseline plan, update progress of tasks, work with the Earned Value Table, view task progress, and analyze and adjust project schedules.

Schedule tasks, manage resources, work with task views, finalize the task plan, filter, group and sort.

In this course you will learn the core features and functions of Publisher 2007. You will learn how to create and edit publications, arrange text and pictures, work with master pages, and create and format tables. You will also learn how to flow text across text boxes, create a facing-pages layout, export publications to PDF, and prepare publications for commercial printing. (Textbook Included)

In this popular publishing software program created for home and business use, you will learn how to create a publication, adjust its page setup, enter and edit text, insert pictures, and create and modify text frames. You will also learn how to work with multipage publications, objects, graphics, and tables, as well as how to print publications.

This course teaches the core features and functions of SharePoint Designer 2007. You will learn how to create and apply templates, control layout and spacing, create and apply style sheets, and apply IDs and classes. You will also insert, modify, and arrange images, create links and navigation bars, and insert and format tables. Finally, you will learn how to prepare a Web site for publishing. (Textbook Included)

In this course you will learn how to use stencils, scale and resize objects, draw basic shapes, manipulate compound lines, and distribute and group objects. You will also learn how to create diagrams, work with text, format shapes and lines, and apply a background page. (Textbook Included)

Use drawing tools, create basic diagrams, format drawings and network diagrams, customize properties and use reporting functions.

You will work with styles, sections, and columns. you will format tables, print labels and envelopes, and work with graphics. You will also use document templates, manage document revisions, and work with web features.

You will learn how to enter and edit text, and save and browse documents. You will learn how to enhance the appearance of a document by using various formatting options. Finally, you will create tables, insert headers and footers, proof and print documents, and insert graphics.

Work with styles and graphics, merge documents, share Word document information with other programs, and use Word to create a web site.

Design, create, edit, and enhance documents.