class 7 chapter 8 dbms

 

A. Tick (✓) the correct option

1. What object is used to retrieve data from one or more tables based on specified criteria?
a. Criteria
b. Form
✅ c. Query
d. Table

🧠 Explanation:
A query helps you find specific information from one or more tables. It retrieves only the data that matches the condition (criteria) you give.

2. In the Query Design Grid, which option is used to arrange records in ascending or descending order?
a. Criteria
b. Show
✅ c. Sort
d. Or

🧠 Explanation:
The Sort option helps to arrange data in ascending (A–Z) or descending (Z–A) order.

3. Which view is not available for working with a Form object?
✅ a. Form View
b. Datasheet View
c. Design View
d. Layout View

🧠 Explanation:
A Form can be seen in Form View, Design View, or Layout View — but Datasheet View is only for tables and queries, not for forms.

4. Which view of a report allows you to adjust margins, size, and orientation?
a. Layout View
b. Design View
✅ c. Print Preview
d. Report View

🧠 Explanation:
In Print Preview, you can see how the report will look when printed and adjust margins, page size, and orientation.

B. Fill in the blanks using the words in the box

Words Box:
Criteria | Design | Create | Datasheet | Forms

1. The option to create queries, forms, and reports is present on the ___ tab.
✅ Answer: Create

🧠 Explanation:
In MS Access, the Create tab is used to make new objects like tables, queries, forms, and reports.

2. Data is not visible in ___ view of a form.
✅ Answer: Design

🧠 Explanation:
In Design View, you can design or edit a form’s layout, but you cannot see the actual data.

3. The query results are displayed in the ___ view.
✅ Answer: Datasheet

🧠 Explanation:
When you run a query, the output (result) appears in Datasheet View just like a table.

✅✅ Final Answers Summary

A. Multiple Choice

  1. c. Query

  2. c. Sort

  3. b. Datasheet View

  4. c. Print Preview

B. Fill in the blanks

  1. Create

  2. Design

  3. Datasheet

    C. Write T for True and F for False statements

    1️⃣ Reports can be based on Tables only.
    ❌ False
    🧠 Explanation: Reports can be based on tables or queries, not just tables.

    2️⃣ We can change the structure of the report in the Report View.
    ❌ False
    🧠 Explanation: The structure (design) of a report can only be changed in Design View, not in Report View.

    3️⃣ We can give multiple criteria to filter out records from the database using queries.
    ✅ True
    🧠 Explanation: In a query, you can use multiple criteria (conditions) to get specific records.

    4️⃣ Forms let us to view, update, and delete records from the table.
    ✅ True
    🧠 Explanation: Forms are used to enter, view, edit, and delete data easily.

    5️⃣ Criteria specified under different fields in the Criteria row of the Query Design Grid is combined using the OR operator.
    ✅ True
    🧠 Explanation: When criteria are in different fields on the same row, Access combines them using OR logic.

    D. Answer these questions

    1. Define the following terms:

    a. Query:
    A query is used to retrieve specific data from one or more tables using given conditions or criteria.

    b. Form:
    A form is used to enter, view, and edit data in a table in an easy and user-friendly way.

    c. Report:
    A report is used to present data from tables or queries in a well-formatted and printable way.

    2. How can you specify multiple conditions while designing a query?

    You can specify multiple conditions in the Criteria row of the Query Design Grid.

    • Conditions on the same row use AND.

    • Conditions on different rows use OR.

    3. What is the use of the Print Preview and the Design View of a report?

    • Print Preview: Used to see how the report will look when printed and to adjust margins, page size, and orientation.

    • Design View: Used to create or change the layout and structure of a report.

    4. Differentiate between a Form and a Report.

    FormReport
    Used to enter, view, and edit data.Used to present or print data.
    Allows data modification.Shows read-only formatted data.
    Interactive — can update tables directly.Non-interactive — mainly for viewing or printing.

Comments

Post a Comment

Popular posts from this blog

class 7 last chapter

  A. Tick ( ✔ ) the correct option What is the main goal of intelligent security in smart cities? ✔ b. To improve surveillance and threat detection What technology is used to monitor and enhance traffic conditions on smart highways? ✔ b. Roadway Sensors Which AI technology is used for enhancing surveillance through facial identification and analysis? ✔ a. Facial Recognition B. Fill in the blanks (Words given: Security, Autonomous vehicles, Smart home, Traffic) The development of autonomous vehicles has led to the creation of vehicles that can improve traffic flow and safety. In smart cities, security technology enables real-time monitoring of surveillance cameras and can detect unusual activities or potential threats. AI in traffic management systems can analyse data from sensors and cameras to optimise traffic signals and reduce congestion. The integrati...
Read more

class 8 computer chapter 5

1. Java Keyword 👉 Definition: Keywords are reserved words in Java that have special meaning to the compiler. They cannot be used as identifiers (like variable names). 👉 Example: class , public , static , void , int , if , else public class Example { public static void main(String[] args) { int number = 10; // 'int' is a keyword if(number > 5) { // 'if' is a keyword System.out.println("Number is greater than 5"); } } } 2. Java Token 👉 Definition: A token is the smallest unit in a Java program. 👉 Types of Tokens: Keywords Identifiers Literals (numbers, characters, strings) Operators ( + , - , * , / ) Separators ( ; , {} , () ) 👉 Example: int a = 10; // Tokens: int, a, =, 10, ; 3. Java Data Types 👉 Definition: Data types define the type of data a variable can store. Two categories: Primitive Data Types (8 types) byte → 1 byte (e.g. byte b = 100; ) short → 2 bytes (e.g...
Read more