Microsoft Access Into | Inter | Adv

ACCESS INTRODUCTION: INSIDE ACCESS

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 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 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
Delivery

Cohort Minimum

Cohort Maximum

Number of Training Sessions

Contact Hours

Price per learner 1 to 1

150

Price per Learner

(Minimum Cohort)

£595.00

Training PringlePCS's Offer

Pringle PCS have been established since 1996 and have become one of the UK Leading Training Providers. PCS Training offer extensive IT & Business Skills training courses designed to improve and enhance learners’ skills. All courses are taught by highly experienced professional trainers Skywallker House The main Headquarters of PCS are in Sheffield at Skywalker House, S9 5AB and have three dedicated IT training rooms and two conference rooms. This facility enables PCS to provide Business Skills (People Skills) and IT training that ranges from scheduled courses to bespoke IT and company development solutions. All PCS services are offered across the entire United Kingdom to provide any company, in any industry the full solution UK Training PCS train throughout the UK at customer premises or assigned conference facilities. PCS can even bring full IT equipment that makes a standard office into a fully functional training room. PCS can also train in-house designed company programs or company procedures that would need rolling out throughout the organisation UK Training PCS train throughout the UK at customer premises or assigned conference facilities. PCS can even bring full IT equipment that makes a standard office into a fully functional training room. PCS can also train in-house designed company programs or company procedures that would need rolling out throughout the organisation

View Website

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access Into | Inter | Adv”

Your email address will not be published. Required fields are marked *

3 × 2 =