Access 2003 - Basic
Use database terminology, plan the design of a database, and use the Help feature.  Use Datasheet view and Design view.  Create and save databases, create a table, and set the primary key.  Modify a table's design; add, delete, sort, and filter records.  Create simple queries and design complex queries to perform calculations.  Create, use and modify forms.  Create, modify, and print reports.  Import and export database objects and XML documents, and link database objects.

Access 2003 - Intermediate
Normalize tables to reduce redundancy, set relationships between tables, and implement referential integrity.  Use the Lookup Wizard to create lookup lists in table Design view and use subdatasheets to enter data in related tables.  Create an input mask in Design view, use the Input Mask Wizard to specify input masks, set different properties of a field in Design view, and set validation rules for entering data in a field.  Create self-joins, and outer joins, create calculated fields in a query, create queries to add, modify, and delete data from tables, and create queries to create a new table.  Use queries to view summarized and grouped data from tables, create crosstab queries to summarize grouped data, create parameter queries, and set indexes in a table.  Use controls to add graphics and calculated fields to a form, add combo boxes to a form, and add unbound controls to a form.  Customize headers and footers in a report, use the Hide Duplicates property to hide duplicate values in a report, use functions to add calculated values, and use subreports to view data from related tables in a report.

Access 2003 - Advanced
Create PivotTables and PivotCharts for analyzing and comparing large amounts of data.  Create and use an advanced form by adding a tab control an option group control and a subform to it.  Create and use a macro to open database objects and attach a macro to a command button.  Create and use macros to automate user-interaction by using the Condition column and SetValue action.  Use Structured Query Language (SQL) to create queries in Access.  Use Hyperlink and data access pages to link an Access database to the Internet or an intranet.  Work with database utilities to optimize resources and secure data and use security features to encrypt data from other applications.  Secure a database by setting a password and specifying user-level and object-level permissions.

Excel 2003 - Basic
Identify and use the main components of the Excel window and workbook, and use the Help feature.  Enter and edit labels, values and formulas in a worksheet, use the Undo and Redo commands, and find and replace a formula.  Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas.  Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet and use the AutoSum feature.  Format text, numbers, rows, and columns in a worksheet.  Preview, control Page Setup options for a worksheet, print a worksheet, and set and clear a print area.  Create, format, modify and print charts based on worksheet data.  Save a worksheet as a Web page, use the AutoRepublish feature, insert and edit hyperlinks in worksheets, and send a worksheet via e-mail.

Excel 2003 - Intermediate
Navigate large worksheets effectively by using magnification and frozen panes and control the printing of large worksheets.  Navigate, manage, and print multiple worksheets, link workbooks by using 3-D formulas, and summarize data by using the Consolidate command.  Change the view, general, and calculation settings of Excel and customize toolbars and menus.  Format data points, create combination charts and trendlines, and add and format graphic elements.  Add borders and shading, apply special formats, create, apply, and modify styles, and change the orientation of cells.  Sort lists by columns and filter lists based on complex criteria.  Add comments and text boxes, use the auditing features, and protect a worksheet or part of a worksheet.  Work with Excel's built in templates and create and manage custom templates.

Excel 2003 - Advanced
Use names to assign descriptive labels to cells and use logical and financial functions to calculate values based on conditions.  Use lookup functions to return values from a table and use data tables to view the effects of multiple input values on a formula.  Use subtotals and database functions to summarize list data, and use data forms and validation to facilitate data entry in lists.  Create and use Pivot Tables to analyze and compare large amounts of data.  Import data from and export data to external databases.  Use Goal Seek and Solver to perform what-if analyses, and use custom scenarios and views to manage different versions of worksheets.  Run and record macros to automate complex or repetitive tasks.  Publish a worksheet as an interactive Web page.

FrontPage 2003 - Basic
Explore and understand the FrontPage interface, and view a Web by using the Views bar.  Design, create, and format a Web page and create bulleted, numbered, multilevel, and definition lists.  Add active elements such as marquees and hit counters to a Web page.  Add background colors and pictures to a Web page, and apply and customize a theme to a Web page.  Create a bookmark and link to it, create hyperlinks, hover buttons, and mailto links, and create and test navigation bars and bars with custom links.  Create and modify hyperlinks to text and graphics, add and modify graphics, create a photo gallery, and add a video to a Web page.  Insert, format, and modify tables and nested tables, and add a caption to a table.  Create, format, and modify a frames page.  Create and manage tasks, check spelling errors, and publish a Web site.

FrontPage 2003 - Advanced
Animate a Web by adding effects, sounds, ActiveX controls, and Java applets.  Use styles to add a distinctive look to your pages and enforce consistency across your Web.  Use forms to get input from users and to enable users to search your site.  Save form results and use the Database Results Wizard to display or enable users to search for database information.  Use reports to manage the Web, enable source control, and check files in and out.  Set permissions for subwebs.  Design sites for special-needs audiences, make pages compatible with different browsers, and promote your Web.

Outlook 2003 - Basic
Navigate in the Outlook window, explore Outlook Today, and use the Help system.  Communicate by creating and sending e-mail messages, handling messages, and using the Address Book.  Use the Contacts folder to manage contact information and work with the Master Category List to categorize contacts.  Add and modify tasks for yourself and assign tasks to others.  Use Calendar to schedule and edit appointments, and create events.  Schedule meetings electronically by planning and sending meeting requests, managing meetings, and examining the online NetMeeting feature.  Organize and customize Outlook by using personal folders, colors, voting buttons, and signatures.

Outlook 2003 - Advanced
Customize the Outlook Bar and the Outlook menus and toolbars.  Organize the inbox by sorting and archiving messages and using the Rules Wizard. Work with Journals and Notes and advanced Calendar and Contact features.  Create and use templates and forms to customize your messages.  Integrate Outlook components with other Office applications.  Create public folders, post discussion items, and assign folder permissions.  Set up and use Remote mail and Offline folders.  Work with Newsgroups and examine security settings.

PowerPoint 2003 - Basic
Explore the PowerPoint environment and use Help options.  Create a new presentation, add new slides too it, save and update changes, work in the Outline tab to rearrange bullets, rearrange and delete slides, and insert slides from another presentation.  Use the Formatting toolbar, use the Cut, Copy, and Paste commands, examine the ruler, check spelling in a presentation, and use AutoCorrect and the Style Checker.  Create objects by sing the Drawing toolbar, add AutoShapes to a slide, draw text boxes, and edit AutoShapes.  Use the WordArt toolbar to enhance text in a presentation, and insert and explore clip art on the Web.  Add a table, use Microsoft Graph, and create an organization chart.  Apply a design template, edit a slide master, work with multiple slide masters, add and delete slide masters, adjust the pace of a presentation, and add speaker notes and footers to each slide in a presentation.  Hide a slide, print a presentation, export to Microsoft Word format, save a presentation for Web deliver, and add a link to another presentation.

PowerPoint 2003 - Advanced
Modify an existing template, create a template from a blank presentation, build a custom slide master, maintain multiple slide masters, and use Automatic Layout.  Work with advanced clip art and drawing techniques, and add sound clips, movie clips, animation effects, and scanned images to a presentation.  Insert and modify an Excel worksheet, build slides from a Word outline, edit a presentation in Word, save a presentation as a RTF outline, and insert a Word table in a presentation.  Use advanced organization chart options, format tables, and draw tables in a presentation.  Add action buttons, link a presentation to another file and to a Web page, set up slide shows, create custom slide shows, and set up a review cycle.  Broadcast a presentation on the Web, use Microsoft NetMeeting to broadcast a presentation on demand, embed fonts and compress pictures, use the Pack and Go Wizard, and use advanced delivery techniques.  Customize an existing toolbar, create a new toolbar, and create and run a macro.

Publisher 2003 - Basic
Start and close the program; open, navigate, and close a publication; zoom in and out; and use the  various Help options.  Create, save and edit text in a publication; adjust a publication's page setup; and work with text frames.  Format text, create a text style, modify paragraph properties, check spelling, and search for and replace text.  Create and modify multi-page publications, insert pages, add Continued notices, work with master pages, import text, and create columns.  Insert and modify AutoShape objects, crop pictures, wrap text around a picture, rotate and flip pictures, and create and modify Word Art objects.  Create a table, enter text in a table, apply a Table AutoFormat, insert, delete and modify rows and columns, merge cells, add borders to a table, and rotate a table.  Use the Design Checker to scan for potential printing problems, print a publication, and use the Pack and Go Wizard.

Publisher 2003 - Advanced
Create and modify newsletters.  Create a Web site, add and delete pages, apply background textures and sounds, insert logos, borders, and motion clips, and work with form pages and form controls.  Create and modify hyperlinks, and create, modify, and delete hot spots.  Correct problems in a Web site by using the Design Checker

Word 2003 - Basic
Use Word to create, save, and print a document as well as use the Help system.  Use basic editing techniques.  Learn selection techniques, copy and move text, and use Find and Replace commands to modify a document.  Format characters and paragraphs; work with tabs.  Create, edit and enhance tables.  Add headers and footers; learn page layout controls.  Spelling and Grammar features.  Save a document as an HTML file in a browser, insert hyperlinks, and send Word documents via e-mail.

Word 2003 - Intermediate
Create and format sections as multiple columns, work with text in columns, and edit and remove sections and columns.  Modify a table by applying borders and shading, using the Table AutoFormat feature and draw tables.  Import data from Excel into Word, link data from Excel by using the Paste Special command, and perform calculations on table data using formulas.  Create and apply paragraph styles, and use the Outline feature, Document Maps, and AutoText entries.  Create headers and footers, and use the Page Numbers dialog box.  Insert graphics, files, WordArt, symbols, and watermarks in a document; use the Drawing Canvas and the Diagram Gallery.  Use and customize templates to create consistent-looking documents.  Use advanced printing options to print labels and envelopes.

Word 2003 - Advanced
Use the Mail Merge Wizard to create form letters, add fields to a form letter, use data source files to sort and query data, and create mailing labels.  Create, modify, protect and use forms.  Create a master document, table of contents, table of figures, endnotes and footnotes, index, bookmarks, and cross-references in documents.  Track changes in a document, create, save and compare document versions, and insert, edit, delete comments.  Record and run macros to automate tasks, modify and delete macros, and create and delete custom menus and toolbars and add buttons to toolbars.