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

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.
------------------------

[Jojosmith]

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

[simran.]

Sir can you tell me what is the major application area of access is


I am waiting your reply