Create a Multiple Table Query in MS Access | | The Introduction to MS Access Course

These videos are part of my Introduction to Microsoft Access course. To complete the course please enrol here courses.bluepecantraining.com...
This video demonstrates how to include two related tables in a query and how to overcome potential problems with query criteria.
THE COURSE
This introduction to Microsoft Access course provides the perfect foundation for developing expertise. Even though it is a beginner’s course, delegates will build two fully functioning relational databases. I started my Microsoft Access training career back in the late 1990s and over the years have fine-tuned his content and delivery to culminate in this course.
The course has been designed to be as hands-on as possible. It is project-based and takes you through the steps involved in building an Access relational database from the ground up.
Topics Covered in the Course
Relational Database Theory - what is a relational database and how does it compare to the way data is stored in Excel, for example?
Tables - designing tables to store data. Setting data types and field properties.
Importing Data - importing data into your Access database stored in Excel or as text files.
Creating Relationships Between Tables - understanding primary and foreign keys and creating relationships between tables.
Design Forms - that look great and function well.
Select Queries - understand how to set AND/OR criteria, use comparison operators and wildcards.
Design Reports - that look professional.
Create a Front-End for your Database - create a navigation form with command buttons that open your forms and reports. Set database options that control what appears/doesn’t appear to your users when they open the database.
The course was created using Access 365 (2019) but will work for earlier versions.
------------------------

[@Jojosmith342]

All thumbs up for the great, valuable tutorials & Chester's hard work. Thanks millions for educating us 👍

[@simran12344.]

Sir can you tell me what is the major application area of access is ______
I am waiting your reply

[@romainsavioz5466]

Creating databases