We generally train face-to-face at client site. We also offer remote training, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.
Archway Computer Training provides Advanced Access 2024 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.
| Number on course | Price per day |
|---|---|
| 1 - 1 training | £325 + VAT |
| 2 - 4 people | £525 + VAT |
| 5 - 8 people | £675 + VAT |
Advanced Access 2024 Training Provisional Course Outline
Aims of the Advanced Access 2024 Training course
This Advanced Access 2024 training course aims to give delegates an insight into some of the more advanced features in MS Access 2024.
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 2024 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. Prior attendance of the Intermediate Access 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
- Queries 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
- 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 and the Internet
- How Access 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
To request further details of any of our courses, or to make a booking, please contact us by ringing 01747 820396 or 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.
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 |
Wiltshire Microsoft Access training 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 | AldershotRomsey | |
| Eastleigh | Fleet | Alton | Fareham |
| Totton | Hedge End | Stubbington | Bishop’s Waltham |
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.