Advanced Microsoft Access 2013 Training Courses

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to give delegates an insight into some of the more advanced features in MS Access 2013.

                           

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

About this course

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

Use advanced forms features
Use Access in conjunction with the Internet
Create advanced queries
Produce reports
Record and assign macros

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • Access
  • Microsoft Access
  • Produce reports
  • Assign macros
  • Forms features
  • Unmatched values
  • NOT values
  • Advanced Forms
  • Split forms
  • Macros
  • Reports

Course programme

Query Types

Creating and using a query to update data in a table
Creating and using a query to delete records in a table
Creating and using a query to save the selected information as a table
Appending records to a table using a query
Refining Queries

Showing duplicates
Showing unmatched values
Showing the highest or lowest range of values in a query
Parameter queries - allowing query input from a data prompt
Refining queries using Null and NOT values
Advanced Forms

Creating arithmetic and logical expression controls on a form
Setting sequential order of controls on a form
Creating a subform and linking it to parent
Modifying the subform to change records displayed
Split forms
Calculations in Reports

Creating arithmetic and logical expression controls in a report
Calculating percentages in a report
Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
Creating running summaries in a report
Macros

Recording a simple macro
Running a macro
Assigning or attaching a macro to a form, report, control

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Advanced Microsoft Access 2013 Training Courses

£ 295 + VAT