Microsoft Access Training Level 1 - On-site and Online

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

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

Beginners Microsoft Access Training Course

This beginners Microsoft Access course introduces the basic concepts of designing, building and using an Access database, and gets you started creating your first database, populating it with data and learning how to manage, organise and report upon your data. 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.

FourSquare Innovations' MS Access training courses specialise in delivering small to medium-sized group training events tailored to your particular business needs including formal instructor-led classroom training, on-the-job training, workshops, training consultancy and floorwalking to support newly trained staff. For fully bespoke learning needs we also offer a courseware writing service.

Access Beginners Training Course Prerequisites

No previous knowledge of Microsoft Access is needed to attend this course. Learners should be able to navigate their way around Windows and/or the Microsoft Office 365 environment and have an understanding of opening, closing and saving files and folders.

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.

With our Microsoft Access on-site courses our regional trainers come to your workplace throughout England, bringing the training to you regardless of whether you are in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else. This offers a really cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Hampshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding and everywhere inbetween.

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.

Microsoft Access Beginners Training Selected Topics & Outline

You can combine Beginners, Intermediate and Advanced Microsoft Access topics and agendas for a blended step-by-step training curriculum 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 Microsoft Access
  1. Understanding Database Concepts
  2. Access Database Components
  3. Introduction to Building your Access Database
     
     
• Module 2: Creating a Table
  1. Designing your first Tables
  2. Guidelines for Table Design in Access
  3. Avoiding Data Duplication
  4. Working with Unique Identifiers
  5. Avoiding Group Repetition
  6. Starting up Access
  7. Closing down Access
     
     
• Module 3: Access Menus and Navigation
  1. The Access Database Window
  2. Navigating and Using menus
  3. Working with Short-Cut Menus
  4. Working with Dialogue boxes
  5. Using the Help facility
     
     
• Module 4: Creating a Database
  1. Creating a Blank Access Database
  2. Producing an Access Table
  3. Controlling Field Properties
  4. Working with Key Fields
  5. Saving your Tables
     
     
• Module 5: Working with a Database
  1. Opening Table Objects
  2. Using Table Windows
  3. Entering Data into your Table
  4. Movement Keys for a Table
  5. Extended mode selections
  6. Changing Data
  7. Undoing your Editing mistakes
  8. Copying and Pasting Field Contents
     
     
• Module 6: Working with Records
  1. Adding Records to the table
  2. Deleting Entire Records
     
     
• Module 7: Searching and Filtering
  1. Editing Features
  2. Searching Field Values
  3. Sorting Records in Access
  4. Filtering Table Data
  5. Filtering by Form
     
     
• Module 8: Using Queries
  1. Querying Tables
  2. Composing a Query
  3. Using the Query Wizards
  4. Rearranging fields
  5. Deleting and inserting Fields
  6. Showing Fields
  7. Running a query
  8. Setting Conditions
  9. Operators and conditions
  10. Calculating in Queries
      
      
• Module 9: Working with Statistics
  1. Introduction to Statistics
  2. Grouping your statistics
  3. Criteria and Groups
     
     
• Module 10: Working with Forms
  1. Data Input Forms
  2. Creating a Form Automatically
  3. Creating a Form using Form Wizards
  4. Setting Form layout and Style with the Wizard
     
     
• Module 11: Reporting
  1. Reporting in Access
  2. Quick Reporting via AutoReport
  3. Using the Report Wizard
  4. Grouping for your Report
  5. Sorting and Summarising your Report
  6. Report Page Layout and Titling
  7. Previewing Reports
  8. Zooming and Closing the Preview
  9. Setting up Reports
  10. Options for Printing and Publishing Reports
      
      
• Module 12: Working with External Data Sources
  1. Creating a New Data Source
  2. Choosing an Existing Data Source
     
     
• Module 13: Using Merge
  1. Previewing Merged Data
  2. Error Checking the Merge
  3. Merging the Documents
  4. Filtering & Sorting Records To Merge
     
     

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

MS Access 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