Microsoft Access 2007 Intermediate Training Course

Product type
Level

Microsoft Access 2007 Intermediate Training Course

Melton IT Services Ltd
Logo Melton IT Services Ltd

Need more information? Get more details on the site of the provider.

Description

On this Microsoft Access 2007 training course you will learn how to normalize data, work with Lookup fields, 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 cour…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

On this Microsoft Access 2007 training course you will learn how to normalize data, work with Lookup fields, 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 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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.