Print PDF
Print Course Overview

Bookmark and Share

Microsoft: Access

Microsoft Access Training CourseAccess is a great tool for database development if used correctly. PCS has a dedicated Solutions team that provide commercial systems for many international clients. Utilising the knowledge and skills of our PCS Solutions team we offer 5 stages of training which will give you the tools you need to be able to quickly master this industry standard database application.  View Microsoft Access Subject Details

Stage 2: Relationships ITD05

Scheduled Training Courses

 22/05/2012  21/06/2012  23/07/2012  21/08/2012  21/09/2012  22/10/2012  21/11/2012  21/12/2012

This Training course can also be run on request as a One to One or a Classroom Booking.

Overview

Anyone can use a wizard to create a database but how do you amend what has been created? Even though Stage 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.

  • 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 (Pop-up Forms/ Toolbars)
Image showing a Database Entry Form
Using Microsoft Access to Create a Film Database Entry Form

 

 

Related Training Courses

Stage 1: Inside Access ITD04
Stage 2: Relationships ITD05
Stage 3: Queries And Reports ITD06
Stage 4: Forms that Work ITD07
Stage 5: Access Masterclass ITD08

Find Training Courses

Search The Pringle PCS Training Brochure View All Training Courses

Book This Training

CALL 0114 281 3350

Or email us

sales@pcs-limited.com

Single Booking £175.00

£105.00 40 % Discounted Price
Normal Price £175.00
* Discounts Apply When Booking More Than One Person On The Same Scheduled Course ex vat  
One delegate in a mixed group at Skywalker House

One To One

Price £395.00 ex vat  
One delegate one trainer either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House

Company Classroom

Price £445.00 ex vat  
A dedicated trainer for your company either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House