Intermediate Microsoft Access 2016 training

5.0
1 opinion
  • Course well structured and easy to follow. My objectives achieved
    |

Short course

In Twickenham

£ 295 + VAT

Description

  • Typology

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start

    Different dates available

Description

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



                              

Facilities

Location

Starts

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Starts

Different dates availableNow taking bookings

To take into account

On completion of the course delegates will have improved their skills in using Microsoft Access 2016. 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

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Opinions

5.0
  • Course well structured and easy to follow. My objectives achieved
    |
100%
4.6
excellent

Course rating

Recommended

Centre rating

Thanh Vu

5.0
23/03/2016
What I would highlight: Course well structured and easy to follow. My objectives achieved
What could be improved: Nothing.
Would you recommend this course?: Yes
Reviews gathered by Emagister & iAgora

Achievements for this centre

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 11 years

Subjects

  • Access
  • Database training
  • Design
  • Database
  • Microsoft Access
  • Text
  • Memo
  • Hyperlink
  • Currency
  • Navigation pane
  • Field templates
  • Query Design
  • Form Design
  • Report Design
  • Exporting Data
  • Excel
  • Access <br /> <br /> <br />

Course programme

Displaying the Access 2016 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 2016 database
Exporting data in Excel, txt, etc. formats
Linking external data to an Access 2016 database

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

Intermediate Microsoft Access 2016 training

£ 295 + VAT