3. MS Access Forms – III

Objectives

In this session, students will learn about –

● Data types and changing the data type of a field

● Form creation

● Adding rows in a table

● Filtering data in a table

● Custom filtering

Keywords

● Data type: Type of data in a column of a table

WEBS at a Glance

Revise the story and CS concepts covered in the previous session

Invite students to brief the class on the story and CS concepts covered in the chapter

Tick

– Q 3

● Recap the story and CS concepts covered in the previous session.

● Say: Let’s learn about data types, form creation, adding rows in a table, and filtering data in forms.

5 min 10 min 10 min 5 min Action Plan 5 min Warm-Up 10 min Engage

CS Concepts Explain

Data Types

Changing Datatypes of a field

Form creation

Adding Rows in a table

Filtering Data in a table

Custom Filtering

As given in Panel 1 on Page 82

As given in Panel 2 on Page 82

As given on Page 83 and in Panel 1 on Page 84

As given in Panel 3 on Page 84 and Panel 1 on Page 85

As given in Panel 3 on Page 85 and Panel 1 on Page 86

As given in Panel 3 on Page 86 and Panel 1 on Page 87

● Present the scenario: Your teacher has asked you to create a form to track each student’s attendance.

● Discuss:

■ What fields should be included in the form?

Possible Responses: The form includes fields for the date; the student’s name; whether they were present or absent.

■ What are some common data types used in MS Access, and how are they used in creating tables?

Possible Responses: text; number; date/time; yes/no.

■ What are some advantages of using forms?

Possible Responses: to customise the interface for specific users; reducing errors and increasing data accuracy; providing a user-friendly way to interact with data.

■ What are some strategies for filtering data in a form?

Possible Responses: using drop-down menus or search boxes to select specific criteria; using filters to display only specific records; sorting data based on specific fields.

● Conduct Tick the Correct Answer on Page 89:

■ Say: Let’s help Conji and Eva to tick the correct answers.

■ Read Q3 aloud, one by one.

■ Invite some students to share responses.

■ Discuss and validate the answers with the whole class.

■ Instruct: Write the correct answers in your books.

● Conduct Find the Truth on Page 90:

■ Say: Let’s help Conji to clear the second round of the quiz by marking the statements as true or false.

■ Read Q2, 4, and 5 aloud, one by one.

■ Invite some students to share their answers and others to validate their peers’ answers.

■ Instruct: Write the correct answers in your books.

Note

● If time permits, discuss the section Brain Teaser – Answer in Detail Q1, 2, 3 or assign them as homework.

● Conclude: Today, we learned about data Types, changing data type of a field, Form creation, adding rows in a table, and filtering data in a table.

● Ask the following probing questions:

■ How can forms be used to automate repetitive tasks or processes?

Possible Responses: to automate tasks such as data entry; report generation; record keeping.

■ What are some examples of how forms can be used in different industries?

Possible Responses: can be used in healthcare for patient intake or medical history; in education for enrollment or student evaluation; in finance for tax forms or expense reports.

● Assign the following Brain Teaser exercise as homework:

■ Answer in Detail – Q1, 2, and 3