We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.
We provide Advanced Access 2016 training, delivered at your offices in Dorset, Wiltshire, Somerset and Hampshire. Although provisional course outlines are provided below, all our training can be adapted to meet your needs.
Advanced Access 2016 Training Provisional Course Outline
Aims of the Advanced Access 2016 Training course
This Advanced Access 2016 training course aims to give delegates an insight into some of the more advanced features in MS Access 2016.
Course Objectives
On completion of the course delegates will have added to their skills in using Microsoft Access. They will be able to:
- Normalise data tables
- Use advanced forms features
- Use Access in conjunction with the Internet
- Create advanced queries
- Produce reports
- Record and assign macros
The Microsoft Advanced Access 2016 training 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 reasonable knowledge of Access 2016. Prior attendance of the Intermediate Access 2016 course would be an advantage.
Course Outline
Database Design
- Concepts of Normalisation
- Junction Tables
- Microsoft Access naming conventions
- Indexes
- Multiple Field Primary keys
- Data Validation
- Table Level Validation
- Field types
- Join types
- Lookup fields
Query Types
- Parameter queries
- Summary queries
- Joining tables in queries
- Cross Products
- Creating reverse outer joins
- Concatenation
- 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
- Backing up your database
- 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
- IIF Functions
- Calculating with Dates
- Querying multivalue fields
Advanced Forms
- Creating arithmetic and logical expression controls on a form
- Adding graphics to forms
- 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
- Creating a Switchboard form
Access 2016 and the Internet
- How Access 2016 works with the Web
- Hyperlinks
- Exporting database object to HTML
- Importing or linking to an HTML file
Calculations in Reports
- Applying sorting and grouping to 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
- Creating an Autoexec macro
Database Management
- Analysing Performance
- Compacting and Repairing Databases
- The Database documenter
- The Database splitter
Microsoft Access training Dorset locations include:
| Bournemouth | Poole | Sherborne | Shaftesbury |
| Gillingham | Christchurch | Ferndown | Wimborne |
| Blandford Forum | Dorchester | Weymouth | Verwood |
| Merley | Wareham | Bridport | Lulworth |
| St Leonards |
Microsoft Access training Wiltshire locations include:
| Salisbury | Swindon | Trowbridge | Chippenham |
| Devizes | Marlborough | Warminster | Tisbury |
| Melksham | Westbury | Corsham | Amesbury |
| Tidworth | Bradford-on-Avon | Bulford Camp | Porton |
| Calne | Highworth | Wootton Bassett | Wroughton |
| Malmesbury |
Microsoft Access training Hampshire locations include:
| Southampton | Winchester | Portsmouth | Basingstoke |
| Andover | Petersfield | Ringwood | Havant |
| Gosport | Farnborough | Aldershot | Romsey |
| Eastleigh | Fleet | Alton | Fareham |
| Totton | Hedge End | Stubbington | Bishop’s Waltham |
| Bursledon | Denmead | Hook | Horndean |
| Blackfield |
Microsoft Access training Somerset locations include:
| Bath | Yeovil | Wincanton | Frome |
| Taunton | Weston-Super-Mare | Midsomer Norton | Shepton Mallet |
| Radstock | Paulton | Bridgwater | Burnham-on-Sea |
| Chard | Cheddar | Clevedon | Crewkerne |
| Glastonbury |
We have also trained home-based businesses and users in some of the Dorset, Wiltshire and Hampshire villages, so please do get in touch.