MS Office 2010 Training Bundle

UK Learning College

Course

In

Price on request

The best Office Systems courses

See all

See all

Description

  • Type

    Course

  • Start date

    Different dates available

Course OverviewSchedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.Microsoft Office Professional 2010 is a complete suite of productivity and database software that will help you save time and stay organized. Powerful contact management features help you manage all customer and prospect information in one place. Develop professional marketing materials for print, e-mail, and the Web, and produce effective marketing campaigns in-house. Create dynamic business documents, spreadsheets, and presentations, and build databases with no prior experience or technical staff. You will learn new features rapidly using improved menus that present the right tools when you need them.MS Access 2010 Training This comprehensive Microsoft Access 2010 Training Course course covers all of the functions and features of Access 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.Students will also learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.Finally, students will learn how to query with...

Facilities

Location

Start date

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • Access
  • Management
  • IT Management
  • Ms Office
  • Graphics
  • Office IT
  • Outlook
  • Printing
  • Database training
  • Database
  • Basic IT training
  • Web
  • Basic
  • Basic IT
  • Marketing
  • Design
  • Microsoft Office
  • Microsoft Access

Course programme

Training Course Content

Course Structure

The MS Office 2010 Training Bundle include the following courses

MICROSOFT ACCESS 2010

Unit 01 - Getting Started

Unit 02 - Databases and Tables

Unit 03 - Fields and Records

Unit 04 - Data Entry Rules

Unit 05 - Basic Queries

Unit 06 - Using Forms

Unit 07 - Working with Reports

Unit 08 - Relational Databases

Unit 09 - Related Tables

Unit 10 - Complex Queries

Unit 11 - Advanced Form Design

Unit 12 - Reports and Printing

Unit 13 - Charts

Unit 14 - PivotTables and PivotCharts

Unit 15 - Querying with SQL

Unit 16 - Advanced Queries

Unit 17 - Macros

Unit 18 - Advanced Macros

Unit 19 - Importing, Exporting, and Linking

Unit 20 - Database Management

MICROSOFT EXCEL 2010

Unit 01 - Getting Started

Unit 02 - Entering and Editing Data

Unit 03 - Modifying a Worksheet

Unit 04 - Functions

Unit 05 - Formatting

Unit 06 - Printing

Unit 07 - Charts

Unit 08 - Managing Large Workbooks

Unit 09 - Using Multiple Worksheets and Workbooks

Unit 10 - Advanced Formatting

Unit 11 - Outlining and Subtotals

Unit 12 - Cell and Range Names

Unit 13 - Tables

Unit 14 - Web and Sharing Features

Unit 15 - Advanced Charting

Unit 16 - Documenting and Auditing

Unit 17 - Templates and Settings

Unit 18 - Advanced Functions

Unit 19 - Lookups and Data Tables

Unit 20 - Advanced Data Management

Unit 21 - PivotTables and PivotCharts

Unit 22 - Exporting and Importing

Unit 23 - Analytical Tools

Unit 24 - Macros and Custom Functions

Unit 25 - Conditional Formatting and SmartArt Graphics

MICROSOFT OUTLOOK 2010

Outlook 2010: Basic

Unit 01 - Getting Started

Unit 02 - Email

Unit 03 - Email Management

Unit 04 - Contact Management

Unit 05 - Tasks

Unit 06 - Appointments and Events

Unit 07 - Meeting Requests and Responses

Outlook 2010: Intermediate

Unit 01 - Customizing Outlook

Unit 02 - Working with Contacts

Unit 03 - Customizing Messages

Unit 04 - Organizing Items

Unit 05 - Organizing Mail

Outlook 2010: Advanced

Unit 01 - Collaboration

Unit 02 - Mailbox Management

Unit 03 - The Notes and Journal Folders

Unit 04 - Calendars and Contacts

Unit 05 - Mail Merges and Templates

MICROSOFT POWERPOINT 2010

Unit 01 - Getting Started

Unit 02 - New Presentations

Unit 03 - Formatting Slides

Unit 04 - Using Drawing Objects

Unit 05 - Working with Graphics

Unit 06 - Using Tables and Charts

Unit 07 - Modifying Presentations

Unit 08 - Proofing and Delivering Presentations

Unit 09 - Customizing PowerPoint

Unit 10 - Using Graphics and Multimedia

Unit 11 - Customizing SmartArt Graphics and Tables

Unit 12 - Action Buttons, Custom Slide Shows, and Equations

Unit 13 - Distributing Presentations

Unit 14 - Integrating Microsoft Office Files

MICROSOFT WORD 2010 COURSE

Unit 01 - Getting Started

Unit 02 - Navigation and Selection Techniques

Unit 03 - Editing Text

Unit 04 - Formatting Text

Unit 05 - Tables

Unit 06 - Page Layout

Unit 07 - Proofing and Printing Documents

Unit 08 - Graphics Unit 09 - Styles and Outlines

Unit 10 - Sections and Columns

Unit 11 - Formatting Tables

Unit 12 - Printing Labels and Envelopes

Unit 13 - Templates and Building Blocks

Unit 14 - Graphics (Intermediate)

Unit 15 - Managing Document Revisions

Unit 16 - Web Features

Unit 17 - Using Mail Merge

Unit 18 - Objects and Backgrounds

Unit 19 - Working with Forms

Unit 20 - Using Macros

Unit 21 - Customizing Word

Unit 22 - Long Documents

Unit 23 - XML Features

The UK Learning College is a leading Distance Learning Provider, offering a route to study for anyone who wants to gain a new skill or qualification, but finds the traditional, classroom-based mode of study unsuitable. Distance learning is an ideal way to learn around your current time and financial commitments, no matter how diverse and unpredictable your schedule is. With UK Learning College you not only study when it suits you and in your own time, but you can be sure of receiving all the advice and support you require as your studies develop. Because of our continuous system of enrolments, Students can enrol any time of year, and our flexible distance learning courses allow students to plan their studies to fit in their life style or work commitments. All of our students have access to their own personal distance learning course tutor who specialises in their field of education and is totally committed to helping you succeed in your home learning course.

Additional information

Expenses

Enrolment Fees

Our aim is to provide you with the best deal available, therefore the enrolment fee for the MS Office 2010 Training Bundle course is £486.25, though for a limited time we are offering you the opportunity to pay only £389 which is a 20% discount if you enrol online and pay in...

See related categories

MS Office 2010 Training Bundle

Price on request

The best Office Systems courses

See all

See all