Microsoft Access


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: ITD04-5 | 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: ITD06 | 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: ITD07 | 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

BESPOKE IT TRAINING DAY AT OUR OFFICES OR CLIENT’S SITE


This training is given exclusively for your company only either here at PCS or at your own premises. (Evening and weekend dates are also available on request)

All training courses can be tailored using own company data or reslove specific probelms which staff may have to face. With all besopke training topics can be taken and combined from differnt stages or combine more than one course together

BESPOKE IT SURGERY DAY – ON-SITE AT CLIENT’S PREMISES:

As you know, losing a whole day to training can prove to be an expensive investment. An individual may not need a full day's training if there are only a few elements of a program they really need to know or simply that they need refreshing on basic skills and are too embarrassed to say - we have a solution to the problem – Our IT Surgery!

We have IT Masters who can teach and consult to the highest level and provide solutions for any IT working problem. With these skills and experience to draw on, we have created a unique service whereby your employees can receive specific, individual training without the loss of a full working day.

We can turn one of your rooms into an ‘IT surgery' where employees can turn-up for scheduled appointments or we can move round Desk to Desk to help teach and solve problems with in your organisation

BOOKING & EVALUATING APPOINTMENTS

Our experienced IT Training team will circulate amongst your employees and identify from each member of staff what their particular IT problems and needs are. Our team will quickly evaluate the time needed for the IT Master to show and teach the appropriate tasks on the surgery day

IT BESPOKE SURGERY DAY

Our IT Master will be based on-site in any available room awaiting IT problems or training requirements. On-site Training hours can be structured to fit your business operation, Our training surgery day is a 6 hour day but the start time can be flexible to suite your company working hours i.e. Surgery Day can start at 7.30am or stay open to 7.30pm if required. This unique service is the most efficient way for your company to train and increase productivity whilst keeping your training costs and lost time to an absolute minimum.

Online Live Training


All Of PCS Training Course can now be taught remotely from your office or even from home. Pringle PCS will give you Log in details which will allow you or your team to join the Live Training Session.

Training Requirments

With all live online training PCS will give a free 30 minutes setup and test to show how the remote learning will work. We test Internet speed, connection and show how easliy it is to join the live trainig.
Every delegate would need to have a working Camera and Micpohone to be able to interacte with the class. With Live Online Training Pringle PCS stronlgy recommed having Duel Screens or access to Tablet.

Company Classroom and 1-1

Live Online Training can be taught 1-1 or upto a classroom of 8 and all courses can be tailored to own company requirments

Duration

A Live Online Training schedule session is in total upto 6 hours of Training with added Breaks.

Prices


IT & Business Skills Scheduled Courses


All Scheduled courses are held at Pringle PCS Training & Conference Centre.

IT & Business Skills Scheduled Courses
Price
Online Single Booking
£120
Per Person
Online Additional / Subsequent Delegate Booking On The Same Day Scheduled Online Course
£75
Per Person
Single Booking Scheduled Course at Skywalker House
£150
Per Person
At Skywalker House Additional / Subsequent Delegate Booking On The Same Day Scheduled at Skywalker House
£90
Person
Online One To One
£345
One To One: Client Site or Skywalker House
£395

IT & Business Skills Company Classroom


This training is given exclusively for your company only, either here at PCS or at your own premises. (Evening and weekend dates are also available on request).


Company Classroom Standard & Premium
Individual Days: Online (Max 8 Delegates:)
£495
Individual Days: PCS Or Client Site (Max 8 Delegates)
£595
Individual Days: PCS Or Client Site (Max 12 Delegates)
£695
Bespoke IT & Business Skills Course |Team Building | Surgery On-site at Client’s Premises
£795
Computer Hire and Setup
£10
Per PC
Bespoke Database Development On-site at Client’s Premises
£695

Access Online Quizzes

<

Copyright © 2020 | All Rights Reserved Pringle Computer Systems Limited