Microsoft Access Training Level 3 - Classroom Learning
Introduction | Virtual Courses | On-site Courses | Course Outline | Reviews | Locations
Your learning needs are at the ❤ 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'd rather that your team learns remotely, these small-group Microsoft Access courses are also available as live virtual, interactive sessions from the comfort of your own office or workplace. These instructor-led courses are taught via MS Teams video conferencing.
Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that virtual classroom delivery has some advantages over traditional face-to-face learning.
If you're looking for local training, then you can't get closer to your doorstep than you can with virtual learning.
Our virtual learning Microsoft Access courses cater for classes of up to 10 and your learners benefit from full and immersive interaction with the trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is enriched by features such as live chat, private chat, and sharing screens and documents.
Our virtual classroom Microsoft Access courses cost £550.00 plus VAT p/day inclusive up to 5 delegates. More learners can be added up to a limit of 10 charged at £50.00 plus VAT per person p/day. Courseware will be provided electronically.
☆ ☆ ☆ ☆ ☆ Five Star Review
Very easy to follow.
Microsoft Access Training Peterborough, Cambridgeshire
More like this...
On-site Microsoft Access Courses
Our closed courses for Microsoft Access are delivered as private classes for your learners offering more flexibility than off-the-shelf courses and topics can often be tailored to meet your particular learning needs.
Our trainers are inspirational subject experts and software champions who promote enthusiastic adoption of Microsoft Access amongst their trainees. Before the start date they'll discuss your team's training goals with you, whether they're setting off as novice, intermediate or advanced users.
Our Microsoft Access Trainers are:
Inspirational subject experts with a wealth of experience, proven track records and excellent feedback.
Our Closed Microsoft Access Courses are:
Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.
Education is Our Passion:
Over 24,000 students trained across almost every industry, sector and background.
Microsoft Access Training Delivery Method for Closed Courses for Businesses
- Instructor-led Microsoft Access training provided in-person with engaging step-by-step demos, lessons and hands-on exercises.
- Dynamic and interactive Microsoft Access courses with ample time for questions and answers.
- The Personal Touch: Expert tuition, tailored to your team's knowledge level and learning needs, and covering Microsoft Access database skills that your trainees need most.
- Private, corporate Microsoft Access training with a limit of 10 participants to ensure personalised attention.
- Can be run as one or more courses, or as a training rollout bringing entire departments and organisations up to the benchmark of Microsoft Access knowledge that you require.
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.
Actual course content may vary, depending upon your learning requirements.
- Module 1: Introduction to PivotTables and PivotCharts in Microsoft Access
- Creating a PivotTable
- Modifying and editing a PivotTable
- Working with a PivotChart
- Module 2: Creating Advanced Forms in Microsoft Access
- Designing a form based on joined tables
- Automating data entry
- Grouped control
- How to improve the user interface in Microsoft Access
- Designing a subform
- Module 3: Working with Macros in Microsoft Access
- Create and run macros to automate tasks
- Attaching macros to the events of database objects
- Creating more advanced Macros in Access
- Producing interactive macros
- Producing decision-driven macros
- Using AutoKeys and AutoExec macros
- Module 4: Integrating Access with the Internet
- Adding and editing hyperlink fields
- Working with data access pages
- Module 5: Considerations for Managing your Access Databases
- Working with database utilities to optimise resources
- Secure and backup data with database replication
- Security Fundamentals in Microsoft Access
- Protecting your databases
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:
Our trainers can visit your organisation in any of the following locations:
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
0844 493 3699
email us