MS Access Intermediate Course

by PCWorkshops

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more.

£580

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

2 Days

Course Details

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

Session 1: Database Concepts

  • Tables
  • Referential Integrity
  • Table Relationships

 

Session 2: MS Access Queries

  • Select Queries, selecting columns and using where clauses
  • Multiple table queries, joining tables using query design
  • In null, is not null
  • Wildcards
  • Totals

 

Session 3: MS Access Queries

  • Expression queries
  • Action queries:
  • Make Table Queries to create new queries from existing query or tables,
  • Queries to insert new records
  • Append queries,
  • Update queries,
  • Delete queries.

 

Session 4: MS Access Importing Data

  • Importing Data
  • Exporting Data
  • Linking Data

 

Session 5: MS Access Forms

  • Linking Data Creating Forms
  • Creating forms, Form wizards
  • Creating a Navigation Form

 

Session 6: MS Access Reports

  • Brief overview of Creating and viewing MS Access reports
  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth

Check out more MS Access courses in UK

Acuity Training Logo

Microsoft Word Training

Learn how to produce stunning documents quickly with Microsoft Word's powerful tools.

by Acuity Training
  • Price
  • Start Date
  • Duration
Glide Training Logo

Microsoft Visio Training

We can provide Microsoft Visio training to users of all experience levels. Our courses help delegates to build the skills needed to create professional-looking diagrams which can help get their point across and communicate more effectively through visual media.

by Glide Training [Claim Listing ]
SureSkills Logo

Microsoft PowerPoint Training

This PowerPoint Advanced course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features.

by SureSkills [Claim Listing ]
Happy Logo

Microsoft Visio Essentials

This one-day training course has been designed to give you all the basics of Visio, so you can start mapping process flow diagrams and creating organisation charts, network diagrams and scaled diagrams (such as room layouts).

by Happy [Claim Listing ]
Systematix Training Logo

Word (Introduction)

This course is intended to help all novice computer users get up to speed with Word quickly. We will cover different features of the interface, show users how to create a basic document, and introduce users to most important Word tools

by Systematix Training [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy