Microsoft Outlook	Microsoft OneNote	Microsoft Publisher	Microsoft InfoPath
Microsoft PowerPoint	Microsoft Word	Microsoft Excel	Microsoft Access

Microsoft® Office Word 2007: Level 1

Program Description: Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word 2007 courses. It will provide you with the basic concepts required to produce basic business documents. Course Objective: You will create, edit, and enhance standard business documents using Microsoft® Office Word 2007.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Create a basic document using Microsoft Word.
• Edit documents by locating and modifying text.
• Format text.
• Format paragraphs.
• Add tables to a document.
• Add graphic elements to a document.
• Control a document's page setup and its overall appearance.
• Proof documents to make them more accurate. 

Microsoft® Office Word 2007: Level 2 

Program Description: In the first course in this series, Microsoft® Office Word 2007: Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft Word 2007 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft Word 2007 works for you. You can also improve the quality of your work by enhancing your documents with customized Microsoft Word 2007 elements. In this course, you will create complex documents in Microsoft Word 2007 by adding components such as, customized lists, tables, charts, and graphics. You will also create personalized Microsoft Word 2007 efficiency tools.  Course Objective: You will create complex documents in Microsoft® Office Word 2007 documents and build personalized efficiency tools in Microsoft Word 2007.

Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft Word 2007, and who need to learn how to use Microsoft Word 2007 to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft Word 2007.

Microsoft® Office Word 2007: Level 3

Program Description: You know to use Microsoft® Office Word 2007 to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise, and distribute long documents and forms.  Course Objective: You will create, manage, revise, and distribute long documents.
Target Student: This course is designed for persons who want to gain skills necessary to manage long documents, collaborate with others, and secure documents. In addition, it will be helpful for persons preparing for the Microsoft Certified Application Specialist exams for Microsoft® Office Word 2007.

Prerequisites: Students should be able to use Microsoft® Office Word 2007 to create, edit, format, save, and print business documents that contain text, tables, and graphics. Students should also be able to use a web browser and an email program. A basic understanding of XML would also be helpful. In order to understand how Word interacts with other applications in the Microsoft Office System, students should have a basic understanding of how worksheets and presentations work. To ensure success, you need to first take the following Element K courses or have equivalent knowledge:
Microsoft® Office Word 2007: Level 1
Microsoft® Office Word 2007: Level 2
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Use Microsoft Office Word 2007 with other programs.
• Collaborate on documents.
• Manage document versions.
• Add reference marks and notes.
• Make long documents easier to use.
• Secure a document.
• Manage lists.
• Customize tables and charts.
• Customize formatting with styles and themes.
• Modify pictures in a document.
• Create customized graphic elements.
• Insert content using quick parts.
• Control text flow.
• Use templates to automate document creation.
• Perform mail merges.
• Use macros to automate common tasks.

Microsoft® Office Excel® 2007: Level 1

Program Description:  You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.  Course Objective: You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbook contents.
• Manage large workbooks.

Microsoft® Office Excel® 2007: Level 2 

Program Description: In Microsoft® Office Excel® 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.  Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Calculate with advanced formulas.
• Organize worksheet and table data using various techniques.
• Create and modify charts.
• Analyze data using pivot tables and pivot charts.
• Insert graphic objects.
• Customize and enhance workbooks and the Microsoft® Office Excel® environment.

Microsoft® Office Excel® 2007: Level 3 

Program Description: Your training in and use of Microsoft® Office Excel® 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.  Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Increase productivity and improve efficiency by streamlining your workflow.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Use Excel with the web.
• Structure workbooks with XML.

Microsoft® Office Access™ 2007: Level 1 

Program Description: Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.  Course Objective: You will create and modify new databases and their various objects.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
• Design a simple database.
• Build a new database with related tables.
• Manage data in a table.
• Query a database using different methods.
• Design forms.
• Generate reports.

Microsoft® Office Access™ 2007: Level 2 

Program Description: You have the basic skills needed to work with Microsoft® Office Access™ 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Modify the design and field properties of a table to streamline data entry and maintain data integrity.
• Retrieve data from tables using joins.
• Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
• Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
• Customize reports to organize the displayed information and produce specific print layouts.
• Share data across different applications.

Microsoft® Office Access™ 2007: Level 3 

Program Description: Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. Course Objective: You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance.   

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• Write advanced queries to analyze and summarize data.
• Create and revise Microsoft® Office Access™ 2007 macros.
• Display data more effectively in a form.
• Customize reports by using various Microsoft® Office Access™ 2007 features, making them more effective.
• Maintain your database using tools provided by Microsoft® Office Access™ 2007.

Microsoft® Office Access™ 2007: Level 4

Program Description: In previous levels, you were introduced to the various features of Microsoft® Office Access™ 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.  Course Objective: You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Performance-Based Objectives

• Upon successful completion of this course, students will be able to:
• Share Access data with other applications.
• Use VBA to automate a business process.
• Create and modify a database switchboard, and set the startup options.
• Secure databases.
• Share databases using a SharePoint site.

Microsoft® Office PowerPoint® 2007: Level 1 

Program Description: In today's work environment, presentations have moved far beyond flip charts and overhead projectors. Audiences not only expect that your presentations are in an electronic format, but they also demand that your presentations be unique and sophisticated in their use of such formats. In this course, you will work with Microsoft® Office PowerPoint® 2007 to create electronic presentations. Course Objective: You will explore the PowerPoint environment and create a new presentation. You will format text on slides to enhance clarity. In order to enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Get started with PowerPoint.
• Create a presentation.
• Format text on slides.
• Add graphical objects to a presentation.
• Modify objects on slides.
• Add tables to a presentation.
• Add charts to a presentation.
• Prepare to deliver a presentation.

Microsoft® Office PowerPoint® 2007: Level 2  

Program Description: As a Microsoft® Office PowerPoint® 2007 user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication.  Course Objective: You will enhance your presentation with features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use the new and enhanced features to create dynamic and visually appealing presentations. You will then finalize a presentation and secure it to authenticate its validity.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Customize the PowerPoint environment.
• Customize a design template.
• Add diagrams to your presentation.
• Add special effects to a PowerPoint presentation.
• Use the various options to customize slide shows.
• Use PowerPoint to collaborate on a presentation.
• Finalize a presentation.

Microsoft® Office Outlook® 2007: Level 1

Program Description: This course is the first in a series of three Microsoft® Office Outlook® 2007 courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Office Outlook® 2007, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes. In this course, you will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.  Course Objective: You will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.  

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Identify the components of the Outlook environment. You will also perform simple tasks such as sending and responding to email messages.
• Compose messages.
• Use folders to organize messages.
• Manage contacts and contact information.
• Schedule appointments.
• Schedule meetings.
• Manage tasks and notes.

Microsoft® Office Outlook® 2007: Level 2

Program Description: If you have been using Microsoft® Office Outlook® 2007 as a communications tool, then you know how to send a mail message; schedule appointments and meetings; and create contacts, tasks, and notes. This course is the second in a series of three Microsoft Office Outlook 2007 courses. In this course, you will customize your Outlook environment, Calendar, mail, folders, and also track, share, assign, and quickly locate various Outlook items.  Course Objective: You will customize your environment, Calendar, and mail messages to meet your specific needs as well as track, share, assign, and quickly locate various Outlook items.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Customize the Calendar by setting various Calendar options.
• Customize message options.
• Track work activities using the Journal.
• Assign and track tasks.
• Share folder information.
• Customize the Outlook environment.
• Locate Outlook items.
• Work with public folders.

Microsoft® Office Outlook® 2007: Level 3

Program Description: This course is the third in a series of Microsoft® Office Outlook® 2007 courses. It builds on the email and calendaring skills you have already obtained and will provide you with the skills needed to personalize email, organize Outlook items, manage Outlook data files, share and link contacts, save and archive email, create forms, and work offline and remotely.  Course Objective: You will work with the advanced features of Outlook.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• Personalize your email.
• Organize Outlook items.
• Manage Outlook data files.
• Work with contacts.
• Save and archive email messages.
• Create a custom form.
• Work offline and remotely