IT Training | Microsoft Access | Summary

Microsoft Access is 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 student 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 4 stage program of courses that shows the main areas to start mastering this industry standard database application.


Title: Inside Access
Course Code: ITD04 | Duration: 1 Day | Level: Introduction Part 1
  Course Description: The first stage aims to give users the knowledge and confidence to start using and understanding access databases. The stage 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.
  Click here for more information.
   
Title: Relationships
Course Code: ITD05 | Duration: 1 Day | Level: Introduction Part 2
  Course Description: Anyone can use a wizard to create a database but how do you amend what has been created? Even though part 1 covers topics such as “1 to Many”, this course is based on how to set up and start using a working relational database. The course concentrates on different types of Relational joins 1 to 1, 1 to many and many to many.
  Click here for more information.
   
Title: Queries & Reports
Course Code: ITD06 | Duration: 1 Day | Level: Intermediate
  Course Description: 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.
  Click here for more information.
   
Title: Advanced
Course Code: ITD07 | Duration: 1 Day | Level: Advanced
  Course Description: 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.
  Click here for more information.
   
Title: Train The Trainer: Access Masterclass
Course Code: ITM05 | Duration: 5 Days | Level: Masterclass
  Course Description: This course will give you all the Skills, Tools and Documentation to become an Advanced Access Trainer. Once untaken this course you will have skills, knowledge and confidence to be able teach to the highest level, instead of paying an outgoing cost to sub-contractors trainers save your company money and increase performance within you team.
  Click here for more information.

Telephone: 0114 2813350 | Email: Info@pringlepcs.co.uk