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.

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

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

Also check out other Workshops in London.