IT Training | Microsoft Access | Advanced
Title: 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
Telephone: 0114 2813350 | Email: Info@pringlepcs.co.uk