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
