£290 – £420

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

Actions and Detail Panel

£290 – £420

Event Information

Share this event
Location

Location

Online Event

Refund Policy

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Event description
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 summary

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:

Tables Referential Integrity Table Relationships

General Queries:

Select Queries, selecting columns and using where clauses Multiple table queries, joining tables using query design In null, is not null Wildcards Totals Queries Expression queries

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

Share with friends

Date and Time

Location

Online Event

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved