|
|
Microsoft Office XP Course Contents |
|
|
Microsoft Office XP Course Contents |
|
|
||||||||
| About NA | Administration | School Board | Schools | Academics | Libraries | Technology | Athletics | |
|
|
||||||||
|
Scroll Down To View Course Contents |
Word BasicsCourse Contents
The Word application window How to use Online Help Undo Word Wrapping AutoComplete AutoCorrect Cursor movement shortcuts Save a file Create a new document Retrieve a saved document Select text Copy text Move text Delete text Replace text Formatting a document Copy formats Align Text Spell Check
Word IICourse Contents
Mail Merge Create a data source Edit data source View data source Create main document Edit main document Perform the merge Sort merged documents Query/filter merged documents Clear query options Merge data source into mailing labels Create return address labels
Word IIICourse Contents
Tables Creating a table Converting text to a table Adjusting table rows and columns Adjust the table so that all rows are the same height Adding and deleting rows and columns Copying and moving rows and columns Formatting a table Shading cells in a table Manipulating borders in a table Calculating data in a table Sorting data in a table Splitting a table Drawing a table Splitting and merging cells Columns Create newspaper columns Creating sections Column breaks Clip Art Back to Schedule
Access BasicsCourse Contents
Database concepts Database terminology Names and functions of access objects Database planning and design Relating tables to one another Data types Field properties Start Access Learn about the application window Create a table with the Table Wizard Set a primary key Table modifications Add records to table Adjust column widths for readability Sort records The database window View table in datasheet view Table navigation (moving among records) View table in design view Make table modifications in design view Save database Exit access Retrieve saved database
Access IICourse Contents
Modify the table design Insert fields Delete fields Rearrange fields Change field properties Find and edit records Use the find feature to locate a record Spell check Add records Move/copy data Filter records Remove filter Sort records Sort with multiple fields Create a query Use criteria to select records Run the query Sort records in a query Save a query Using operators in query criteria Use multiple criteria in a query Use Null values in a query Back to Schedule
Access IIICourse Contents
Forms Planning a form Creating a form Working with form view and design view Moving and resizing controls Modifying labels Modifying text boxes Modifying tab order Inserting text onto a form Printing a form Add a command button Add a combo box Add a list box Add an option group
Excel BasicsCourse Contents
The excel application window Online help Enter data into a worksheet Edit/Replace cell contents Move around the worksheet Save a file Create a new workbook Retrieve a saved workbook Work with ranges Copy data Move data Fill in a series of text, numbers Fill a range with numbers Sort Change column widths Insert / delete rows or columns Enter formulas Auto sum Format a worksheet Special numeric formats Select the entire worksheet Rotate text Aligning cell contents Center text across a range of cells Copy formats Spell check
Excel IICourse Contents
Spell check Print preview Change margins Create / edit headers/footers Set print titles Insert page breaks Additional print options Specify a range to print Work with multiple worksheets in a workbook Use the outline feature Charts Create a chart Change chart type Change legend titles Add data labels Add chart to worksheet
Excel IIICourse Contents
Lists (database) Using Excel as a database Planning a list Lists versus databases Creating a list Add records with the data form Find records with the data form Sort a list by one field Sort a list by multiple fields Print a list Analyzing list data Use data validation for list entries Produce a list from which to choose entries Set up an input message for data entry Set up an error message for data entry Autofilter Custom filter Creating subtotals using grouping and outlines Freezing columns and rows
FrontPage BasicsCourse Contents
URL Protocol Address Path HTML Navigation Hyperlinks Email Link Bookmarks Thumbnails Hotspots
Front Page IICourse Contents
Forms Database Tables Merge Split Interactive Fields Themes Dynamic HTML
FrontPage IIICourse Contents
Frames Create using Template Remove a Frame Save a Frame as a Web page Turn on/off scroll bars Name a Frame Shared borders Set for all pages Edit Navigation Add existing page Move a page within Add a title Delete a page from your structure Using Navigation bars Print structure Hit Counters Reset counters Hover Button Modify button by properties Add sound Page Transition
Outlook BasicsCourse Contents
Start outlook Create/send a message Read incoming mail Print messages Toolbars and drop-down lists Format messages Set a default signature Delete messages Reply to a mail message Use the reply to all option Forward a message Insert an attachment in a message and send it Receive a message with an attachment and read the attachment Sort mail messages Deal with “mailbox over size limit” message Recover deleted items Create and use a personal distribution list Use tracking options Spell check Access mail account through Internet
PowerPoint BasicsCourse Contents
Start PowerPoint Use Wizard to create a new presentation Features of the PowerPoint window View a presentation using the 6 different views Learn about the 6 views Save a presentation Use online help Create a presentation using Design Template Enter slide text Create a new slide Work in outline view Enter notes that accompany slides Spell check a presentation
PowerPoint II Course Description
Assign Attributes Deleting Objects Duplicating Objects Adding text to Objects Adjusting Text within Objects Adding Pointers Changing Shapes Text Color, Fills, and Shadows Inserting Movie Clip with Text Inserting Clip Art with Text Changing Background Insert Paintbrush pictures Insert Sound Selecting Word Art Style Adding Chart
Microsoft PublisherCourse Objective
WizardsAdd a logo to a personal information set Add Word Art to a PublicationDrop CapCopy the formatting of text or an objectAdd, change, or remove a borderChange text and font attributesSnap To Guides Set up columns using multiple text frames |
