Access

1

·         examine the Microsoft® Office Access database application.

·         manage the data in a database.

·         examine existing table relationships.

·         query the database.

·         design simple forms.

·         create and modify Access reports.

Access

2

·         follow the steps required to properly design a simple database.

·         create a new database with related tables.

·         control data entry by modifying the design of a table to streamline data entry and maintain data integrity.

·         find and retrieve desired data by using filters and joins between tables and within a single table.

·         create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.

·         enhance the appearance, data entry, and data access capabilities of your forms.

·         customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.

·         use Access data in other applications, including Microsoft Word and Excel.

Access

3

·         restructure an existing set of data to improve the design of a database.

·         use a variety of techniques to summarize and present data with queries.

·         create and revise basic Access macros.

·         create macros that improve data entry efficiency and integrity.

·         improve the effectiveness of data entry in forms.

·         improve the effectiveness of data displayed in reports.

·         maintain an Access database by using various utility tools.

Access

4

·         develop a data access page.

·         develop a data access page, a PivotTable, and a PivotChart.

·         import XML data and export Access data.

·         use VBA to automate a business process.

·         create and modify a database switchboard, and set and modify your startup options.

·         distribute a database and add security features to it.

Excel

1

·         create a basic worksheet.

·         modify a worksheet.

·         perform calculations.

·         format a worksheet.

·         develop a workbook.

·         print the contents of a workbook.

·         customize the layout of the Excel window.

Excel

2

·         create and apply templates.

·         create and modify charts.

·         work with graphic objects.

·         calculate with advanced formulas.

·         sort and filter data.

·         use Excel with the Web..

Excel

3

·         Customize workbooks.

·         Collaborate with others using workbooks.

·         Audit worksheets.

·         Analyze data.

·         Work with multiple workbooks.

·         Import and export data.

·         Structure workbooks with XML.

Excel

4

·         Develop macros.

·         Format worksheets.

·         Create an interactive worksheet.

·         Work with multiple worksheets.

·         Perform calculations.

Outlook

1

·         identify the components of the Outlook environment and compose and respond to a simple message.

·         compose messages.

·         use folders to manage mail.

·         schedule appointments.

·         schedule meetings.

·         manage contacts and contact information.

·         create and edit tasks.

·         create and edit notes..

Outlook

2

·         track work activities using the Outlook Journal.

·         customize the calendar by setting various calendar options.

·         modify message options.

·         make folder information available to other Outlook users.

·         assign and track tasks.

·         customize the Outlook environment.

·         sort, find and color-code items in your mailbox and calendar.

Outlook

3

·         Communicate using MSN Messenger.

·         Personalize your mail by using stationery and signatures.

·         Organize Outlook items by grouping, creating Search Folders, setting rules, and applying conditional formatting.

·         Use contacts to share, link, and communicate information.

·         Save and archive mail.

·         Create a custom form.

·         Set up your computer for offline and remote use.

PowerPoint

1

·         manipulate an existing PowerPoint presentation.

·         begin creating a presentation.

·         format text slides.

·         add tables to a presentation.

·         chart data in a presentation.

·         modify objects on slides.

·         add images to a presentation.

·         prepare to deliver a presentation..

PowerPoint

2

·         create a design template.

·         create organization charts and diagrams.

·         add special effects to a Microsoft® Office PowerPoint® 2003 slide.

·         create a Web-based Microsoft® Office PowerPoint® 2003 presentation.

·         use a Microsoft® Office PowerPoint® 2003 presentation for collaborative workgroup review.

·         use functionality that will enable you to deliver live, self-service, and online presentations

Project

1

·         create a project plan file and enter task information.

·         create a work breakdown structure by organizing tasks and setting task relationships.

·         assign project resources.

·         finalize the project plan file.

Project

2

·         exchange project plan data with other applications.

·         update a project plan.

·         create custom reports.

·         re-use existing project plan information.

Publisher

1

·         create a one-page publication.

·         modify a publication's layout and structure.

·         edit content in a publication.

·         format text.

·         format pictures.

·         identify the options for distributing a publication

Visio

1

·         Identify the various types of drawings you can create using Visio and navigate in a Visio document.

·         Drag shapes from Visio stencils and resize, rotate, align, and transform them.

·         Increase your productivity with smart features, such as numbering shapes automatically, duplicating shapes quickly, and grouping and aligning.

·         Create a flowchart or a cross-functional flowchart.

·         Create an organization chart manually or generate one from a text file.

·         Create an office floor plan to scale.

Visio

2

·         Open and manipulate toolbars and stencil windows in the work area.

·         Change background settings to enhance specific drawings.

·         Use the drawing tools and Operation command features to create new custom shapes.

·         Integrate both simple and complex custom shapes in a drawing.

·         Create new masters in a stencil and edit masters.

·         Use the Document stencil to quickly take inventory of all the shapes used in a drawing.

·         Create a new custom template and use it to quickly create a drawing.

·         Create and use styles to quickly format multiple shapes in a drawing.

·         Use layers to organize and control shapes in a drawing.

·         Link a Visio drawing within a Microsoft Word document and update any changes.

·         Link shapes in a drawing to information contained in an external database.

·         Convert a drawing to a Web page.

·         Use several techniques for preparing a drawing for printing.

Word

1

·         create a basic document.

·         edit documents by locating and modifying text.

·         format text.

·         format paragraphs.

·         use Word tools to make your documents more accurate.

·         add tables to a document.

·         add graphic elements to a document.

·         control a document's page setup and its overall appearance.

Word

2

·         manage data in lists.

·         customize tables and charts.

·         customize formatting.

·         work with custom styles.

·         modify pictures in a document.

·         create customized graphic elements.

·         control text flow.

·         automate common tasks.

·         automate document creation.

·         perform mail merges.

Word

3

·         Use Word with other programs.

·         Collaborate on documents.

·         Add reference marks and notes to a document.

·         Make long documents easier to use.

·         Secure documents and document information.

·         Create Web pages.

·         Create a form.

·         Use XML in Word.

Windows XP Professional

1

·         Use fundamental personal computing terminology.

·         Use fundamental Windows XP skills.

·         Use Windows Explorer to manage files and folders.

·         Use common Windows XP program techniques by working with several programs at the same time.

Windows XP Professional

2

·         Customize the Windows XP environment.

·         Share files, folders, and resources over a network.

·         Access the Internet using Windows XP programs.

·         Use Windows XP tools to maintain the computer.

Windows Vista

1

·         identify the basic components and capabilities of personal computers.

·         explore Windows Vista.

·         customize the Windows Vista desktop.

·         use common tools and programs available in Windows Vista.

·         manage folders and files.

·         browse the Internet using Internet Explorer 7.0.

Windows Vista

2

·         customize the Windows Vista environment.

·         work with Windows Vista applications.

·         work with Internet Explorer 7.0.

·         manage network communication and sharing.

·         back up and restore files and folders.

·         enhance system performance using technologies available in Windows Vista.