Microsoft Access 2007 – Intermediate

From £180.00

This course aims to build on the introductory skills acquired at Beginners level and is the second of a 3-Level programme. This direct delivery course is interactive, and will engage you in activities that will enable you to acquire sufficient skills and knowledge to enable you to enter data correctly, create more sophisticated and complex queries and carry out some basic automation techniques involving macros.

Clear

Description

Course Code APR0203

 

This course aims to build on the introductory skills acquired at Beginners level and is the second of a 3-Level programme.  This Microsoft Access 2007 Intermediate course is therefore designed for users who have an understanding of how to create tables, enter, modify and delete records and create simple queries, tables and forms.   This direct delivery course is interactive, and will engage you in activities that will enable you to acquire sufficient skills and knowledge to enable you to enter data correctly, create more sophisticated and complex queries and carry out some basic automation techniques involving macros.  Upon completion of the course you will be able to:

 

  • Use various data validation features in access to protect data
  • Format data in a table
  • Perform more advanced queries using a variety of querying techniques
  • Create and use parameter queries
  • Create calculated queries
  • Create and use Macros in Access
  • Work with a number of macro techniques
  • Create macros on forms
  • Create a Data Access Page

 

 

Type Details
Delivery Method

Direct delivery via tutor-led training session, offering you 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
 
Microsoft Access 2007 Intermediate assumes that delegates have have completed the Beginners course, and/or have a basic understanding of database and can therefore create databases comprising of tables, simple queries, forms and reports.   It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Progression

The natural progression is 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 in 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 2007 – Intermediate”

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