Microsoft Accessis one of the world’s most popular database management solutions which allow companies to store, analyse and sort data. Microsoft Access is a relational database engine that can have a graphical user interface called forms. These forms can be used to allow a user to input, find, update or delete data and more importantly print detailed formatted reports.

Many companies have databases created in Access however they have problems improving, updating or amending their databases; with this PCS course the user will gain the knowledge and confidence needed to use the program efficiently and more importantly with the Support from PCS, we will be able to help the delegate to start creating or fine tune their own internal databases. PCS has a dedicated Solutions team that provides commercial systems for many international clients. With their years of experience and knowledge PCS have created a 3 stage program of courses that shows the main areas to start mastering this industry standard database application.

Access Introduction: Inside Access

Course Code: ITDA01 | Duration: 1 Day | Level: Introduction

The first level aims to give users the knowledge and confidence to start using and understanding access databases. This course explains the differences between flat and relational database with primary and foreign keys this will allow the user to learn and understand database structures and start producing linked Tables – Queries – Forms – Reports. Even people with previous Access experience will gain invaluable, practical knowledge from the experience and expertise of our PCS trainers.

Course Requirements

No previous experience of Microsoft Access is required however the delegate should have knowledge in basic computer skills i.e. how to use a mouse and keyboard.


Course Content

• Relational Databases (1-1 / 1-Many / Simple Working Relationships)
• Creating (List Boxes / Combo Boxes / Combo Box Queries)
• Creating Forms (Tabular / Columnar / Sub Forms)
• Importing & Exporting (Excel / Other Databases)
• Queries (Forms Using Queries)
• Reports (Using Queries / Group)
• Switchboard (Pros & Using Wizard / PCS Switchboard)
• Professional Database (Popup Forms / Toolbars)
• Problem Solving Workshops
• Question and Answers

Microsoft Access Intermediate: Queries & Reports

Course Code: ITDA02 | Duration: 1 Day | Level: Intermediate

This course is aimed at users that have attended the previous stages or who are very experienced and understand Primary and Foreign Keys (1 to Many). This course is perfect for people needing to question, append, delete data and produce professional reports on an existing database.

Course Requirements

The delegate needs to have attended the previous stage of the Access course at Pringle PCS or at least, have the equivalent working knowledge. Delegates must understand primary & foreign Keys.


Course Content

• Type (Select / Delete / Append / Make Table Query / Crosstab)
• Total Command (Group / Average / Sum / Count / Max / Min)
• Find Duplicates & Amending Existing Broken Queries
• Multiple Table Queries (Converting Into A Flat File Mail Merge)
• Reports (Multiple Tables & Queries Reports)
• Summarise Reports (Group & Totals)
• Problem Solving Workshops
• Question and Answers

Microsoft Access Advanced

Course Code: ITDA03 | Duration: 1 Day | Level: Advanced

Creating user-friendly forms is sometimes very hard to achieve. This course uses all the experience from the PCS Solutions team by showing all the possible and impossible solutions. Introducing Macros and subforms from queries.

Course Requirements

• The delegate needs to have attended the previous stage of the Access course at Pringle PCS or at least, have the equivalent working knowledge. Delegates must understand primary & foreign Keys.



Course Content

• Relational Databases (1-1 / 1-Many / Working Relationships)
• Sub Forms (Standard Sub Forms / Queries Sub Forms)
• Advanced Queries (Multiple Tables / Embedding SQL Queries)
• Expression Builder (Queries / Commands)
• Problem Solving (Access Limitations / Breaking Rules)
• Introducing Macros (Run Command / Refresh, Set Value / Open / Run)
• PCS Development Tricks (Documentation / Understanding A Database)
• Workshop
• Problem Solving Workshops
• Question and Answers