4. MS Access Queries – IV

Objectives

In this session, students will apply what they have learned from the previous session -

● Creating a one-table query

● Multi-Table query

● Creating a multi-table query

Keywords

● Criteria: Conditions or rules you use to filter and retrieve specific data from a database

● One-table query: Retrieves data from a single table in a database based on specific criteria

● Multi-table query: Retrieves and combines data from two or more related tables in a database based on specific criteria

WEBS at a Glance

● Say: Do you remember what we learned in the previous session?

● Invite responses from some students.

● Say: Let’s revise what we have learned.

● Instruct: Go to the Panel and open Lab on Queries in MS Access II and Multi- table queries II.

● Show slides one by one and discuss the concepts shown on the slide on the panel.

● Say: Let me explain creating a one-table query, multi table query and creating a multi-table query.

CS Concepts

Creating one-table query

Multi-table query

Creating multi-table query

Learning Slides on Tekie platform

Learning Slides on Tekie platform

Learning Slides on Tekie platform

● Discuss the following questions one by one to check students’ understanding:

■ Give some examples of a one-table query using AND.

Possible responses: It can be used to retrieve all records where a student’s grade is above a certain value and they also attended class on a specific day.

■ Give some examples of a one-table query using OR.

Possible responses: It can be used to retrieve all records where a student’s grade is above a certain value or they attended class on a specific day.

■ Give an example of a multi-table AND query?

Possible responses: It can be used to retrieve all records where a student’s grade is above a certain value and they also attended class on a specific day, while also retrieving information about the student and the class from separate tables.

■ Give an example of a multi-table OR query.

Possible responses: It can be used to retrieve all records where a student’s grade is above a certain value or they attended class on a specific day, while also retrieving information about the student and the class from separate tables.

● Invite answers from as many students as possible.

● Address if students have any other doubts related to the concepts presented in the slides.

● Instruct: We know how to create a one-table query, multi-table query and create a multi-table query.

● Now, let’s practise our learning. Click on the Practice button on the Assignment page of Queries in MS Access II and Multi-table queries II to attempt the activity.

Note

● Make the students practice the activity till the concepts covered in the session.

● Walk around in the classroom and observe the activity done by the students.

● Instruct: Click on the Confirm button to submit your work when you are done with the activity.

● Instruct: Click on the Confirm button to submit your work when you are done with the activity

● Conclude: Today, we have learned to create one-table queries and multi- table queries.

● Instruct: Practise the same activity at home.

● Assign the following as homework:

■ Project: Labtime on Page 112. Try to use And and OR query on this form.

Note

● The project is optional, kindly assign as per feasibility.

● Conclude: Today, we have learned to create one-table queries and multitable queries

● Instruct: Practise the same activity at home

● Assign the following as homework:

○ Project: Labtime on Page 112 Tr y to use And and OR quer y on this form