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

Reviews

There are no reviews yet.

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

Your email address will not be published.