We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

We provide Microsoft Acess 2010 training courses, Microsoft  Acess 2013 training courses Microsoft Access 2016 training courses and Microsoft Access 365 training. All our training courses are tailor-made to suit the needs of the individual or organisation. We usually train at client site but also train remotely using Microsoft Teams or Zoom.

Aims of the Intermediate Access course

This Intermediate Access training course aims to give delegates a greater understanding of MS Access.

Number on course     Price per day
1 - 1 training                 £295 + VAT
2 - 4 people                   £475 + VAT
5 - 8 people                   £595 + VAT
Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Access. They will be able to:

  • Use field properties for protection
  • Understand table relationships and referential integrity
  • Create multi-table queries
  • Use calculations in a query
  • Design custom entry forms
  • Design custom reports

The course is of one day's duration.

How the course is run – This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites – Familiarity with the Windows environment, and a basic knowledge of MS Access.


Outline

Displaying the Access database

  • The Navigation pane, customising the Navigation pane
  • Database display

Table design – fields

  • Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Creating and editing a lookup in a field
  • Creating and editing a validation rule in a field
  • Creating and editing an input mask in a field
  • Applying and modifying default values in a field
  • Setting a mandatory field
  • Fields with multiple values

Table Relationships

  • Understanding the basis for creating a valid relationship
  • Creating a one-to-one or a one-to-many relationship between tables
  • Understanding and modifying a many-to-many relationship between tables
  • Applying inner, outer and self joins
  • Applying and using referential integrity
  • Applying automatic deletion of related records
  • Relating or joining data when designing records
  • Adding fields to tables
  • Field templates

Microsoft Access Query design

  • Grouping information in a query
  • Using a crosstab query
  • Using wildcards in a query
  • Using arithmetic and logical expressions in a query

Form design

  • Using bound and unbound controls
  • Creating and editing a combo box, list box, check box and option groups
  • Inserting a data field to appear within form header or footer on the first page or all pages
  • Stacked and tabular layout controls

Report design

  • Inserting a data field to appear within report header or on footers on the first page or all pages
  • Forcing page breaks for groups on reports

Importing, exporting and linking data

  • Importing text, Excel, csv, etc documents into an Access database
  • Exporting data in Excel, txt, and other formats
  • Linking external data to an Access  database

Speaker/s

We have several highly experienced Microsoft Access trainers.

Special Offer

We usually train people from one company at once at their site where we can tailor the training to meet their needs. Alternatively, we train remotely via Zoom or Microsoft Teams.
Prices per day:
1 to 1 - £295 + VAT
2 to 4 people - £455 + VAT
5 to 8 people - £595 + VAT
Reviews
Be the first to write a review about this course.
Write a Review
We provide computer and personal development training. All our training is conducted at client site and tailor-made to meet YOUR needs. We can even work using your files if required, making the learning very relevant and quickly increasing productivity.
We are based in the London area but do have trainers in other parts of the country too.
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.