Skip to Content



HOME
  • Course help
  • Free courses
  • Online courses
  • Courses in London
  • Courses in Manchester
 

Microsoft Access 2016 Intermediate

Vantage Training Limited
Course summary
Professional Training
405 GBP
Altrincham
Course Dates
Altrincham
405 GBP
Contact for dates

Course description

Microsoft Access 2016 Intermediate:

Who is this course for?

With basic skills and some experience of Microsoft Access, the topics covered on this intensive course will help you to develop the power of your relational databases.

Content

Database Structure

Review of the elements of an Access database and the importance of table relationships.

Understanding Indexes.

More on Queries

Reviewing the basics of SELECT Queries.

Using parameters as selection criteria.

Creating ACTION queries to perform automatic updates, archive and deletion of records.

More on Forms

Reviewing basic form creation.

Using controls such as Combo-Boxes to enhance forms.

Calculating simple expressions.

Using forms to provide selection criteria for queries.

Creating sub-forms.

More on Reporting

Reviewing basic reports design.

Using sorting and grouping in reports.

Calculating aggregate values, like totals and averages.

Using sub-reports.

Creating Menus

Introducing the Navigation options to design basic menus.

Startup menu options.

Additional Topics

Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Suitability - Who should attend?

It is assumed that you have a skill level equivalent to that gained through attending the introductory Access training.

Outcome / Qualification etc.

Certificate of Attendance

About provider

Nationwide Software Training

Vantage Training formed as a limited company back in 1995, although the two directors, Gill Lewis and Brian Roberts, had been working together for some years at this point. By the time vtl was formed, long term contracts had been...


Read more and show all courses with this provider

Request info

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Country *

Contact info

Vantage Training Limited

The Wharf, Trent Lane, East Bridgford
NG13 8PF Nottingham

 Show phone number
www.facebook.com


Find more courses here

Learn more!

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Free course help

Free Training Quote and Advice from Findcourses.co.uk Specialists

Our experienced advisors help you find the most suitable course.

Personalised course recommendations - all for free.

Get started

View again