Office 97

This series introduces users to the Office 97 suite of applications, including Access, Excel, Outlook, PowerPoint, and Word. It presents the basic skills needed in each application to create new files, format and manipulate data, and save files. It also covers topics including working with files for use on the Internet, templates, graphics, and styles.

Syllabus

ACCESS 97: GETTING STARTED

Introduces users to the components of an Access database and shows how to design and create a basic table.

• Introduction to Database Concepts
• The Access Work Environment
• Opening a Database
• Using Tables and Forms
• Using Sorting and Querying
• Designing and Creating a Table
• Adding Fields to a Table
• Adding Records to a Table

ACCESS 97: USING A DATABASE

Shows users how to use an existing database to find and display data in a variety of ways.

• Modifying a Table's Design
• Finding Records
• Editing Records
• Query Basics
• Sorting and Saving a Query
• Setting Criteria in a Query
• Form Basics
• Modifying Simple Forms
• Sorting and Editing Records in a Form
• Creating Basic Reports

EXCEL 97: GETTING STARTED

Presents the skills that enable a new user to create and edit a basic electronic spreadsheet.

• The Excel Working Environment
• Excel Basics
• Adding to the Worksheet
• Editing the Worksheet

EXCEL 97: MODIFYING WORKSHEETS

Presents the skills that enable a new user to modify, format and print Excel spreadsheets.

• Moving and Copying Data
• Formatting a Worksheet
• Working with Named Ranges
• Printing a Worksheet
• Using Toolbars
• Sorting Data

EXCEL 97: USING EXCEL TOOLS

Shows how to enhance the presentation of data by presenting it in graphic form.

• Creating Charts
• Formatting Chart Objects
• Modifying Charts
• Using Drawing Tools
• Using Outlining to Group Data
• Creating Spreadsheets for the Internet

OUTLOOK 97: GETTING ORGANIZED

Shows users how to use Outlook to receive and send mail messages, share files and manage their time with a scheduling program.

• Getting Started
• Using Outlook Tools
• Receiving Messages
• Sending Messages
• Exploring Message Options
• Working With Outlook's Calendar
• Organizing Your Schedule
• Tracking Communications
• Managing Outlook Items
• Saving in Outlook
• Integrating Your Work

POWERPOINT 97: CREATING PRESENTATIONS

Shows users how to create, run and print a basic slide show.

• Getting Started
• Beginning a Presentation
• Creating Slides and Entering Text
• Bullets and Slide Text Attributes
• Working With Slide Text
• Presentation Options
• Printing

POWERPOINT 97: MODIFYING PRESENTATIONS

Shows users how to modify presentation slides by adding drawings, objects, and clip-art graphics.

• Getting Help
• Drawing Basic Shapes
• AutoShapes and Free-Form Objects
• Working with Objects
• Editing Objects
• Adding Clip Art
• Working with Slide Masters
• Working with Templates

WORD 97: GETTING STARTED

Presents basic word processing and Word skills that enable a new user to create and edit documents.

• Working in Word 97
• Entering Text
• Editing a Document
• Saving, Printing, and Closing a Document
• Manipulating a Document
• Moving Through a Document
• Selecting and Replacing Text
• Moving and Copying Text

WORD 97: FORMATTING DOCUMENTS

Shows users how to add character, paragraph and page formatting to their Word documents.

• Character Formatting
• Paragraph Formatting
• Page Formatting
• Proofing Documents
• Advanced Formatting and Editing Techniques

WORD 97: USING PRODUCTIVITY TOOLS

Demonstrates the use of more advanced Word features such as templates, styles, tables, graphics and mail merge.

• Using AutoText
• Working with Tables
• Working with Multicolumn Text
• Working with Graphics
• Using Templates and Styles
• Creating Documents for the Internet
• Using Mail Merge

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.