Microsoft Access 2003 Curriculum Outline

Getting Started with Access 2003

Overview/Description
To create and navigate an Access 2003 database

Target Audience
End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites Familiarity with the Microsoft Office environment

Expected Duration
3 Hours

Lesson Objectives:

Getting Started with Access 2003

• Identify the type of database model implemented by Microsoft Access
• Plan a database design that meets an organizations requirements
• Identify relationships when planning a database
• Select the appropriate database design for an organizations needs
• Associate the main elements of the Access 2003 interface with their functions
• Select the methods for creating a database
• Recognize the functions provided by the database objects in an Access database
• Create an Access database and view its data in different views

Back to List

Basic Access 2003 Tables

Overview/Description
To create and modify tables in Access 2003

Target Audience
End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites Familiarity with the Microsoft Office environment

Expected Duration
3 Hours

Lesson Objectives:

Basic Access 2003 Tables

• Add a table to an Access database
• Add a table using the Design and Datasheet views
• Modify fields to define a tables features
• Use masked input fields and apply indexing to fields
• Create and modify a specific table in Access 2003
• Manage the data in records
• Identify the steps involved in creating the various types of relationships between tables
• Modify table data and edit relationships between tables
• Create a database containing relational tables in response to a business requirement

Back to List

Basic Access 2003 Forms

Overview/Description
To create and modify forms in Access 2003

Target Audience
End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites Familiarity with the Microsoft Office environment

Expected Duration
2 Hours

Lesson Objectives:

Basic Access 2003 Forms

• Select a suitable method for creating a form
• Select methods for adding and formatting controls
• Select methods for manipulating controls
• Select the correct options to bind a control
• Create a form with bound controls
• Select the correct options to format a form
• Select the correct options to manage records displayed in a form
• Format a form and manage records

Back to List

Using Queries and Reports in Access 2003

Overview/Description
To create and modify queries and reports in Access 2003

Target Audience
End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites Familiarity with the Microsoft Office environment

Expected Duration
3 Hours

Lesson Objectives:

Using Queries and Reports in Access 2003

• Select the options that allow you to create and run a select query
• Select the options that allow you to refine a query
• Select the options that allow you to perform calculations on a query
• Create and modify a query and print query results
• Create a crosstab query
• Find unmatched or duplicate records using queries
• Use queries to obtain information useful to an organization
• Select the appropriate methods to generate a specific report
• Add controls to a report
• Select the methods to organize data in a report
• Create a report and organize its data

Back to List

Personalizing and Maintaining Access 2003

Overview/Description
To personalize the Access 2003 environment and maintain databases

Target Audience
End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites Familiarity with the Microsoft Office environment

Expected Duration
1 Hour

Lesson Objectives:

Personalizing and Maintaining Access 2003

• Select methods of customizing the Access 2003 working environment
• Select methods of maintaining an Access 2003 database
• Perform backup and view dependencies in Access 2003
• Maintain a database and customize the working environment

Back to List

Enhancing Tables, Forms, and Reports in Access 2003

Overview/Description
To implement advanced techniques for tables, forms, and reports

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
2.25 Hours

Lesson Objectives:

Enhancing Tables, Forms, and Reports in Access 2003

• Select the appropriate methods of allowing tables to access related data
• Apply data validation to tables
• Access and validate table data
• Add a subform and a subreport
• Create a switchboard form
• Apply conditional formatting to a form
• Add subforms and conditional formatting to a form interface and a switchboard to a database

Back to List

Advanced Querying in Access 2003

Overview/Description
To use advanced queries such as joins, parameter, action, and SQL queries

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
1.75 Hours

Lesson Objectives:

Advanced Querying in Access 2003

• Use joins and parameter queries to obtain specific data
• Use an action query to modify records
• Use action queries to delete and copy data
• Edit a SELECT query using SQL
• Create queries to combine, update, and filter data

Back to List

Working with Data and Presentation in Access 2003

Overview/Description
To use PivotTables, PivotCharts, and other applications to present and handle database data

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
2 Hours

Lesson Objectives:

Working with Data and Presentation in Access 2003

• Select appropriate methods of adding data to a database by importing or linking
• Select the appropriate methods to export Access data to a suitable format
• Use Access 2003 to import and export appropriately formatted data
• Use a PivotTable view to present data
• Use a PivotChart view to present data
• Organize data with PivotTables and PivotCharts

Back to List

Access 2003 and the Web

Overview/Description
To make Access databases use web resources with hyperlinks and data access pages

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
1.25 Hours

Lesson Objectives:

Access 2003 and the Web

• Create a hyperlink address
• Implement the correct procedures for building and maintaining a data access page
• Prepare a data access page for different deployment scenarios
• Create a formatted data access page for a deployment scenario

Back to List

Access 2003 Programmability

Overview/Description
To use macros and Visual Basic for Applications to add interactivity to database objects

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
1.25 Hours

Lesson Objectives:

Access 2003 Programmability

• Create a macro for a typical Access 2003 task
• Launch, modify, and debug macros
• Use the Visual Basic Editor to allow a database object to start handling users actions
• Create a macro and an event handler

Back to List

Database Administration in Access 2003

Overview/Description
To implement methods of securing, sharing, replicating, and optimizing the performance of Access 2003 databases

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration
2 Hours

Lesson Objectives:

Database Administration in Access 2003

• Implement methods of securing database information for a given scenario
• Set a database password and secure VB code in a given scenario
• Implement methods of sharing database information for a given scenario
• Implement methods of creating and synchronizing replicas for a given scenario
• Share and replicate database information for a particular scenario
• Implement procedures to improve the performance of a database

Back to List

Microsoft Excel 2003 Expert Curriculum Outline

Basic Features of Excel 2003

Overview/Description
To provide an overview of the basic features of Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Basic Features of Excel 2003

• Outline the basic features of a spreadsheet and identify the main interface and Help features of Excel 2003
• Create a workbook and navigate through the worksheets in it
• Enter data and text in a worksheet in Excel 2003
• Save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003
• Enter data in a workbook and save it
• Edit data and filter cells in an Excel 2003 worksheet
• Copy and move a cell and a range of cells in Excel 2003
• Insert, edit, copy, and move worksheets
• Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook
• Add and modify data and a worksheet in Excel 2003

Back to List

Printing and Collaborating in Excel 2003

Overview/Description
To demonstrate how to format worksheets in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Formatting Data in Excel 2003

• Apply and adapt a range of Excel cell formats
• Use visual design techniques to apply formatting to an Excel 2003 workbook
• Manipulate rows and columns in an Excel 2003 worksheet
• Apply various types of formatting to an Excel 2003 workbook
• Apply number formatting to cells in Excel 2003
• Apply a number format to cell content in Excel 2003
• Format text and cells and apply number formats to data in Excel 2003

Back to List

Excel 2003 Formulas and Functions

Overview/Description
To demonstrate the printing and collaboration features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Printing and Collaborating in Excel 2003

• Run a spell check, and use the previewing features in Excel 2003
• Adjust the Page Setup options and print a document in Excel 2003
• Use a range of printing option features in Excel 2003
• Adjust printing options and preview and print a document in Excel 2003
• Create and edit comments and send a workbook for review in Excel 2003
• Insert comments and send a workbook for review in Excel 2003

Back to List

Formatting Data in Excel 2003

Overview/Description
To provide an overview of the calculation features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Excel 2003 Formulas and Functions

• Use formulas to perform basic calculations in Excel 2003
• Create a formula in Excel 2003
• Use references and names in Excel 2003 formulas
• Enter a formula that uses cell references in Excel 2003
• Use functions to perform calculations in Excel 2003
• Use logical, financial, and date functions in Excel 2003
• Use the Insert Function feature to insert basic and advanced functions
• Use formulas and functions to perform calculations in Excel 2003

Back to List

Excel 2003 Chart and Multimedia Features

Overview/Description
To demonstrate the chart, graphical, and web features in Excel 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
3 Hours

Lesson Objectives:

Excel 2003 Chart and Multimedia Features

• Create charts to display data in Excel 2003
• Create a chart using the Chart wizard in Excel 2003
• Edit chart source data and change chart type in Excel 2003
• Format, move, and resize a chart in Excel 2003
• Change a data series and chart type in Excel 2003
• Insert graphics in Excel 2003
• Modify graphics in Excel 2003
• Insert a picture into an Excel 2003 worksheet
• Save a worksheet as a web page and work with hyperlinks in Excel 2003
• Create an HTML spreadsheet in Excel 2003

Back to List

Advanced Customization in Excel 2003

Overview/Description
To demonstrate how to customize Excel workbooks and the Excel 2003 application

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2.75 Hours

Lesson Objectives:

Advanced Customization in Excel 2003

• Create and customize templates in Excel 2003
• Create and apply styles in Excel 2003
• Create styles and templates in Excel 2003
• Customize Excel 2003 workbooks by changing their settings and properties
• Use macros in Excel 2003
• Customize an Excel 2003 toolbar
• Record a macro and assign it to a custom button in Excel 2003
• Customize a document using templates, formatting, and macros in Excel 2003

Back to List

Advanced formatting in Excel 2003

Overview/Description
To demonstrate how to apply advanced formatting in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2 Hours

Lesson Objectives:

Advanced formatting in Excel 2003

• Create and use advanced number formats in Excel 2003
• Apply advanced custom number formats in Excel 2003
• Create and apply custom number formats in Excel 2003
• Apply conditional formatting to a worksheet in Excel 2003
• Create a conditional format and apply it to another cell in Excel 2003
• Apply advanced number and conditional formatting in Excel 2003

Back to List

Advanced Data Management in Excel 2003

Overview/Description
To provide an overview of the advanced data management and organizational features in Excel 2003

Target Audience
EEnd users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
2.25 Hours

Lesson Objectives:

Advanced Data Management in Excel 2003

• Sort and filter data lists in Excel 2003
• Group and outline a data list in Excel 2003
• Subtotal data in Excel 2003
• Subtotal, filter, and group a data list in Excel 2003
• Use advanced mathematical, text, and database functions, and consolidate data in Excel 2003
• Use lookup functions in Excel 2003
• Use lookup, mathematical, and database functions in Excel 2003

Back to List

Advanced Data Analysis in Excel 2003

Overview/Description
To provide an overview of the advanced data manipulation and analysis features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
3 Hours

Lesson Objectives:

Advanced Data Analysis in Excel 2003

• Create and modify PivotTable reports in Excel 2003
• Perform calculations on PivotTable reports in Excel 2003
• Create and modify a PivotTable report in Excel 2003
• Create and modify PivotChart reports in Excel 2003
• Create and edit a PivotChart report in Excel 2003
• Use the Goal Seek and Solver tools in Excel 2003
• Employ scenarios to analyze data in Excel 2003
• Create data tables and outline their uses in Excel 2003
• Use data-analysis tools in Excel 2003 to forecast values in a workbook

Back to List

Advanced Validation and Collaboration in Excel 2003

Overview/Description
To identify the advanced data validation and collaboration features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
3 Hours

Lesson Objectives:

Advanced Validation and Collaboration in Excel 2003

• Validate data in Excel 2003
• Audit data in Excel 2003
• Validate data in an Excel worksheet
• Apply worksheet protection in Excel 2003
• Use passwords, encryption, and digital signatures to protect Excel 2003 workbooks
• Apply protection to a range, a worksheet, and a workbook in Excel 2003
• Share and merge workbooks in Excel 2003
• Track changes to data using a range of tools in Excel 2003
• Use Excel 2003 collaboration features to track changes and merge a workbook
• Apply data validation, protect, and share a workbook in Excel 2003

Back to List

Advanced Data Exchange in Excel 2003

Overview/Description
To describe how to use Excel 2003 to share data between people, applications, and on the Web

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites Familiarity with the Windows 2000 or XP user environments

Expected Duration
4 Hours

Lesson Objectives:

Advanced Data Exchange in Excel 2003

• Link worksheets and workbooks and embed files in Excel 2003
• Link and embed data in a workbook in Excel 2003
• Import data from text files into an Excel 2003 workbook
• Create a query in Excel 2003
• Import data from Excel 2003 into other applications
• Import external data into Excel 2003 and import Excel data into another application
• Import data from the Web into Excel 2003
• Create a web query in Excel 2003
• Outline core XML concepts and work with XML files in Excel 2003
• Create an XML document in Excel 2003
• Create a simple XML document in Excel 2003

Back to List

Microsoft Outlook 2003 Curriculum Outline

Sending and Receiving Messages in Outlook 2003

Overview/Description
To demonstrate how to send and receive messages in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet

Expected Duration
3 Hours

Lesson Objectives:

Sending and Receiving Messages in Outlook 2003

• Navigate the principal features of Outlook 2003
• Access the appropriate Help in Outlook 2003, given a scenario
• Launch and navigate Outlook 2003, and access Help
• Create a message
• Address, save, and send a message
• Create, address, save, and send a message in Outlook 2003
• Access, reply to, and forward incoming messages
• Reply to a message, turn on the AutoPreview feature, and forward a message

Back to List

Formatting and Managing Messages in Outlook 2003

Overview/Description
To demonstrate how to format and manage messages in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet

Expected Duration
3 Hours

Lesson Objectives:

Formatting and Managing Messages in Outlook 2003

• Format messages and add signatures
• Specify options for messages
• Create a default signature and organize a vote
• Insert and view attachments
• Insert, view, and save an attachment
• Color-code messages and flag messages for attention
• Manage and organize messages
• Organize Inbox messages

Back to List

Scheduling events, Appointments, and meetings in Outlook 2003

Overview/Description
To demonstrate how events, appointments, and meetings are scheduled in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet

Expected Duration
3 Hours

Lesson Objectives:

Scheduling Events, Appointments, and Meetings in Outlook 2003

• Navigate the Outlook 2003 Calendar
• Schedule appointments and events in the Calendar in Outlook 2003
• Create an appointment and an event
• Plan and schedule an Outlook meeting
• Manage Outlook meetings
• Schedule a meeting using the Calendar
• Update and repeat calendar entries
• Customize the Outlook Calendar
• Set Calendar options and create and customize a recurring series

Back to List

Using Task Lists, Contact Lists, and Notes in Outlook 2003

Overview/Description
To demonstrate how to use task lists, contact lists, and notes in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent

Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet

Expected Duration
2 Hours

Lesson Objectives:

Using Task Lists, Contact Lists, and Notes in Outlook 2003

• Create and use a list of contacts in Outlook 2003
• Manage contacts in Outlook 2003
• Create and manage a contact
• Create a task list
• Manage a task list
• Accept, create, and assign tasks
• Create and use notes

Back to List

Customizing E-mail, Views, Navigation, and E-mail Accounts in Outlook 2003

Overview/Description
To demonstrate how to customize e-mail, views, and navigation and configure additional e-mail accounts in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet

Expected Duration
3.25 Hours

Lesson Objectives:

Customizing E-mail, Views, Navigation, and E-mail Accounts in Outlook 2003

• Customize the Outlook 2003 interface
• Perform customization tasks in Outlook 2003
• Change mail editor and message formats in Outlook 2003
• Recognize how stationery and themes are used in Outlook 2003 and apply stationery to messages
• Use stationery and themes in Outlook 2003
• Work with stationery and themes in Outlook 2003
• Customize Outlook 2003 views
• Customize the Contacts view in Outlook 2003
• Configure additional e-mail accounts in Outlook 2003
• Configure a Hotmail account in Outlook 2003

Back to List

Tracking, Categorizing, Searching, and Printing in Outlook 2003

Overview/Description
To demonstrate how to track, categorize, search, and print items in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet

Expected Duration
3 Hours

Lesson Objectives:

Tracking, Categorizing, Searching, and Printing in Outlook 2003

• Use the Journal in Outlook 2003
• Track a project using the Journal in Outlook 2003
• Use categories to organize information
• Categorize items in Outlook 2003
• Organize items using public and private folders in Outlook 2003
• Search for items in Outlook in a given scenario
• Create and use Search Folders in Outlook 2003
• Create searches and Search Folders in Outlook 2003
• Print Outlook items
• Set Page Setup options and print styles
• Define and apply print styles in Outlook 2003

Back to List

Configuring Rules, Alerts, and Junk Mail Settings in Outlook 2003

Overview/Description
To demonstrate how to organize, manage, and prioritize data using rules, alerts, and the Junk E-mail Filter in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet

Expected Duration
2 Hours

Lesson Objectives:

Configuring Rules, Alerts, and Junk Mail Settings in Outlook 2003

• Identify how to use rules to filter mail in Outlook 2003
• Identify how to use rules to filter mail with public folders and the Out of Office Assistant
• Create a rule in Outlook 2003 for a given scenario
• Identify how to use alerts and rules in Outlook 2003
• Configure alerts in Outlook 2003
• Recognize the characteristics of the Junk E-mail Filter
• Control junk mail in Outlook 2003
• Configure and manage the Junk E-mail Filter in Outlook 2003

Back to List

Sharing Folders, Schedules, and Contacts and Using SharePoint Data in Outlook 2003

Overview/Description
To demonstrate the information sharing and collaboration capabilities of Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet

Expected Duration
3 Hours

Lesson Objectives:

Sharing Folders, Schedules, and Contacts and Using SharePoint Data in Outlook 2003

• Work with shared folders and delegate access in Outlook 2003
• Use custom folders in Outlook 2003
• Configure a shared folder in Outlook 2003
• Work with group schedules in Outlook 2003
• Use group schedules in Outlook 2003
• Publish schedules on the Internet
• Use the Mail Merge feature in Outlook 2003
• Use vCards in Outlook 2003
• Recognize how to use SharePoint Services with Outlook 2003
• Use SharePoint Services with Outlook 2003

Back to List

Data Security in Outlook 2003

Overview/Description
To demonstrate the data security features in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
2.50 Hours

Lesson Objectives:

Data Security in Outlook 2003

• Recognize how to configure security options in Outlook 2003
• Recognize how to protect against viruses in attachments and macros in Outlook 2003
• Configure Internet security zones and use global settings to control downloads
• Implement data security in Outlook 2003
• Recognize how to obtain and use digital certificates in Outlook 2003
• Work with signed and encrypted messages in Outlook 2003
• Work with signed and encrypted messages and import and export a digital ID
• Use digital signatures and encryption in Outlook 2003

Back to List

Archiving and Storing Data, and Using IRM in Outlook 2003

Overview/Description
To demonstrate how to back up and manage data in Personal Folders files, and to use Information Rights Management to control data communication in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
1.25 Hours

Lesson Objectives:

Archiving and Storing Data, and Using IRM in Outlook 2003

• Recognize how to use AutoArchive and Mailbox Cleanup to manage folders in Outlook 2003
• Use AutoArchive and Mailbox Cleanup to manage data in Outlook 2003
• Work with Personal Folders files in Outlook 2003
• Recognize how to configure and use IRM in Outlook 2003

Back to List

Working in Outlook 2003 from Multiple Locations

Overview/Description
To demonstrate how to work remotely, work offline, and work in Cached Exchange mode in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
3.25 Hours

Lesson Objectives:

Working in Outlook 2003 from Multiple Locations

• Recognize how to configure remote connections in Outlook 2003
• Recognize how to connect to Exchange Server mail over the Internet
• Identify how to configure Cached Exchange mode
• Configure a remote connection using Cached Exchange mode
• Recognize how to configure and synchronize offline folders in Outlook 2003
• Recognize how to create and configure a Send/Receive group
• Recognize how to control offline access in Outlook 2003
• Perform offline access configuration tasks in Outlook 2003
• Recognize how to use Remote Mail in Outlook 2003
• Work with Remote Mail in Outlook 2003

Back to List

Newsreaders, Online Meetings, Instant Messaging, and Faxing Information in Outlook 2003

Overview/Description
To demonstrate how to configure and use newsreaders, online meetings, instant messaging, and Internet faxing in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
2.50 Hours

Lesson Objectives:

Newsreaders, Online Meetings, Instant Messaging, and Faxing Information in Outlook 2003

• Recognize how to use the Outlook Express Newsreader in Outlook 2003
• Use the Outlook Express Newsreader in Outlook 2003
• Recognize how to set up online meetings in Outlook 2003
• Set up an online meeting in Outlook 2003 using NetMeeting
• Recognize how instant messaging in Outlook 2003 works
• Recognize how to send a fax using an Internet fax service
• Recognize how to modify, forward, and add an attachment to a fax in Outlook 2003
• Send instant messages and faxes from Outlook 2003

Back to List

Customizing Toolbars and Commands and Creating Forms in Outlook 2003

Overview/Description
To demonstrate how to customize toolbars and commands, and to build and manage custom forms in Outlook 2003

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
3.25 Hours

Lesson Objectives:

Customizing Toolbars and Commands and Creating Forms in Outlook 2003

• Recognize how to customize Outlook 2003 toolbars and commands
• Manage menus and toolbars in Outlook 2003
• Create a toolbar in Outlook 2003
• Identify what custom forms are used for in Outlook 2003
• Identify how to work with forms in design mode in Outlook 2003
• Create a custom form in Outlook 2003
• Create a custom task form in Outlook 2003
• Publish customized forms in Outlook 2003
• Test and publish a custom form in Outlook 2003
• Create a custom form in Outlook 2003

Back to List

Outlook 2003 and Business Contact Manager

Overview/Description
To demonstrate how to use Outlook 2003 with Business Contact Manager

Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003

Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange

Expected Duration
3.50 Hours

Lesson Objectives:

Outlook 2003 and Business Contact Manager

• Identify the main features of Business Contact Manager and configure it in Outlook 2003
• Recognize how to configure accounts and business contacts in Outlook with BCM
• Create an account and a business contact in Outlook with BCM
• Configure opportunities and the product master list in Outlook 2003 with BCM
• Configure an opportunity and the product master list in Outlook with BCM
• Recognize how to generate linked items for BCM records
• Manage linked items for BCM records
• Create and manage linked items in Outlook with BCM
• Use views and reports in Outlook with BCM
• Protect and share BCM data
• Change the BCM database associated with a profile and export BCM data

Back to List

Microsoft PowerPoint 2003 Curriculum Outline

Creating Basic Presentations using PowerPoint 2003

Overview/Description
To explain how to create basic presentations using PowerPoint 2003

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2.50 Hours

Lesson Objectives:

Creating Basic Presentations using PowerPoint 2003

• Use the main components of the PowerPoint 2003 interface
• Get help and other useful information while working in PowerPoint 2003
• Use different methods to create presentations in PowerPoint 2003
• Create PowerPoint 2003 presentations using different methods
• Enter and format text in PowerPoint 2003
• Modify text layout in a PowerPoint 2003 presentation
• Format text in a PowerPoint 2003 presentation
• Create three PowerPoint 2003 presentations

Back to List

Slide Layout and Design in PowerPoint 2003

Overview/Description
To demonstrate how to modify slide layout and design in PowerPoint 2003 presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
1.50 Hours

Lesson Objectives:

Slide Layout and Design in PowerPoint 2003

• Organize slides in PowerPoint 2003 presentations
• Apply slide layout styles to a PowerPoint 2003 presentation
• Rearrange the slides in a PowerPoint 2003 presentation
• Create PowerPoint 2003 presentations using design templates
• Use design templates to create PowerPoint 2003 presentations

Back to List

Using Visuals in PowerPoint 2003 Presentations

Overview/Description
To describe how to add visuals to PowerPoint 2003 presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2 Hours

Lesson Objectives:

Using Visuals in PowerPoint 2003 Presentations

• Add visual elements to a document in PowerPoint 2003
• Modify objects in PowerPoint 2003 presentations
• Enhance a PowerPoint 2003 presentation by using visual elements in your slides
• Use diagrams, tables, and charts in PowerPoint 2003 presentations
• Present data in a presentation using diagrams, tables, and charts
• Create a presentation that includes visual images, a table, and a chart, in a given scenario

Back to List

Finalizing PowerPoint 2003 presentations

Overview/Description
To finalize and distribute PowerPoint 2003 presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2 Hours

Lesson Objectives:

Finalizing PowerPoint 2003 Presentations

• Insert speaker notes, headers, and footers in PowerPoint 2003 presentations
• Protect and save PowerPoint 2003 presentations
• Print PowerPoint 2003 presentations
• Add speaker notes, headers, and footers to a PowerPoint 2003 presentation, and save and print it
• Distribute PowerPoint 2003 presentations
• E-mail a PowerPoint 2003 presentation and publish it as a web page

Back to List

Customizing PowerPoint 2003 Presentations

Overview/Description
To describe how to customize PowerPoint 2003 presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2 Hours

Lesson Objectives:

Customizing PowerPoint 2003 Presentations

• Include multimedia elements in a PowerPoint 2003 presentation
• Add animation to slides in PowerPoint 2003
• Insert multimedia clips and animation to slides in PowerPoint 2003
• Modify the visual design of PowerPoint 2003 presentations
• Change the color scheme and background of a PowerPoint 2003 presentation
• Create a PowerPoint 2003 presentation containing multimedia and animation, in a given scenario

Back to List

Preparing PowerPoint 2003 Presentations for Effective Delivery

Overview/Description
To describe how to add slide timings and transitions, action buttons, and hyperlinks to PowerPoint 2003 presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
1.75 Hours

Lesson Objectives:

Preparing PowerPoint 2003 Presentations for Effective Delivery

• Customize the delivery of a PowerPoint 2003 presentation
• Apply slide transitions and timings to a PowerPoint 2003 presentation
• Add navigational capabilities to a PowerPoint 2003 presentation
• Insert hyperlinks and action buttons in a PowerPoint 2003 presentation
• Create a PowerPoint 2003 presentation containing slide transitions, hyperlinks, and action buttons

Back to List

Running, Broadcasting, and Reviewing PowerPoint 2003 Presentations

Overview/Description
To describe how to run an effective PowerPoint 2003 presentation and explain how to broadcast and collaborate on presentations

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2.75 Hours

Lesson Objectives:

Running, Broadcasting, and Reviewing PowerPoint 2003 Presentations

• Set up slide shows in PowerPoint 2003
• Run a slide show presentation in PowerPoint 2003
• Set up and run slide shows in PowerPoint 2003
• List ways of making PowerPoint 2003 presentations more effective
• Broadcast a PowerPoint 2003 presentation online
• Set up broadcast settings and schedule an online broadcast of a PowerPoint 2003 presentation
• Use the presentation review process in PowerPoint 2003
• Send a PowerPoint presentation for review and reconcile the review

Back to List

Settings, Customization, and Office 2003 Integration with PowerPoint 2003

Overview/Description
To describe how to customize PowerPoint 2003 toolbars, menus, and options, create and run macros, and integrate PowerPoint 2003 with other Microsoft Office 2003 applications

Target Audience
Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification

Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments

Expected Duration
2 Hours

Lesson Objectives:

Settings, Customization, and Office 2003 Integration with PowerPoint 2003

• Use PowerPoint 2003 smart tags and Options buttons
• Insert objects in PowerPoint 2003 presentations
• Use linked and embedded objects in PowerPoint 2003
• Customize PowerPoint 2003
• Configure PowerPoint 2003 options
• Customize the interface and modify settings in PowerPoint 2003

Back to List

Microsoft Word 2003 Expert Curriculum Outline

Getting Started with Word 2003

Overview/Description
To provide a basic introduction to Word 2003 and the features and tools used for creating and navigating documents in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
1 Hour

Lesson Objectives:

Getting Started with Word 2003

• Perform the basic tasks necessary to start work in Word
• Identify the main features of the Word 2003 screen
• Use the Word navigation tools to search through documents
• Open Word, display a toolbar, and find text

Back to List

Working with text and paragraphs in Word 2003

Overview/Description
To provide an overview of the document formatting, navigation, and recovery features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Working with Documents in Word 2003

• Insert headers, footers, and page numbers into a Word document
• Navigate Word documents using various views
• Use advanced navigation features
• Add a header and footer to a document and use the Reading Layout view
• Use document collaboration features in Word 2003
• Use the document recovery features in Word 2003
• Open and repair a corrupted document, merge two Word documents, and insert a comment

Back to List

Structuring, editing, saving, and opening documents in Word 2003

Overview/Description
To demonstrate how to structure, edit, save, and open documents in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Structuring, editing, saving, and opening documents in Word 2003

• Insert page and section breaks into a document
• Adjust the spacing and insert columns
• Correct and customize spelling and grammar, and use the Find and Replace tool in Word
• Correct a spelling error, adjust line and character spacing, and organize text into columns
• Save and open Word documents
• Save documents as web pages, text (TXT) files, or rich text format (RTF) files
• Save a Word document to a new folder, save a Word document as a web page, and modify the document saving options

Back to List

Printing, Help, and Automated Formatting in Word 2003

Overview/Description
To describe how to use the Print, Help, and automated formatting features in Word

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
3 Hours

Lesson Objectives:

Printing, Help, and Automated Formatting in Word 2003

• Use the Edit menu, the Office Clipboard, and the Show/Hide button to move, copy, and paste text
• Preview documents, run a word count, and print documents, envelopes, and labels in Word
• Use the Help and Research options in Word
• Use the Office Clipboard and Research task pane, modify the page setup, and print a document
• Use style options to format text
• Use the AutoCorrect features in Word to correct errors, configure Word to recognize common errors and exceptions, and automate the completion and formatting of text
• Use templates and wizards to create and format documents
• Apply, find, and modify styles, modify the AutoCorrect settings, and create a document from a template
• Create a formal letter in Word 2003 and save it to a specific folder

Back to List

Working with Documents in Word 2003

Overview/Description
To describe tables and media features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
2 Hours

Lesson Objectives:

Working with Tables and Media Features in Word 2003

• Create and format tables in Word
• Modify the structure of a table in Word 2003
• Work with data in tables and create a table style
• Create, format, and modify a table
• Create and format a table in Word 2003
• Add text effects, shapes, and shape effects to a document
• Insert WordArt and a shape into a document
• Insert and modify picture files, clip art, and diagrams in a document
• Insert a picture and diagram into a document
• Use Office 2003s speech recognition function
• Use the handwriting features in Word 2003

Back to List

Working with Tables and Media Features in Word 2003

Overview/Description
To describe tables and media features in Word 2003

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent

Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment

Expected Duration
4 Hours

Lesson Objectives:

Working with Tables and Media Features in Word 2003

• Create and format tables in Word
• Modify the structure of a table in Word 2003
• Work with data in tables and create a table style
• Create, format, and modify a table
• Create and format a table in Word 2003
• Add text effects, shapes, and shape effects to a document
• Insert WordArt and a shape into a document
• Insert and modify picture files, clip art, and diagrams in a document
• Insert a picture and diagram into a document
• Use Office 2003s speech recognition function
• Use the handwriting features in Word 2003

Back to List

Advanced Formatting in Word 2003

Overview/Description
To provide a detailed overview of the advanced page formatting features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Formatting in Word 2003

• Use the advanced page formatting options in Word 2003
• Create and modify styles in Word 2003
• Apply themes and backgrounds and read document statistics in Word 2003 documents
• Apply page borders and themes and modify styles in a Word 2003 document
• Use footnotes and endnotes in Word 2003
• Create and revise endnotes using Word 2003

Back to List

Advanced Document Navigation in Word 2003

Overview/Description
To demonstrate the advanced document navigation features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
1 Hour

Lesson Objectives:

Advanced Document Navigation in Word 2003

• Use tables of contents in Word 2003
• Use hyperlinks, bookmarks, and frames in Word 2003
• Create indexes and cross-references in Word 2003
• Use advanced document navigation features in Word 2003

Back to List

Advanced Data Manipulation Features in Word 2003

Overview/Description
To provide a detailed overview of the tools available for advanced data manipulation in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Data Manipulation Features in Word 2003

• Use forms in Word 2003
• Use fields in Word 2003
• Insert a field into a form and into a standard Word 2003 document, and configure print options for fields
• Use mail merge in Word 2003
• Use advanced mail merge options in Word 2003
• Create and manipulate mail merge data in Word 2003

Back to List

Using Tables, Charts, and Graphs in Word 2003

Overview/Description
To provide a detailed overview of using tables, charts, and graphics

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Using Tables, Charts, and Graphics in Word 2003

• Create Word 2003 tables from Excel data
• Insert and use charts in Word 2003
• Insert Excel worksheets and charts in Word 2003
• Insert and use graphics in Word 2003
• Format drawings and insert picture watermarks in Word 2003

Back to List

Advanced Document Features in Word 2003

Overview/Description
To provide a detailed overview of the advanced document features available for use in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
2 Hours

Lesson Objectives:

Advanced Document Features in Word 2003

• Create, edit, and use macros in Word 2003
• Customize toolbars and menus in Word 2003
• Create and record a macro in Word 2003
• Create a custom toolbar and menu in Word 2003
• Use master documents and subdocuments in Word 2003
• Modify and manage master documents in Word 2003
• Work with master documents in Word 2003

Back to List

Collaborative Features in Word 2003

Overview/Description
To provide a detailed overview of the collaborative features in Word 2003

Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent

Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage

Expected Duration
4 Hours

Lesson Objectives:

Collaborative Features in Word 2003

• Share documents and create document versions in Word 2003
• Configure security settings for a document in Word 2003
• Manage document versions and apply editing and style restrictions in Word 2003
• Use shared workspaces to collaborate in Word 2003
• Use a shared workspace to manage shared documents in Word 2003
• Work with document versions in Word 2003
• Use HTML in Word 2003 to create, modify, and optimize web pages
• Work with XML files in Word 2003 and recognize the function of smart documents
• Work with web pages and XML files in Word 2003
• Use the Track Changes feature and work with changes from multiple reviewers
• Review documents that have been edited by several users and send documents for review by e-mail

Back to List