MS Access Intermediate Course, Queries, 1-to-1, Online Classroom

MS Access Intermediate Course, Queries, 1-to-1, Online Classroom

Excellent MS Access Database Course on Intermediate level, covering queries to refine and filter datasets. Online, practical, Instructor-led

By PCWorkshops

Select date and time

Wed, 24 Apr 2024 02:00 - 08:00 PDT

Location

Online

Refund Policy

No Refunds

About this event

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

 

- Data Analysis with Queries

Course summary

This intensive session concentrates 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.

(Access 2010 and later)

Course Outline

Tables Referential Integrity Table Relationships

Queries RevisionSelect 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 on completion (assessment based) MS Access Intermediate Course notes Tea, coffees, but no lunch 1 free online questions session after the course.

Tags

Organised by

PCWorkshops

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

£185 – £285