Office Productivity Curriculum

|Microsoft |Crystal Reports |

Microsoft Access 2002: Level 1

This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.

Microsoft Access 2002: Level 2

This course is a hands-on instruction book that will introduce students the skills needed for creating, revising, and customizing the design of tables, queries, forms, reports, and data access pages. This course is also for those pursuing core-level Microsoft Office User Specialist (MOUS) certification in Access 2002.

Microsoft Access 2002: Level 3

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.

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 Excel 2002: Level 1

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

Microsoft Excel 2002: Level 2

Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

Microsoft Excel 2002: Level 3

Students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects.

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 Outlook 2002: Level 1

In this course, you will learn the basics of using Microsoft Outlook 2002 as a communications tool. You will send and receive mail messages, use a calendar to schedule appointments, and coordinate business meetings with multiple participants. You will also keep track of personal and business contacts, and create task lists and notes to remind you of things that need to be done.

Microsoft Outlook 2002: Level 2

Students will use more advanced Microsoft Outlook 2002 features for communication and organization. Topics covered include customizing your messages, organizing your mailbox, coordinating schedules, saving and archiving mail, and sharing Outlook data. The course is suitable for persons preparing to be certified Microsoft Office User Specialist (MOUS) in Outlook.

Microsoft Outlook 2002: Level 3

Students enrolling in this course will learn additional Outlook skills including importing data, performing a mail merge, using Instant Messenger from Outlook, accessing a newsgroup, using the Journal, configuring and securing Outlook, using the Internet with Outlook, working offline or remotely, and creating custom forms.

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 Powerpoint 2002 XP: Level 1

Welcome to the world of computerized desktop presentation. Microsoft PowerPoint 2002 is a feature-rich, easy-to-use program that enables you to create presentation slides that combine text, clip art, drawings, tables, and charts and graphs. In this course, you'll learn how to create, modify, and run a basic PowerPoint presentation. PowerPoint is one of the easiest and most powerful presentation programs available. If you take the time to learn how to use some of PowerPoint's basic tools, you will quickly be able to create a presentation that works. And, as you learn more about PowerPoint, you will learn to create presentations that wow your audience.

Microsoft Powerpoint 2002 XP: Level 2

This course is designed for students who are already familiar with PowerPoint on an introductory level and those who need to design templates, create slides with special effects, run various slide shows, create presentations for the Web, and broadcast and review presentations in their job.

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 Project 2003

This two-day course is designed for individuals who will use Microsoft Project 2003 as a tool to assist them in managing projects. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments. Students will then build upon these skills and work with a project plan once it has entered the project implementation phase.

Microsoft Publisher 2000: Level 1

Students will learn to use Microsoft Publisher to create a multiple-page document.

Microsoft Word 2002: Level 1

Students enrolling in this course will learn the basics for creating and revising business documents using Word 2002. Topics covered include creating a document, editing text, formatting text, adding tables, using Word timesavers, and displaying and printing options. It is also intended for persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Word.

Microsoft Word 2002: Level 2

Students enrolling in this course will learn intermediate Word 2002 skills including how to create templates, manage table data, create a newsletter, send form letters, create a Web page, and manage document changes. It is also intended for persons desiring to prepare to be certified Microsoft Office User Specialist (MOUS) in Word.

Microsoft Word 2002: Level 3

You know how to use Microsoft Word to create and format documents and newsletters. In this course, you'll learn how to use Word to create forms and long documents as well as how to make it easier to display and work with those forms and long documents by using macros and colloborating.

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.

Crystal Reports XI Level 1

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