Please ensure Javascript is enabled for purposes of website accessibility

Microsoft Access Intermediate

Square One

This course is delivered by Square One
Online with Tutor

About this course

This course is designed for people who want to discover more about the features and operations in a Database so that they become more efficient when manipulating and analysing data. The course quickly takes you from beginner level to more advanced topics. It is suitable for existing users of Databases who wish to build on their knowledge, or for those who have completed our Level 1 course and wish to progress further. 

Topics covered:

  • Overview of Databases; Recap and Overview of Level 1
  • Advanced Table Design; Attachment Fields; Multiple Value Fields; Lookup Fields; Advanced Field Properties Including Input Masks; Multiple Field Primary Keys; Multiple Field Indexes; Using the Documenter
  • Relational Concepts; Relational Concepts and Rules; Data Structure Principles; Types of Relationship; Referential Integrity; Relating Tables
  • Multiple Tables and Forms; Using a Combo Box In Forms; Combo Box Properties; Lookup Properties; Creating Forms with Sub Forms; Editing Sub Forms; Tabbed Sub Forms; Embedding Sub Forms Using Drag and Drop
  • Advanced Select Queries; Filter By Form; Advanced Filter/Sort; Convert Filter to Select Query; Duplicate Records Query; Unmatched Records Query; Working with Multiple Tables; Understanding Query Join Types; Concatenating Fields; Calculations in
  • Queries; Using String Functions; Using Date Functions; Using the Immediate If Function; Using Wildcards and Parameters Advanced Reports; Working with Multiple Tables; Concatenating Fields; Date and Time Functions; String Functions; Custom Styles

Prerequisites

Delegates who are existing users of Databases who wish to build on their knowledge, or for those who have completed our Level 1 course and wish to progress further.

Course length:

1 day

Course cost is £300 per delegate
Course cost with Accelerate grant is £180 per delegate

Register interest for this course today

Chat Bot Logo
Cheshire and Warrington