Create your MS Access Database, 1-Day, 1-to-1, Enhanced with Generative AI
Multiple dates

Create your MS Access Database, 1-Day, 1-to-1, Enhanced with Generative AI

MS Access Database Setup and Queries. Enhanced with AI . Great for conceptualising and prototyping your database. 1-1 with expert.

By PCWorkshops

Location

PCWorkshops at Regus

Golden Cross House 8 Duncannon Street London WC2N 4jf United Kingdom

Refund Policy

Contact the organiser to request a refund.

About this event

MS Access Database Intermediate Course


Data Analysis with AI Powered Queries

1-to-1 with expert.

Create your database fast with drag and drop diagrams


MS Access Database Setup and Queries. Enhanced with AI . Great for conceptualising and prototyping your database. 1-1 with expert.


Course Aims:

1) Create a database fast with drag and drop diagrams

2) Import data

3) Query a data fast and efficiently with the help AI

4) Could be used as a concept and proof of efficiency of your design to be transalated to other databases


Course Outline:

Introduction

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

Create your Databese

  • Create you database
  • Import data

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 ,
  • After course support

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.

 

 Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html

 

From £185.00
Multiple dates