MS Access Database Intermediate  Course,1-Day, Private 1-to-1, Webinar

MS Access Database Intermediate Course,1-Day, Private 1-to-1, Webinar

Actions and Detail Panel

£290

Learn to code MS Access Queries to gain insight and trends from your data. Interactive, Instructor-led, Practical, 1-1.

About this event

MS Access Database Intermediate Course Data Analysis with Queries, Private 1-to-1

Course Aims: Intensive session concentrating mostly on creative queries, to extract data from large data sets to get insight from your data and report it. This private style tuition helps to maximise the value you get from the day.

Who Should Attend People who need to do creative and in-depth queries of datases.

Course Outline:

  • Database Principles
  • Data types, Table rowas and columns
  • Table Relationships
  • Tables Referential Integrity

General Queries to extract specific data sets, filtering and summarising data, getting statistics:

  • Select Queries, selecting columns
  • Where clauses to filter data
  • Working wit hdates, number and text values,
  • Nulls and not nulls
  • Wildcards
  • Totals Queries: Group by clauses to get sum, average, count, maximum and minimum details by categories
  • Parameter queries
  • Expression queries
  • Multiple table queries
  • Joining tables using query design

Action queries:

  • Make Table Queries to create new queries from existing query or tables,
  • Inserting queries to insert new records
  • Append queries,
  • Update queries
  • Delete queries
  • Data Importing Data Exporting Data Linking Data
  • Creating Advanced Forms Creating forms, Form wizards Creating a Navigation Form
  • Creating Advanced reports Macros and menu buttons, creating a menu system

Also included with MS Access Intermediate:

  • MS Access Intermediate Course Certificate
  • MS Access Intermediate Course Notes , Practical exercises, Homework , Revision work
  • After course support

Share with friends