Microsoft Access 2007 – Advanced

From £200.00

This course is designed for those who need to know how to automate operations in Microsoft Access 2007 and is the last of a 3-Level programme. It is ideal for those who work in an office environment, clubs, and indeed home. This is a direct delivery course that enables you to acquire sufficient skills and knowledge in order to automate operations using macros, secure and protect data and have a general understanding of the programming environment in Microsoft Access 2007.

Clear

Description

Course Code APR0129

 

This course is the last of a 3-Level programme which is designed for those who need to know how to automate operations in Microsoft Access 2007 .  It is ideal for those who work in an office environment, clubs, and indeed home.  This is a direct delivery course that enables you to acquire sufficient skills and knowledge in order to automate operations using macros, secure and protect data and have a general understanding of the programming environment in Microsoft Access 2007.  Upon completion of the course you will be able to:

 

  • Design a relational database project
  • Create relational database files with multiple tables
  • Set table relationships and join tables together
  • Create queries based on one or more tables
  • Create and work with aggregation queries
  • Create and use a series of action queries
  • Work with a number of macro techniques
  • Create some simple programming code using VBA

 

 

Type Details
Delivery Method Direct delivery training course, providing you with interactive training in a small classroom setting.  Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.
Entry Requirements This course assumes that you have some knowledge and experience of using the Microsoft Access 2007 software or have completed the Microsoft Access 2007 Levels 1 and 2 courses. A general understanding of personal computers and the Windows operating system environment would also be beneficial.
Learning Method This Direct Delivery offers delegates interactive training in a small classroom setting, enabling them to apply what they have learnt in the workplace.  Delegates will receive training materials to support their training.
Progression Upon completion of this course, delegates can progress onto ECDL Advanced Access.
Duration 9:30 am to 4:30 pm
Location Aspyra Training: 46-48 Alfreton Road  Nottingham NG7 3NN.  Alternatively, we can deliver the training in your location or on your site at a mutually convenient date and time.  The onsite rate applies.

Additional information

Weight 1 kg
Course Dates

January 2022, February 2022, March 2022, April 2021, May 2021, June 2021, July 2021, August 2021, September 2021, October 2021, November 2021, December 2021

Delegates

Delegates x 1, Delegates x 2, Delegates x 3, Delegates x 4, Delegates x 5, Delegates x 6

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access 2007 – Advanced”