This course introduces students to some of the new features of the Office XP suite. It covers the major new features that apply to all of the applications, including smart tags and Task Panes; as well as a few of the individual new features of Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Access and Microsoft Outlook. All skills will be taught using true-to-life scenarios, examples, review exercises and concept graphics to help reinforce material presented. This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective database should be designed and set up. After they learn how to create their own databases in Access, students will receive instruction in how to create and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data. This course will also cover the new features in Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane. The material is presented through explanatory text, real-world scenarios, and interactive steps. This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, and forms, reports, and data access pages. The course also shows how to work with individual fields to ensure that overall database structure is consistent and correct. In addition, students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, and forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various maintenance features are covered; teaching students ways to better manage multi-user databases. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered. This course introduces students to basic spreadsheet features and acquaints students with Microsoft Excel 2002 tools by using real-life scenarios and projects. Students will learn to manage workbooks, work with cells and cell data, format and print worksheets, create and revise formulas and create charts from worksheet data. Students will also become familiar with Excel's introductory-level new features, such as smart tags and speech recognition. This course introduces students to an additional set of basic spreadsheet features and acquaints students with the tools used in Microsoft Excel 2002. Students will learn to customize workbooks by changing worksheet attributes, use lists to store and organize worksheet data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles. In addition, students will learn about objects and their role in worksheet development, 3-D references linking worksheets and workbooks, how to integrate workbooks and the Web, and how to use templates to create new worksheets. This course teaches students a set of expert-level spreadsheet features. Students will learn about summarizing list data with outlining and subtotals, and they will learn how to create and remove custom filters; techniques for working with shared workbooks, including protecting workbooks from changes; track and review changes; and merge and consolidate data from worksheets. Finally, students will learn how to customize the Excel working screen with custom toolbars, menus and macros. The material is presented through explanatory text, real-world scenarios, interactive steps and questions to test and reinforce the material covered. This course is designed to familiarize users with key introductory features of Microsoft FrontPage, as well as introduce them to some of its new capabilities introduced with the 2002 version. Students will learn the tricks that will help them create, edit and manage Web pages easily. The skills taught include examining the working screen; getting familiar with the new Task Panes; creating new Webs; entering, modifying and formatting text; incorporating graphics; applying themes; managing Webs; and previewing and publishing Webs. All of these functionalities will be taught using true-to-life scenarios, examples, review exercises and concept graphics to help reinforce material presented. This course is designed to familiarize users with key introductory features of Microsoft FrontPage, as well as introduce them to some of its new capabilities introduced with the 2002 version. Students will learn the tricks that will help them create, edit and manage Web pages easily. The skills include examining the working screen; becoming familiar with the new Task Panes; creating new Webs; entering, modifying and formatting text; incorporating graphics; applying themes; managing Webs; and previewing and publishing Webs. All of these functionalities will be taught using true-to-life scenarios, examples, review exercises and concept graphics to help reinforce material presented. This advanced course strives to broaden and develop the basic Web design skills that students already possess. Students will gain a more complete understanding of how to effectively create Webs, as well as discover some new capabilities introduced with the 2002 version. Because there are so many tools that Microsoft FrontPage has to offer in the world of Web design and management, this level 2 course will touch on a few of the more advanced, but necessary tools. The skills we cover include structuring Webs; organizing and customizing pages; designing framesets; creating and modifying tables within a Web; working with forms; integrating Microsoft Access with databases in a Web; managing Web site security; working with reports; and publishing Web sites. All of these functionalities will be presented using explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered. In the end, students will hone the skills that will help them create, edit, and manage Webs easily. This introductory course teaches students the basic features found in Microsoft Outlook 2002. Some skills students will learn include sending, receiving and managing e-mail messages; creating contacts, using the Calendar to schedule appointments and understanding and using tasks. Students will also learn shortcuts to the most commonly used tools in this application. All skills will be taught using true-life scenarios, examples, review exercises and concept graphics to help reinforce the material presented. This course covers intermediate skills for Microsoft Outlook 2002. Topics covered include working with signatures, using the Personal Address Book and specialized mail features, categorizing contacts and messages, archiving mail, working with events and meetings, using the journal and much more. Students will learn how to assign categories to mail messages, propose alternate meeting times and send task status reports. This course introduces students to the basic features of Microsoft PowerPoint 2002. Students will learn how to design PowerPoint presentations on their computers through examples and interactive exercises. In addition, students will learn how to use clip art images and drawing tools to enhance presentations. Students will also learn how to use templates, create tables and prepare a presentation for printing. Other topics that will be covered include creating presentations manually and by using the AutoContent Wizard; formatting text; and working in the Slide, Outline and Notes panes. This course is designed to familiarize students with the intermediate features of Microsoft PowerPoint 2002. This course will prepare students to design PowerPoint presentations on their computers through examples and interactive exercises. Students will also learn how to use WordArt, create clip art collections and apply animation effects. In addition, students will learn how to create and format speaker notes and handouts. Other topics that will be covered include designing moderately complicated presentations, importing Word outlines, working in the Outline pane and working with multiple slide masters. This course is designed to familiarize students with the advanced features of Microsoft PowerPoint 2002. Generally, students will learn how to apply advanced techniques to PowerPoint presentations, such as importing data from other Microsoft applications, adding video and sound clips and modifying charts and tables in presentations. Many of the skills learned pertain to using PowerPoint in team projects, such as sending a presentation for review to another via e-mail and receiving and accepting or rejecting reviewer comments. Students will also learn how to customize PowerPoint to maximize its potential for the type of work they do, such as customizing toolbars, color schemes and indent settings. Finally, students will learn advanced presentation skills including how to create a custom show and agenda and summary slides. This course introduces the basics of Microsoft Project 2002. You'll enter task information, work with task relationships, examine various task types, define working times, assign resources to tasks, enter costs, and establish the project's baseline. Then, you'll simulate changes to the project by splitting tasks, changing durations, and assigning additional resources. Reports, views, multiple projects, and integrating Project with other applications and the Web will also be examined. This course is designed to familiarize students with key introductory features of Microsoft Word, as well as introduce them to some of its new capabilities introduced with the 2002 version. Students will learn the tricks that will help them create, edit and modify text-based documents easily. The skills taught include examining the working screen, getting familiar with the new Task Panes, creating new documents, changing font attributes, modifying bodies of text, formatting entire documents, using smart tags, accessing help for spelling and grammar, managing files and previewing and printing documents. All of these skills will be taught using true-life scenarios, examples, review exercises and concept graphics to help reinforce material presented. This course is designed to familiarize users with the intermediate features of Microsoft Word 2002 so they can enhance the look of their text-based documents. Some skills they will learn include formatting paragraphs by using indents, line spacing and tab stops; dividing the document into sections using margins, page breaks and columns; inserting symbols, numbered lists, watermarks, graphics, tables and charts into documents; exploring Web issues; and using basic revision tools. The material is presented through explanatory text, real-world scenarios, interactive steps and questions to test and reinforce the material covered. This course builds upon intermediate Word skills by teaching students skills in creating and managing large projects. Many of the skills learned deal with using Word 2002 in team projects, such as sending a document for review to another via e-mail. Users will also learn how to customize Word to maximize its potential for the type of work they do, such as customizing toolbars and menus and automating tasks. Students will also learn advanced formatting skills, such as how to format one part of a document differently than another and will gain insight into how Word can be combined with other Office applications such as Access. All of these skills will be taught using true-life scenarios, examples, review exercises and concept graphics to help reinforce the material presented. The course is designed to show students how to use the tools of Microsoft Outlook 2002, such as the Journal, tasks, notes, reminders, Calendar and Rules Wizard, to plan their time and offers tips on how to use other time management tools, such as paper-based products, hand-held devices and other applications. The scope of the course includes understanding time management theory/philosophy, keeping a time log/diary, handling stress, developing a system of organization, identifying priorities, setting and achieving goals, creative problem solving, scheduling/managing a small project and timing teamwork.