Microsoft Access Training Level 2 - Classroom Learning

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

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

Intermediate Microsoft Access Training Course

This intermediate Microsoft Access course focusses upon some of the more sophisticated techniques for building databases including working with forms, fields, controls and conditional formatting and is intended for those who have already attended a beginners course, or who have equivalent knowledge of (and competency with) the software. 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 Intermediate Training Course Prerequisites

In order to attend this course you should already have basic Microsoft Access skills and knowledge equivalent to our Microsoft Access Beginners 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.

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.

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.

Back to top

Intermediate 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: Microsoft Access Table Datasheets
  1. Rearranging Columns
  2. Setting Column Width
  3. Row Height
  4. Freezing Columns
  5. Hiding Columns
  6. Access Font Properties
  7. Access Cell Properties
     
     
• Module 2: Data Input Forms
  1. Creating Access Forms Automatically
  2. Creating Access Forms using Form Wizards
  3. Selecting Fields for the Form
  4. Form layout and Style in the Wizard
  5. Creating Access Forms Manually
  6. Data entry and Edit Using Forms
     
     
• Module 3: Microsoft Access Form Design Screen
  1. Form Bands
  2. Editing Grids
  3. Selecting Controls
  4. Colour, Border & Fill Properties
  5. Field List and Control Name Properties
  6. Access Toolbox Drawing Tools
     
     
• Module 4: Fields and Controls
  1. Adding Fields
  2. Calculated Fields
  3. Changing the Control Type
  4. Manipulating Controls
  5. Stacking Controls
  6. Aligning Controls
  7. Spacing Controls
  8. Grouping Controls
  9. Changing Control Properties
  10. Setting Default Control Properties
  11. Copying Control Properties
      
      
• Module 5: Conditional Formatting
  1. Page Breaks
  2. Tab Order
  3. Viewing the Form
  4. Saving the Form
  5. Form AutoFormats
  6. Customising the Autoformat
     
     

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

---

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 (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)

---

Back to top

Selection of MS Access course topics

• Beginners MS Access course overview
• Intermediate MS Access course overview
• Advanced MS Access course overview
• Intermediate MS Access course extended topics- Forms in MS Access
• MS Access training main page

Other Microsoft Office Training Courses:

-- Microsoft Excel Training
-- Microsoft Word Training
-- Microsoft PowerPoint Training
-- Microsoft Outlook Training
-- Microsoft 365 Training
-- Microsoft Project Training
-- Microsoft Visio Training

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

Back to top