This course introduces students to some of the new features of the Microsoft Office 2003 System. It covers the major new features that apply to all of the applications, including Microsoft SharePoint Services, Information Rights Management, new and enhanced XML integration, and the Research Task Pane. Also covered are some of the individual new features of Microsoft Office Word, Microsoft Office PowerPoint, Microsoft Office Excel, Microsoft Office Access, Microsoft Office Outlook, and Microsoft Office Publisher. Finally, this course touches upon three new applications that have been added to the new 2003 system: Microsoft InfoPath, Microsoft OneNote, and Microsoft Business Contact Manager. This course introduces students to the basic elements that comprise a Microsoft Office 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 manipulate the Access interface and create their own databases, 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. 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 Microsoft Office Access 2003, 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. Finally, students will be introduced to a few methods of managing and backing up database files. This advanced course broadens 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 Microsoft Office Access, including tables, queries, and forms, reports, and data access pages. In addition, the course introduces students to advanced development features so that they can provide user-friendly databases to their users. The students will learn how to develop data entry tools and automated processes, how to enforce database security, and how to implement maintenance features. The material in the course 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 Excel's 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. Skills are taught using concepts, examples, and interactive steps. This course introduces students to advanced spreadsheet features and acquaints students with Excel's tools by using real-life scenarios and projects. Students will learn to customize workbooks, use lists, use functions to create formulas, format worksheets, use 3-D references, ready workbooks for the Web, use templates to create workbooks, insert and manipulate objects into a spreadsheet. Skills are taught using concepts, examples, and interactive steps. This Microsoft Office Excel 2003 Level 3 course teaches students a set of expert-level spreadsheet features. Students will learn how to summarize, outline, and subtotal list data, as well as how to use named ranges, list ranges, and Lookup Functions. They will apply conditional formatting and data validation. They will import and export data, and learn how to use XML to share, map, and reuse data. They will also discover how to create, format, and modify PivotTables and Pivot Charts to see just the information they need. They will use various worksheet auditing and analysis tools, such as Evaluate Formula, Watch Window, Solver, and scenarios. They will also create and remove custom filters, work with shared workbooks, protect workbooks, track and review changes, and merge and consolidate data from worksheets and customize the Excel working screen with custom toolbars, menus, and macros. This course is designed to familiarize users with key introductory features of Microsoft Office FrontPage 2003. Students will learn skills that will help them create, navigate, edit, and manage Web pages easily. This includes examining the working screen; understanding the difference between Web pages and Web sites; creating new Web sites; entering, modifying, and formatting text; incorporating graphics and tables; creating text and graphic links; applying themes; managing sites using folders, reports, and tasks; and previewing and publishing Web sites. All of these functionalities are taught using true-to-life scenarios, examples, review exercises, and concept graphics to help reinforce material presented. This course introduces students to Microsoft Office Outlook 2003. As well as showing students how to create, send, and receive e-mail, this course looks at Outlook as a personal information management system. It examines how to add and organize all your contact information and how to manage your time with the calendar feature. This course builds upon skills taught in the first level of Microsoft Office Outlook 2003. Students will learn how to use the instant messaging feature integrated into Outlook; customize their outgoing messages with signatures, forms, themes, and stationery; use address books and distribution lists to address messages; use flags and delivery options; and organize and customize views for messages. Students will also learn to use Calendar customization and viewing options and use the Calendar and Tasks features for scheduling and responding to meeting requests and tasks. The Journal will also be delved into as a tool to help manage activities associated with contacts. This course introduces students to the basic features of Microsoft Office PowerPoint 2003. Students will learn how to design PowerPoint presentations on their computers through examples and interactive exercises. They will learn to create presentations from scratch using slide layouts and design templates and by using the AutoContent wizard. In addition, students will learn how to use clip art images and drawing tools to enhance presentations. Students will also be shown how to create and edit tables, as well as how to prepare a presentation for printing. Other topics that will be covered include formatting text and working in the Slide, Outline, and Notes panes. This intermediate-level course builds upon the basic Microsoft Office PowerPoint skills taught in the Level 1 course. Students will learn to modify PowerPoint options to ensure that the application is configured to best meet their needs. They will also discover how to use existing information to create a presentation, including importing outlines from Word and inserting slides from other presentations. Students will explore the use of masters, including how to create, modify, and apply multiple masters in one presentation, as well as how to create Notes and Handouts masters. Students will work with and modify a variety of graphics, such as WordArt, AutoShapes, pictures, and clip art. They will also learn how to apply a variety of animation effects to both text and graphics. In addition, they will learn how to publish and save presentations as Web pages. This course is designed to familiarize students with the advanced features of Microsoft Office PowerPoint 2003. Generally, students will learn advanced skills for creating PowerPoint presentations, such as adding video and sound clips, modifying charts and tables, and customizing color schemes. Many of the skills pertain to using PowerPoint in team presentations, such as setting up review cycles, reviewing presentations, and accepting and rejecting reviewer comments. Students will also learn how to customize PowerPoint to maximize its potential for the type of work they do. For example, students will learn how to customize toolbars and modify indent settings. Finally, students will learn how to create a custom show and how to create agenda and summary slides. This course is designed to familiarize students with key introductory features of Microsoft Office Word 2003, as well as introduce them to some of its new features. 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; creating new documents; changing font attributes; selecting and replacing, copying, or moving text; applying and clearing character styles; modifying bodies of text; working with headers and footers; using smart tags; accessing spelling and grammar checks; managing files; understanding and using Save As; and previewing and printing documents. This intermediate-level course builds upon the basic Microsoft Office Word 2003 skills taught in the Level 1 course. Students will learn how to further enhance the look and functionality of their documents by adding items such as symbols, AutoText, outline numbered lists, hyperlinks, and information found with the new Research task pane. Paragraph formatting will also be examined, covering skills such as setting left, right, and special indents; changing line spacing and page orientation; working with and understanding tab stops; and applying paragraph styles. Students will also learn what sections are and what types of layout decisions are handled in sections, such as margins, breaks, and columns. They will also look at how to insert and modify clip art, graphics, tables, charts, and diagrams, as well as how to preview and save documents as Web pages. Finally, a number of revision tools will be handled, teaching skills such as inserting and modifying comments, sending documents for review, tracking changes, accepting or rejecting changes, and merging documents. This course builds upon intermediate Microsoft Office Word 2003 skills. Students will learn advanced formatting skills, such as how to control pagination, enhance graphics, embed objects, and apply themes and watermarks. They will also gain insight into how data from other Office applications, such as Access and Excel, can be used as source data for Word creations, enabling calculations and mail merges. Different ways of automating tasks will also be examined. This includes creating macros, using AutoSummarize and readability statistics, and generating tables of contents and indexes. Additionally, students will discover how to design and modify forms, protect documents and forms, use field reference, add captions, create Web frames, restrict editing changes, manage larger documents with master documents, and customize Word. Finally, XML and how it works with Word will also be explored.
Contains testing and prescribes the training required to prepare for the Microsoft Office Access 2003 Microsoft Office Specialist exam. Contains testing and prescribes the training required to prepare for the Microsoft Office Excel 2003 Microsoft Office Specialist Core and Expert exams. Contains all of the lessons required to pass the Microsoft Office Outlook 2003 Microsoft Office Specialist exam. Contains testing and prescribes the training required to prepare for the Microsoft Office PowerPoint 2003 Microsoft Office Specialist exam. Contains testing and prescribes the training required to prepare for the Microsoft Office Word 2003 Microsoft Office Specialist Core and Expert exams.