Microsoft Access 2003: Level 1

In this course, students will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools. This is one of a series of courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Access 2003: Level 2

Students will learn how to design and create a new Access database, customize database components, and share Access data with other applications. This is one of a series of courses that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Access 2003: Level 3

Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Microsoft Access 2003: Level 4

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code.

Microsoft Access 2007: Level 1

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.

Microsoft Access 2007: Level 2

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.

Microsoft Access 2007: Level 3

Your training in and use of Microsoft® Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills for 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.

Microsoft Access 2007: New Features

You have worked with Microsoft® Office Access 2003 (or earlier), and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course, you will be introduced to the new features available in Microsoft® Office Access 2007.

Microsoft Excel 2003: Level 1

In this course, students will use Microsoft® Office Excel 2003 to manage, edit, and print data. This is one of a series of courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Excel 2003: Level 2

This course teaches intermediate-level features and functions of Excel 2003. Students will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, apply special cell formatting, sort and filter lists, create combination charts and trendlines, use Excel's auditing features, and work with templates. This course is approved courseware for Microsoft Office Specialist certification.

Microsoft Excel 2003: Level 3

In this course, 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. This is one of a series of courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Excel 2007: Level 1

Students will create, edit, format and print basic worksheets and charts in Excel.

Microsoft Excel 2007: Level 2

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.

Microsoft Excel 2007: Level 3

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.

Microsoft Excel 2007: Level 4

You are a relatively proficient user of Microsoft® Office Excel® 2007, and you now wish to take advantage of the advanced features and techniques used in Microsoft® Office Excel® 2007. Excel has many tools and functions that help you in analyzing varied data to make decisions having large scale implications on profitability, be it in the domain of sales, project management, credit, equities, futures, options, currency, and so on. In this course, you will use the advanced features of Microsoft® Office Excel® 2007 to attain a high degree of proficiency as an Excel power user.

Microsoft Excel 2007: New Features

You have worked with Microsoft® Office Excel® 2003 (or earlier), and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft® Office Excel® 2007.

Microsoft Excel 2007: VBA

In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.

Microsoft Outlook 2003: Level 1

In this course, students will gain the skills needed to start sending and responding to email in Microsoft® Outlook® 2003, as well as maintaining calendars, scheduling meetings, and working with tasks and notes. This course is one of a series that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Outlook 2003: Level 2

Students will learn the necessary skills needed to customize the Outlook environment, calendars, and mail messages so that they meet specific needs. They will also learn how to track, share, assign, and quickly locate various Outlook items. This course is one of a series that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft Outlook 2007: Level 1

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.

Microsoft Outlook 2007: Level 2

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.

Microsoft PowerPoint 2003: Level 1

In this course, students will learn how to upgrade paper presentations to an electronic format by using Microsoft® Office PowerPoint® 2003. This course is one of a series that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft PowerPoint 2003: Level 2

Students will learn how to use Microsoft® Office PowerPoint® 2003 features that draw, animate, and format presentations with professional-quality content. This course is one of a series that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Microsoft PowerPoint 2007: Level 1

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.

Microsoft PowerPoint 2007: Level 2

As a 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.

Microsoft PowerPoint 2007: New Features

You have worked with Microsoft® Office PowerPoint® 2003 (or earlier) to create presentations. PowerPoint® 2007, with its redesigned interface, enhanced features, and results-oriented authoring tools, improves the process of creating dynamic presentations. In this course, you will work with the new and enhanced features available in Microsoft® Office PowerPoint® 2007.

Microsoft Word 2003: Level 1

This course will provide students with the basic concepts required to create, edit, and enhance simple documents. This is one of a series of courses that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Microsoft Word 2003: Level 2

In this course, students will increase the complexity of documents by adding components such as customized lists, tables, charts, and graphics. They will also create personalized Microsoft® Word 2003 efficiency tools. This is one of a series of courses that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Microsoft Word 2003: Level 3

In this course, students will learn how to use Word to create, manage, revise, and distribute long documents, forms, and Web pages. This is one of a series of courses that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Microsoft Word 2007: Level 1

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.

Microsoft Word 2007: Level 2

In the first course in this series, Microsoft® 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.

Microsoft Word 2007: New Features

In the past, you have extensively used Microsoft® Office Word 2003 to author and format content and graphics within documents. Word 2007 with its new features, user-friendly formatting, design, and authoring tools, improves the process of document creation and distribution. In this course, you will be introduced to the new and enhanced features available in Microsoft Office Word 2007.

Crystal Reports XI Level 1

In this course, students will build basic list and group reports that work with almost any database.