Sales Training Courses If you need to get more sales appointments or  improve your presentation, negotiating and selling skills, Melton IT in association with MLP Training offers eight training courses on how to improve your business, starting Now!:

Goal Setting & Time Management

Getting Appointments Over The Phone

Confident Presentation Skills

Negotiating Skills

Problem Solving & Business Development

Successful Selling Skills

Sales Managers' Master Class

How to Hire & Keep Good People 

 

Sales Training for Busy PeopleSales Training for Busy People

If you are too busy to attend these courses you can now get the very best up to date sales training anywhere, anytime. Six  powerful training programmes are available on CD for you to listen and learn at your leisure. More about Sales Training for Busy People.

 

IT Training

 

SharePoint Services 2007

SharePoint End User

SharePoint Power End User

 

OFFICE 2003

Access 2003 Introduction

Access 2003 Intermediate

Access 2003 Advanced

Excel 2003 Introduction

Excel 2003 Intermediate

Excel 2003 Advanced

Outlook 2003 Introduction

Outlook 2003 Advanced

PowerPoint 2003 Introduction

PowerPoint 2003 Advanced

Project 2003 Introduction

Project 2003 Advanced

Project 2003 Essentials

Publisher 2003 Introduction

Publisher 2003 Advanced

Visio 2003 Introduction

Visio 2003 Advanced

Word 2003 Introduction

Word 2003 Intermediate

Word 2003 Advanced

OFFICE 2007

Office 2007 New Features

Access 2007 Introduction

Access 2007 Intermediate

Access 2007 Advanced

Excel 2007 Introduction

Excel 2007 Intermediate

Excel 2007 Advanced

Outlook 2007 Introduction

Outlook 2007 Intermediate

Outlook 2007 Advanced

PowerPoint 2007 Introduction

PowerPoint 2007 Advanced

Project 2007 Introduction

Project 2007 Advanced

Project 2007 Essentials

Publisher 2007 Introduction

Publisher 2007 Advanced

Word 2007 Introduction

Word 2007 Intermediate

Word 2007 Advanced

VBA

Access VBA

Excel VBA

Word VBA

Windows Vista

Vista New features

Vista Introduction

Vista Advanced

 

Melton IT Home Page IT & Sales Training Courses Search This Wwebsite Contact Details About Melton IT Melton IT and Sales Training Melton IT Training & Services.

Microsoft Access 2007 Intermediate Training

Download Course Outline

 

Request Course Quote

Overview and objectives
Microsoft Access 2007 TrainingThis one-day Microsoft Access 2007 Training course builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.

Target audience
You should be comfortable using a personal computer and Microsoft Windows XP or later. You should also have some experience using Access 2007. You will get the most out of this course if your goal is to become proficient using more advanced Access features and functions, such as relating tables, referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTables charts and forms.
 

Course prerequisites
Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the following courses or have equivalent experience: Windows XP: Basic, or Windows Vista: Basic and Access 2007: Basic.


Course objectives

Course contents
Relational databases • Database normalization • Relating tables • Implementing referential integrity

Related tables • Lookup fields • Modifying lookup fields • Subdatasheets

Complex queries • Joining tables in queries • Calculated fields • Summarizing and grouping values

Advanced form design • Adding unbound controls • Adding Graphics • Adding calculated values • Adding combo boxes • Advanced form types

Reports and printing • Customized headers and footers • Adding calculated values • Printing • Labels

Charts • Charts in forms • Charts in reports

PivotTables and PivotCharts • PivotTables • Modifying PivotTables • PivotCharts • PivotTable forms


(c) Melton IT Services Ltd 2001-2007., Manchester, Lancashire, UK , Last Updated 27/07/2007

Tel 0844 414 2535

  [Legal Policy]  | [ Privacy Policy]  [Top]  [Links]  [Pricing]