Microsoft Access 2016 – Advanced

From £200.00

This Access Advanced course will enable delegates to acquire sufficient skills and knowledge in Microsoft Access 2016 in order to design and create a multi-table database and automate operations using macros and develop a general understanding of the programming environment in Microsoft Access 2016.

Clear

Description

 


Course Code ASR01876-

 

This Access 2016 Advanced course will enable delegates to acquire sufficient  skills and knowledge in Microsoft Access 2016.  Delegates will learn how to design and create a multi-table database and automate operations using macros and develop a general understanding of the programming environment in Microsoft Access 2016.   Upon completion of this course delegates should be able to:
 
  • Design a relational database project
  • Create a relational database file 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 2016 software or have completed the Microsoft Access 2016 Level 1 course. A general understanding of personal computers and the Windows operating system environment would also be beneficial.

Progression

The natural progression is ECDL Access Advanced

Duration

9:30 am to 4:30 pm

Location

Aspyra Training: 46-48 Alfreton Road   Nottingham NG7 3NN.  Alternatively, we can deliver the training Iin your location or on your site at a mutually convenient date and time.  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 2016 – Advanced”

Your email address will not be published. Required fields are marked *