Microsoft Access Training Courses Liverpool, Manchester, Preston, Lancaster, Bolton, Warrington, Barrow-in-Furness, Chester, Stockport, Ellesmere Port & across mainland UK

Virtual Courses | On-site Courses | Course Outline | Reviews | Locations

Your learning needs are at the ❤ heart of what we do.

Intermediate Microsoft Access Training Course

This intermediate Microsoft Access course introduces learners to building relational databases or Database Apps (depending on your version of Access). It is intended for students who already have knowledge equivalent both to a beginners Microsoft Access course.

Our Microsoft Access trainers cover all of mainland UK including the North West and Merseyside delivering MS Access training in Liverpool, Manchester, Preston, Lancaster, Bolton, Warrington, Barrow-in-Furness, Chester, Stockport, Ellesmere Port, Birkenhead, Wallasey, Runcorn, Macclesfield, Crewe and surrounding areas.

Microsoft Access versions covered in our training courses include MS Access 365, MS Access 2021, MS Access 2019, MS Access 2016 and MS Access 2013.

Live Virtual Classroom Microsoft Access Courses

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Microsoft Access courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These Online instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

Our virtual learning Microsoft Access courses cater for groups of up to ten people and your learners benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

Our realtime virtual classroom Microsoft Access courses are charged out at £550.00 plus VAT per day inclusive up to 5 delegates. Further learners can be added up to a maximum of 10 charged out at £50.00 plus VAT per person per day. Courseware will be provided electronically.

You can find out how to set up Microsoft Teams for a live Online virtual course here (Virtual Learning with MS Teams).

On-site Microsoft Access Courses

Our closed courses for Microsoft Access are delivered as private courses for your learners offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your particular learning needs.

Access is one of the most powerful and useful of the Microsoft Office applications, but also often the one with which people can struggle the most, and that they find the most frustrating to work with. In fact, having team members and colleagues that are confident and proficient with Microsoft Access can not only increase productivity and efficiency in the workplace, it can even be good for morale.

Our mobile trainers understand that helping their students to work more effectively is not just a business-oriented goal, it is also empowering for the individual students themselves. As such, our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Access among those they teach. Before the start date they will discuss with you the goals and objectives of the training and those skill-sets that your team need the most whether they are starting as novice, intermediate or advanced users.

Microsoft Access Training Delivery Method for Closed Courses for Businesses

• Instructor-led Microsoft Access training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Dynamic and interactive Microsoft Access courses with plenty of time for questions and answers.
  
  
• The personal touch: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering Microsoft Access database functions, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Private, corporate Microsoft Access training for small group sizes with a maximum of 10 learners on any course.
  
  
• Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Microsoft Access knowledge that you require.

Intermediate MS Access Training Selected Topics

You can combine Beginners, Intermediate and Advanced Microsoft Access topics for a blended training programme of up to four days in duration.

We specialise in delivering flexible training programmes and the actual course content, topics and syllabus taught will often vary depending upon your learning requirements and upon the version of the software taught.

• Module 1: Introduction to Relational Databases
  1. What is a Relational Database?
  2. Creating Table Relationships
  3. Applying Referential Integrity
  4. Understanding Grouping
  5. Sorting and Summarising your Data
     
     
• Module 2: Working with Related Tables
  1. The LookUp Wizard
  2. Changing LookUp fields
  3. Inputting Data to Related Tables
  4. Understanding Grouping
  5. Sorting and Summarising your Data
     
     
• Module 3: Setting Data Entry Rules
  1. Input Masks
  2. Setting Properties
  3. Setting Validation Rules
     
     
• Module 4: Advanced Query Features
  1. Joining Tables
  2. Calculated Fields
  3. Action Queries
     
     
• Module 5: Creating Advanced Queries
  1. Summarise Values and Group Values
  2. Crosstab Queries
  3. Parameter Queries
     
     
• Module 6: Advanced Form Design
  1. Graphics
  2. Calculations
  3. Combo Boxes
     
     
• Module 7: Advanced Reporting
  1. Customised Headers and Footers
  2. Calculations
  3. Combo Boxes
  4. Calculated Values
  5. Sub-reports
     
     

Back to top

MS Access Training Reviews

I think the virtual method of training worked really well. We could all hear each other, connection worked fine and the session flowed really well. Thoroughly enjoyed the session. Took lots of learning points away and could see throughout were we could apply what we learned to our own databases. THANK YOU.
C McDonough, NHS North West virtual classroom (Microsoft Access training Blackpool Lancashire)

Relevant to what we need for the future.
K McLean Emerson, Beginners to Intermediate (Microsoft Access Training Leicester)

Covered all basic aspects and I found it enjoyable and interesting L Williams, Tetrosyl Beginners (Microsoft Access training Nuneaton (Nuneaton and Bedworth), Warwickshire)

Superb. Very informative. Good intro to Access.
M Powell, Tetenal (Introduction to Microsoft Access Training Leicester)

Excellent introduction to Access. Covered more than expected for a 1st training session.
Unsigned, FPS Distribution (Microsoft Access Beginners Training Stratford-upon-Avon, Warwickshire)

Very informative. Our database is already well underway.
M Olsen, Hankook Tyres (Beginners to Intermediate Microsoft Access Training Daventry Northants)

Thank you for the excellent training.
J Rapel, Nifty Lift (Intermediate Microsoft Access Training Barnsley)

Clear objectives. Good materials. Excellent instructor.
Unsigned, Pirelli (Microsoft Access Training Burton-on-Trent, Staffordshire)

Great introductory course!!
C Gilpin, National Australia Bank Group (Beginners Microsoft Access training)

Very patient, excellent training
S Palfreeman, Zeeco Europe (Microsoft Access training Peterborough)

Very Flexible Training - not stuck to course notes.
A Lavan, H. W. Architectural (Microsoft Access training Huddersfield)

The training was very good - learnt lots of very useful things and it was great to have training on such a personal level i.e. training that was directly relevant to what we needed.
M Levison, Lansinoh (Microsoft Access Training Leeds, West Yorkshire)

Great! simple without being patronising.
P Aron, CPO Media (Microsoft Access beginners training Grimsby)

Very enjoyable day. The course was very well structured & well paced. Angela, really knew her subject very well and put everything across in a very clear and confident manner. I acheived everything I wanted to today.
L. Read, Davis Derby (Microsoft Access beginners training Derby)

found it really useful, professional, and a really good pace (probably one of the best-run computer training courses I've been on)
L. N Taylor, Agriculture and Horticulture Development Board (Microsoft Access training Birmingham, West Midlands)

This was excellent
H Metcalfe, Vecoplan Ltd (Microsoft Access training Birmingham, West Midlands)

Trainer did very well in responding to a very diverse set of requirements from a very a-typical group of trainees. Gave us a lot of useful pointers in solving specific problems.
A Price, FEC Services (MS Access Advanced Training Coventry)

Liked the style of teaching, found easy to understand and the trainer very helpful.
M. Richards, Ashfield Homes (Advanced Microsoft Access training Mansfield, Nottinghamshire)

---

Back to top

Access Course Levels: training courses are available for beginners, intermediate, and advanced users of Microsoft Access

Selection of MS Access course topics

• Beginners MS Access training course overview
• Intermediate Access training course overview
• Intermediate MS Access training - Relational Databases
• Advanced Access training course overview
• Access training course main page

Course Locations:

We have mobile trainers that can visit your company in any of the following towns and cities in England. These are specialist, versatile educators used to delivering flexible learning programmes in a closed course environment.

Access Courses North West of England Region

Access Courses Lancashire, Greater Manchester and Merseyside: Bolton, Lancaster, Liverpool, Manchester, Preston, Warrington, Altrincham, Barrow-in-Furness, Blackburn, Oldham

Access Courses Cheshire and Wirral: Birkenhead, Chester, Stockport, Ellesmere Port, Knutsford, Wallasey, Runcorn, Macclesfield, Crewe

Access Courses North East of England Region

Access Courses Northumberland and Tyneside: Alnwick, Newcastle-upon-Tyne, Morpeth, Hexham, Berwick-upon-Tweed

Access Courses County Durham: Durham, Sunderland, Stockton-on-Tees, Darlington, Gateshead, Washington, Hartlepool

Access Courses Yorkshire and the Humber Region

Access Courses West Yorkshire: Leeds, Bradford, Halifax, Huddersfield, Brighouse, Wakefield, Shipley, Dewsbury, Bingley

Access Courses North Yorkshire: York, Harrogate, Scarborough, Whitby, Northallerton, Middlesbrough

Access Courses South Yorkshire: Sheffield, Barnsley, Doncaster, Rotherham, Worksop

Access Courses Humberside / East Riding of Yorkshire: Kingston-upon-Hull, Bridlington

Access Courses East Midlands Region

Access Courses Lincolnshire: Lincoln, Market Rasen, Grantham, Sleaford, Boston, Cleethorpes, Scunthorpe, Grimsby

Access Courses Northamptonshire: Northampton, Corby, Kettering, Wellingborough

Access Courses Nottinghamshire: Nottingham, Mansfield, Worksop, Newark-on-Trent, Retford, Southwell, Long Eaton, Alfreton

Access Courses Derbyshire: Derby, Chesterfield, Ilkeston, Swadlincote, Buxton, Matlock, Ashbourne

Access Courses Leicestershire: Leicester, Loughborough, Hinckley, Melton Mowbray, Coalville, Lutterworth

Access Courses West Midlands Region

Access Courses West Midlands county & Warwickshire: Birmingham, Coventry, Nuneaton, Rugby, Solihull, Stratford-upon-Avon, Warwick, Wolverhampton, Walsall

Access Courses Staffordshire: Cannock, Lichfield, Stafford, Stoke-on-Trent

Access Courses Worcestershire: Dudley, Evesham, Kidderminster, Stourbridge, Halesowen, Malvern, Worcester

Access Courses East of England Region

Access Courses Cambridgeshire: Cambridge, Peterborough, Wisbech, Ely, March, Whittlesey, Chatteris, Linton

Access Courses Norfolk: Norwich, Great Yarmouth, King's Lynn, Dereham, Cromer, Hunstanton

Access Courses Suffolk: Ipswich, Bury St. Edmunds, Lowestoft, Felixstowe, Sudbury, Haverhill, Bungay

Access Courses Essex: Chelmsford, Basildon, Romford, Southend, Colchester, Harlow, Brentwood, West Ham

Access Courses Hertfordshire: Hertford, Watford, St. Albans, Hemel Hempstead, Stevenage, Hatfield

Access Courses Bedfordshire: Bedford, Luton, Dunstable, Leighton Buzzard, Biggleswade, Sandy

Access Courses Greater London Region

Access Courses London Central: London, Camden, Hackney, Hammersmith, Haringey, Islington, Kensington, Chelsea, Lambeth, Southwark, Wandsworth, City of Westminster

Access Courses London East: Bethnal Green, Bow, Chingford, East Ham, Hackney, Manor Park, Plaistow, Stratford, Victoria Dock, Walthamstow, South Woodford

Access Courses London South West: Chelsea, Clapham, Earls Court, South Kensington, Stockwell, West Brompton

Access Courses Battersea: Barnes, Mortlake, Putney, Streatham, Wandsworth, Wimbledon, West Wimbledon

Access Courses Paddington: Chiswick, Ealing, Hammersmith, Kensington, Maida Vale, North Kensington, Notting Hill, Shepherds Bush, West Ealing, West Kensington

Access Courses South West of England Region

Access Courses Somerset: Taunton, Bath, Bridgwater, Weston-super-Mare, Yeovil, Wells, Glastonbury

Access Courses Dorset: Dorchester, Bournemouth, Poole, Sherborne, Shaftesbury, Wimborne Minster, Weymouth

Access Courses Wiltshire: Trowbridge, Salisbury, Swindon, Chippenham, Devizes, Marlborough, Warminster

Access Courses Gloucestershire: Gloucester, Bristol, Cheltenham, Stroud, Cirencester, Tewkesbury

Access Courses South East of England Region

Access Courses Berkshire: Reading, Slough, Bracknell, Maidenhead, Newbury, Windsor, Wokingham

Access Courses Buckinghamshire: Aylesbury, Milton Keynes, Buckingham, High Wycombe

Access Courses Oxfordshire: Oxford, Abingdon, Banbury, Witney, Bicester, Henley-on-Thames, Carterton, Thame

Access Courses Hampshire: Winchester, Southampton, Portsmouth, Basingstoke

Access Courses Kent: Maidstone, Canterbury, Bromley, Rochester, Margate, Folkestone, Dover, Greenwich

Access Courses East and West Sussex: Chichester, Brighton, Worthing, Crawley, Hastings, Eastbourne, Bognor Regis, Horsham

To book a training course simply call 0844 493 3699, or email info@foursquaretraining.co.uk

Back to top