Microsoft Access 2007 Advanced Training Course

Product type
Level

Microsoft Access 2007 Advanced Training Course

Melton IT Services Ltd
Logo Melton IT Services Ltd

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

Description

This one-day Microsoft Access 2007 Advanced training course builds on the skills and concepts taught in Microsoft Access 2007 Intermediate training course. You will learn how to create crosstab, parameter, and action queries, create macros, import, export, and link database objects, optimize databases, password-protect and encrypt databases.

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 querying with SQL, using crosstab, parameter, and action q…

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.

This one-day Microsoft Access 2007 Advanced training course builds on the skills and concepts taught in Microsoft Access 2007 Intermediate training course. You will learn how to create crosstab, parameter, and action queries, create macros, import, export, and link database objects, optimize databases, password-protect and encrypt databases.

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 querying with SQL, using crosstab, parameter, and action queries, creating and running macros, importing, exporting, and linking database objects, optimizing a database, and basic database security

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 and Access 2007: Intermediate.

Course contents

Advanced queries 

  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries
  • Querying with SQL 

 Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects
  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

 Importing, exporting, and linking

  • Importing objects
  • Exporting object
  • Linking Access objects

 Database management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties
  • Internet integration
  • Hyperlink fields
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.