Microsoft Office 2003 Combined Word, Excel, PowerPoint & Access

Course Information

This three day course is designed to build basic Office skills, introducing the delegates to features that will improve efficiency and presentation. Delegates will be able to identify the different applications and make use of some of the in-built features.

Pre-requisites

Delegates should have previous knowledge of Windows and be familiar with the Microsoft environment. Delegates should have some prior knowledge of Word.

Course Objectives

By the end of the course delegates will be able to:

---

Word

• Produce a customised bulleted list. Bullets Numbers & Symbols
• Apply automatic numbering to points within a document.
• Create a Word table.
• Apply controlled borders and shading to a table.
• Calculate using simple formulae within a table.
• Perform a mail merge.
• Produce addressed labels and envelopes

Excel

• Create and save Excel workbooks.
• Enter data in to a new and existing worksheet.
• Calculate using simple mathematical operators.
• Calculate using built-in functions
• Modify page margins, orientation and scaling.
• Print the whole worksheet or specific areas of the worksheet only.

PowerPoint

• Create a simple presentation using the pre-defined slide layouts.
• Control the placement of objects on the slide.
• Create slides containing multi-level bulleted lists.
• Enhance text and objects using simple formatting techniques.
• Print slides and handouts.
• Effectively display the presentation on screen in a slide show using special effects and timings.

Access

• Recognise the advantages of storing a database electronically rather than on a paper based system.
• Navigate the database and records within the database.
• Perform simple database queries to extract or select records from the database according to specified criteria.
• Produce reports from tables and queries.

What you will learn: