You’ve covered many of the basic functions of Microsoft Access and now you’re ready to learn advanced Access features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Target Audience:

Your training in and use of Microsoft Access has provided you with a solid foundation in the basic and intermediate skills. You have worked with the various Access objects, such as tables, queries, forms and reports.

Prerequisites

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Implementing Advanced Form Design

Lesson 2: Using Data Validation

Lesson 3: Using Macros to Improve User Interface Design

Lesson 4: Using Advanced Database Management

Lesson 5: Distributing and Securing a Database

Lesson 6: Managing Switchboards

Your training and experience using Microsoft Access has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports.

Target Audience:

Microsoft Office Access Level 2 is designed for individuals who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Access and other applications.

Prerequisites

Delegates will learn how to

Outline

Lesson 1: Designing a Relational Database

Lesson 2: Joining Tables

Lesson 3: Organising a Database for Efficiency

Lesson 4: Sharing Data Across Applications

Lesson 5: Advanced Reporting

Appendix A: Additional Reporting Options

In this course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. For others, data management may consist of an incidental job responsibility, such as time reporting or recording a sale.

A relational database application such as Microsoft Access can help you and your organisation collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organisation.

Target Audience:

The target students for this course are delegates who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Prerequisites

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Getting Started with Access

Lesson 2: Working with Table Data

Lesson 3: Querying a Database

Lesson 4: Creating Advanced Queries

Lesson 5: Generating Reports

Lesson 6: Customising the Access Environment

In this course, you will explore the advanced features provided with the Outlook interface, such as advanced message, calendar, and contacts management. You will use the Tasks and Journal workspaces provided in the application to manage task assignments to you and others, and to record interactions you have with your colleagues. You will also share your workspaces with other users, and use Outlook data files to save and back up your important information.

Target Audience:

This course is designed for experienced Outlook users who need to customise their Outlook environment and use other advanced level tools to work more efficiently and effectively with Outlook.

Prerequisites

Send and receive email messages
Reply to and forward email messages
Spell check and add attachments to email
Use Word formatting features
Schedule appointments and meetings
Add, edit and modify a contact
Manage personal tasks
Use notes

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Configure Advanced Message Options

Lesson 2: Advanced Message Management

Lesson 3: Advanced Calendar Management

Lesson 4: Advanced Contact Management

Lesson 5: Managing Activities by Using Tasks and Journal Entries

Lesson 6: Sharing Workspaces with Others

Lesson 7: Managing Outlook Data Files

In this course, you will explore the Outlook interface and use Outlook to manage all aspects of email communications. You will work with the Outlook calendar to manage appointments and meetings, use Outlook’s People workspace to manage your contact information, create Tasks and Notes for yourself in Outlook and customise the Outlook interface.

Target Audience:

This course is intended for people with a basic understanding of Microsoft Windows, and who need to learn how to use Microsoft Outlook to compose and send email, schedule appointments and manage contact information.

Prerequisites

Use a mouse
Type and use a keyboard
Navigate through Windows files and folders
Work with Windows – minimise, maximise, open and close

Delegates will learn how to

At the end of this course you will be able to:

Familiarise themselves with the Outlook interface
Compose email messages by using Outlook
Send and receive email messages
Organise email messages
Manage their calendar and contacts using Outlook
Work with tasks and notes
Customise Outlook

Outline

Lesson 1: Getting Started With Outlook

Lesson 2: Composing Messages

Lesson 3: Reading and Responding to Messages

Lesson 4: Managing Your Messages

Lesson 5: Managing Your Calendar

Lesson 6: Managing Your Contacts

Lesson 7: Working With Tasks and Notes

Lesson 8: Customising the Outlook Environment

Microsoft PowerPoint provides you with a variety of tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

Target Audience:

This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery.

As a Microsoft PowerPoint user, you are familiar with the basics of creating a presentation, and you are able to convey information effectively in a simple way.

Prerequisites

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Modifying the PowerPoint Environment

Lesson 2: Customising Design Templates

Lesson 3: Adding SmartArt to a Presentation

Lesson 4: Working with Media and Animations

Lesson 5: Collaborating on a Presentation

Lesson 6: Customising a Slide Show

Lesson 7: Securing and Distributing a Presentation

In your role, you need to grab and maintain your audience’s focus when you’re asked to present important information. You can achieve this by being clear, organised and engaging. In this course you will use Microsoft PowerPoint to create your presentations. You will learn how to use some of the vast array of features and functionality contained within Microsoft PowerPoint. You will gain the ability to organise your content, enhance it with high-impact visuals, and deliver dynamic multimedia presentations.

Target Audience:

This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations by using Microsoft PowerPoint.

Prerequisites

Use a mouse
Type and use a keyboard
Navigate through Windows files and folders
Work with Windows – minimise, maximise, open and close

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Getting Started with PowerPoint

Lesson 2: Developing a PowerPoint Presentation

Lesson 3: Performing Advanced Text Editing

Lesson 4: Adding Graphical Elements to Your Presentation

Lesson 5: Modifying Objects in Your Presentation

Lesson 6: Adding Tables to Your Presentation

Lesson 7: Adding Charts to Your Presentation

Lesson 8: Preparing to Deliver Your Presentation

In Microsoft Word Level 2, you gained the skills to work with more complex business documents and automate tasks. If you work with lengthy documents, collaborate with others, or create forms, this course will show you how to use Word efficiently to accomplish these tasks.

Microsoft Word enables you to do more than simple word processing. It can be used to collaborate on complicated documents and manage how the documents are accessed and distributed. Advanced features of Word enable you to revise, manage, and secure your business documents.

Target Audience:

This course is intended for delegates who create and work with lengthy documents, collaborate with others on documents, and create forms in Microsoft Word.

Prerequisites

Delegates should be able to use Microsoft Office Word to create, edit, format, save, and print business documents that contain text, tables, and graphics.
Use a web browser and an email program.
A basic understanding of how worksheets and presentations work.
Delegates should also hold equivalent knowledge to the level of our Microsoft Word
Level 1; and
Level 2

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Collaborating on Documents

Lesson 2: Adding Reference Marks and Notes

Lesson 3: Simplifying and Managing Long Documents

Lesson 4: Securing a Document

Lesson 5: Forms

In this course you will create more complex documents that include lists, tables, charts, graphics, and newsletter layouts. You will also merge data into documents to personalise correspondence and address envelopes and labels.

After completing the first course in this series, Microsoft Word Level 1, you are now able to perform the basic tasks to create a variety of documents. This course will show you how you can work more efficiently by automating some tasks and providing methods to maintain consistency between documents.

Target Audience:

This course was designed for delegates who can create and modify standard business documents in Microsoft Word, and who need to learn how to use Microsoft Word to create or modify complex business documents as well as customised Word efficiency tools.

Prerequisites

Delegates should be able to use Microsoft Word to create, edit, format, save, and print basic business documents that contain text, basic tables, and simple graphics
Delegates can obtain this level of skill by taking the following courses:
Microsoft Word Level 1

Delegates will learn how to

Outline

Lesson 1: Working with Tables and Charts

Lesson 2: Customising Formats Using Styles and Themes

Lesson 3: Using Images in a Document

Lesson 4: Creating Custom Graphic Elements

Lesson 5: Inserting Content Using Quick Parts

Lesson 6: Controlling Text Flow

Lesson 7: Using Templates

Lesson 8: Using Mail Merge

Lesson 9: Using Macros

In this course, you’ll learn how to use Word to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

These days, most people take electronic word-processing for granted and we expect to use a computer to create the majority of our documents. Microsoft Word is designed to help you move smoothly through the task of creating professional looking documents.

Target Audience:

This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word.

Prerequisites

Delegates will learn how to

At the end of this course you will be able to:

Outline

Lesson 1: Getting Started with Word

Lesson 2: Editing a Document

Lesson 3: Formatting Text and Paragraphs

Lesson 4: Adding Tables

Lesson 5: Managing Lists

Lesson 6: Inserting Graphic Objects

Lesson 7: Controlling Page Appearance

Lesson 8: Proofing a Document

Lesson 9: Customising the Word Environment