Microsoft Access Training Level 3 - Classroom Learning

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

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

Microsoft Access Advanced Training Course

This advanced Microsoft Access course extends upon skills learnt during the intermediate course and is suitable for those needing to harness the power of some of the software's more sophisticated functionality, including Pivot Tables and Charts, joining tables, working with Macros and Reporting. Our Microsoft Access courses are available on-site at your workplace or as live virtual classroom courses.

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

Microsoft Access Advanced Training Course Prerequisites

In order to attend this course you should already have Microsoft Access skills and knowledge equivalent to our Access Intermediate training course.

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.

Our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Microsoft 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.

Back to top

Advanced Microsoft 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 PivotTables and PivotCharts in Microsoft Access
  1. Creating a PivotTable
  2. Modifying and editing a PivotTable
  3. Working with a PivotChart
     
     
• Module 2: Creating Advanced Forms in Microsoft Access
  1. Designing a form based on joined tables
  2. Automating data entry
  3. Grouped control
  4. How to improve the user interface in Microsoft Access
  5. Designing a subform
     
     
• Module 3: Working with Macros in Microsoft Access
  1. Create and run macros to automate tasks
  2. Attaching macros to the events of database objects
  3. Creating more advanced Macros in Access
  4. Producing interactive macros
  5. Producing decision-driven macros
  6. Using AutoKeys and AutoExec macros
     
     
• Module 4: Integrating Access with the Internet
  1. Adding and editing hyperlink fields
  2. Working with data access pages
     
     
• Module 5: Considerations for Managing your Access Databases
  1. Working with database utilities to optimise resources
  2. Secure and backup data with database replication
  3. Security Fundamentals in Microsoft Access
  4. Protecting your databases

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 course overview
• Intermediate MS Access course overview
• Intermediate MS Access course extended topics- Relational Databases
• Advanced MS Access course overview
• MS Access training main page

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 (Microsoft Access training Leeds, West Yorkshire)

Angela came across so I really understood the subject [...] I got a lot out of today
J. Kennedy, Davis Derby (Microsoft Access training Derby)

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

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

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

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

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)

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 (Advanced MS Access Training Coventry)

This was excellent.
H Metcalfe, Vecoplan Ltd (MS Access Training Birmingham, West Midlands)

Very comprehensive, covered everything expected and very easy to approach with queries. Thouroughly enjoyed it.
A Dugdale, Newlyn Plc (Advanced MS Access Training Northampton, Northamptonshire)

I would recommend FSI for an advanced [..] course to others. instructor combined aspects of database design, development and coding in a very coherent manner.
M Orr, FEC Services (Advanced MS Access Training Coventry, West Midlands)

Course was excellent and has helped with all my needs.
A Brewster, SLR Consulting (MS Access Training Nottingham, Nottinghamshire)

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

---

MS Access Trainers are available in the following 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.

Back to top

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