Office 2000 Introduction
Microsoft Office
Training
Provided by Online Training Directory
This course introduces students to Microsoft Word, Excel, Access, PowerPoint, and Outlook 2000, as well as containing a section on time management. Students will learn basic features from each one of these courses and gain an introductory knowledge of the applications. They will also learn some techniques to manage time more effectively.
Office 2000 Introduction This course introduces students to Microsoft Word, Excel, Access, PowerPoint, and Outlook 2000.
It also includes a section on time management. In Microsoft Word, students will learn new skills that include examining the working screen, getting familiar with new Task Panes, creating new documents, changing font attributes, modifying bodies of text, and formatting entire documents. Beginning with opening a workbook, students will progress to using the Office Clipboard to cut, copy, and paste items in Microsoft Excel. They will also enter text and formulas, move data, format worksheet appearance, and manipulate data. In Microsoft Access, students will receive instruction in how to create and use the basic tools of the application. They will learn how to enter data in Access and how to manipulate and use that data. Working with slide masters is a function that will be taught in Microsoft PowerPoint.
Students will create presentations and work with visual elements. They will work up to being able to try out different design templates and change placeholders to customize their presentations. Sending, receiving, and managing e-mail messages are some of the basic features that are taught in Microsoft Outlook.
Students will also learn how to use the Calendar to schedule appointments. Building off of Outlook is a course on time management.
The course is designed to show students how to use the journal, tasks, notes, reminders, the Calendar, and the Rules Wizard to plan their time.
|
|
||||||||||||||||
Office 2000 Introduction
Outcomes
Upon completion of this course, students will be able to:
Assessment
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
Program Outline This course contains 3 sectionsMicrosoft Office Access 2000 Level 1Lessons
Contact Hours: 23
Upon completion of this course, students will be able to:
- Work with contacts
- Work with tables
- Incorporate visual elements
- Move and copy data
- Use formatting techniques
Assessment
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
Program Outline This course contains 3 sectionsMicrosoft Office Access 2000 Level 1Lessons
- Looking At Access
- Understand Relational Databases
- Determine Appropriate Data Inputs For Your Database
- Determine Appropriate Data Outputs For Your Database
- Use The Office Assistant
- Select An Object Using The Objects Bar
- Opening Database Objects
- Create A Database Using A Wizard
- Create A Database In Design View
- Create Table Structure
- Establish Table Relationships
- Navigate Through Records In A Table, Query, Or Form
- Create Tables By Using The Table Wizard
- Set Primary Keys
- Modify Field Properties
- Use Multiple Data Types
- Modify Tables Using Design View
- Understanding Forms
- Create A Form With The Form Wizard
- Use The Control Toolbox To Add Controls - Forms
- Modify Format Properties (font, style, font size, color, caption, etc.) Of Controls
- Switch Between Object Views
- Enter Records Using A Datasheet
- Enter Records Using A Form
- Delete Records From A Table
- Find A Record
- Sort Records
- Apply And Remove Filters (filter by form and filter by selection)
- Specify Criteria In A Query
- Display Related Records In A Subdatasheet
- Create And Modify A Multi-table Select Query
- Establish Relationships
- Enforce Referential Integrity
- Understanding Reports
- Create A Report With The Report Wizard
- Preview And Print A Report
- Import Data To A New Table
- Print Database Relationships
- Looking At Excel
- Selecting Cells
- Use Undo and Redo
- Clear cell content
- Enter text, dates, and numbers
- Edit cell content
- Go to a specific cell
- Insert and delete selected cells
- Cut, copy, paste, paste special and move selected cells, use the Office Clipboard
- Clear cell formats
- Work with series (AutoFill)
- Use Save
- Locate and open an existing workbook
- Use the Office Assistant
- Apply font styles (typeface, size, color and styles)
- Apply number formats (currency, percent, dates, comma)
- Modify size of rows and columns
- Modify alignment of cell content
- Adjust the decimal place
- Use the Format Painter
- Apply cell borders and shading
- Merging cells
- Preview and print worksheets & workbooks
- Print a selection
- Change page orientation and scaling
- Set page margins and centering
- Set print, and clear a print area
- Set up headers and footers
- Set print titles and options (gridlines, print quality, row & column headings)
- Insert and delete rows and columns
- Change the zoom setting
- Move between worksheets in a workbook
- Check spelling
- Enter a range within a formula by dragging
- Enter formulas in a cell and using the formula bar
- Revise formulas
- Use references (absolute and relative)
- Use AutoSum
- Use Paste Function to insert a function
- Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX)
- Enter functions using the formula palette
- Preview and print charts
- Use chart wizard to create a chart
- Modify charts
- Looking At PowerPoint
- Selecting A Slide
- Selecting Text
- Delete Slides
- Create A Specified Type Of Slide
- Navigate Among Different Views (slide, outline, sorter, tri-pane)
- Insert Headers And Footers
- Create A Blank Presentation
- Create A Presentation Using The AutoContent Wizard
- Change The Order Of Slides Using Slide Sorter View
- Find And Replace Text
- Modify Slide Sequence In The Outline Pane
- Apply A Design Template
- Check Spelling
- Working With Fonts
- Change And Replace Text Fonts (individual slide and entire presentation)
- Enter Text In Tri-pane View
- Change The Text Alignment
- Use The Office Clipboard
- Promote And Demote Text In Slide & Outline Panes
- Working With Masters
- Add A Picture From The ClipArt Gallery
- Scale And Size An Object Including ClipArt
- Create Tables Within PowerPoint
- Add AutoNumber Bullets
- Add Slide Transitions
- Preview Presentation In Black And White
- Print Slides In A Variety Of Formats
- Print Speaker Notes In A Specified Format
- Use On Screen Navigation Tools
- Use The Pen During A Presentation
- Save Changes To A Presentation
- Save As A New Presentation
- Use Office Assistant
- Looking At Word
- Selecting Text
- Use the Office Assistant
- Navigate through a document
- Use click & type
- Use save
- Locate and open an existing document
- Insert and move text
- Use the Undo, Redo, and Repeat command
- Cut, Copy, Paste, and Paste Special using the Office Clipboard
- Find and replace text
- Apply font formats (Bold, Italic and Underline)
- Use GoTo to locate specific elements in a document
- Use the SPELLING feature
- Use the GRAMMAR feature
- Use the THESAURUS feature
- Select and change font and font size
- Apply character effects (superscript, subscript, strikethrough, small caps and outline)
- Align text in paragraphs (Center, Left, Right and Justified)
- Apply borders and shading to paragraphs
- Add bullets and numbering
- Use indentation options (Left, Right, First Line and Hanging Indent)
- Copy formats using the Format Painter
- Insert graphics into a document (WordArt, ClipArt, Images)
- Create a folder
- Use templates to create a new document
- Create a new document using a Wizard
- Use print preview
- Set margins
- Align text vertically
- Print a document
Contact Hours: 23
About The Training Provider: Online Training Directory
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
