Class -8th Ch-3 Question Answer 20 July 2025

 Chapter 3: Queries, Forms, and Reports in Access 2019

Checkpoint (Pg. 59)

Write T for True and F for False.

1. T

2. F

3. T

4. F

Exercises (Pgs. 68-70)

A. Tick (✓) the correct answers.

1. b

2. b

3. b

4. c

5. b

B. Fill in the blanks.

1. primary key

2. relationships

3. Query Wizard or Query Design

4. Criteria

5. Save As

C. Write T for True and F for False.

1. T

2. T

3. F

4. F

5. F

A .    Answer the following questions .

Q.1    Explain how relationships between tables are created in Access 2019 and why they are important for managing database ?     

Ans:-     In Access 2019, relationships are used to connect a field in one table to the same field in another table. For the relationship to work, both tables must include a field with the exact same name, data type, and purpose. These matching fields are often primary keys, which uniquely identify each record in a table. In another table, this primary key is referred to as a foreign key.

Relationships are important for managing databases for the following reasons:

1.  Data Organisation:  
2. Avoiding Data Duplication: 
3. Ensuring Data Integrity:   
4. Simplifying Data Retrieval:   
5. Better Reporting:  

Q.2     Explain about query ? Name all types of queries in MS Access? 

Ans:-  The term 'query' refers to a question, but in context of  databases. A query helps retrieve specific data based on criteria defined by the user. You can create queries using the query Wizard for beginners or Query Design for more control

Access 2019 offers several types of queries, each serving a different purpose:

• Select Query

• Parameter Query

• Crosstab Query

• Action Query

• SQL Query

Q.3 What is a report? How many ways are there to create a report?

Ans:-    A report is a database object used to present or generate an output of data in a specific format. Reports are an effective way to organise ,view and present data. There are two primary methods for creating reports: 1. Report option , 2. Report Wizard .

Q.4    Discuss the role of the date and time feature in Access 2019 forms .

Ans:-    The Date and Time feature in Access 2019 forms is essential for managing time-related data efficiently. It allows users to track and display dates and times in a structured way, making it easier to record important events, deadlines, or activities in databases. This feature is commonly used for managing, schedules, appointments, orders, and transactions.

Q.5    What is form ? 

Ans:-    A form is a database object that allows users to enter ,edit ,delete and view data in a table .Table containing many fields ,some users may only need to view specific fields. Using form that displays only the necessary fields , user can navigate the database more efficiently .