Microsoft Office Office Pack- Online

Get core skills in Office applications.

Click for more information about online courses The Cengage Education Microsoft Office Pack online course extends students’ skills into the Access, PowerPoint and Project applications. You’ll learn the essential elements like building and modifying a database using Access and presenting a slide show in PowerPoint.

The two-part Project component introduces students to the task pane and identifies features of project tracking.

Key areas of learning:

Microsoft Office 2003 XP Access fundamentals

  • Microsoft Access fundamentals
  • Putting Microsoft Access to work

Microsoft Office 2003 XP PowerPoint fundamentals

  • Getting familiar with Microsoft PowerPoint
  • Enhancing and presenting your slide show

Microsoft Office 2003 XP Project fundamentals

  • Microsoft Project 2003 (XP) fundamentals
  • Data manipulation, views, and reports
  • Project updates, tracking and conflicts
  • Advanced tables, views, and reports
  • Interacting with Microsoft Project Server
Call 1300 853 0338am-6pm AEST Mon-Fri
Get your FREE information pack sent to you Now!
Enrol Online
Course Number B0047
Course Type Online
Course Duration Max 12 months
Study Hours Approx 24 hrs
Qualification Cengage Certificate

Prerequisites

No previous knowledge or experience is required to take this course.

Learning periods

This course contains 1 learning period.

Assessment details:

  • 4 computer-based post assessments

Computer Requirements

Windows XP

  • Internet Explorer 5.5 or higher
  • Firefox 1.0 or higher
  • Cookies, JavaScript, and Java Enabled
  • Processor – Pentium-class or higher
  • RAM – 64 MB (128 MB recommended)
  • Soundcard with speaker or headphones
  • 2.5" Floppy Disk Drive

Broadband Internet is highly recommended to access the online delivered courses.

Pop-up blockers must be disabled to access the online delivered courses learning platform

 

Subjects You’ll Cover

Microsoft Access fundamentals

  • Overview of databases
  • Data inputs and outputs
  • Menus, tools and general work area
  • Creating databases
  • Creating and modifying tables
  • Table fields
  • Build and modify a database (db)
  • Standardise data entry

Putting Microsoft Access to work

  • Queries Forms
  • Reports Pages, macros and modules
  • Database security
  • Database optimisation
  • Creating queries
  • Midifying forms

Getting familiar with Microsoft PowerPoint

  • Opening a slide show
  • Basic features Inserting slides and entering text
  • Formatting text Inserting and formatting objects
  • Importing text and inserting slides
  • Modifying text format

Enhancing and presenting your slide show

  • Inserting and manipulating objects
  • Advanced features
  • Setting up your slide show
  • Saving your slide show
  • Printing and presenting your slide show
  • Formatting slide appearance
  • inserting headers and footers

Microsoft Project 2003 (XP) Fundamental

  • Match Microsoft Project 2003 products with their features.
  • Identify component parts of the Microsoft Project 2003 interface.
  • Identify options in the new project task pane.
  • Create a task. Identify types of task relationships.
  • Distinguish between the task types.
  • Match task constraints with their descriptions in Microsoft Project 2003.
  • Assign a new resource to a task.
  • Identify options to modify a calendar.

Data manipulation, views, and reports

  • Identify predefined filters.
  • Create a custom filter. Identify predefined groups.
  • Create a custom group.
  • Identify options to sort tasks.
  • Identify features of views.
  • Match reports with their categories.
  • Match page setup dialog box options with their tabs.

Project updates, tracking and conflicts

  • Identify project 2003 updating options.
  • Identify task updating options.
  • Identify features of project tracking using baseline values.
  • Identify methods of resolving resource over-allocation in Microsoft Project 2003.
  • Identify methods of resolving scheduling problems in Microsoft Project 2003.

Advanced tables, views, and reports

  • Identify features of earned value tables.
  • Create a custom table.
  • Identify options for manipulating custom fields.
  • Identify gantt chart wizard options that can be selected to format the gantt bar chart in Microsoft Project 2003.
  • Identify features of the format bar dialog box.
  • Identify timescale dialog box options in Microsoft Project 2003.
  • Identify options to customize the network diagram view.
  • Identify options to customize the calendar view.
  • Customize a copy of a predefined report.

Consolidation and resource sharing

  • Create a consolidated project.
  • Identify options for sharing a resource pool.

Interacting with Microsoft Project Server

  • Identify applications associated with Microsoft Project Server 2003.
  • Save a web-based project file to the project server.
  • Identify options to manage the enterprise resource pool.
  • Log on to Microsoft Project Server 2003 by using Microsoft Project web access.
  • Identify features of Microsoft Project web access to manage tasks. Identify features of the project centre and resource centre information views.
  • Identify features of Microsoft Project web access to manage status reporting.
  • Identify the features of Microsoft Project web access that require microsoft windows share point services (wss).

Learning Made Easy

How It Works

Support Network

Recently viewed courses