CBSE SOLUTIONS-2026-27
CLASS-7
CHAPTER-4 MS Access 2021: Advance Features
A. Multiple Choice Questions
1. MS Access is used to organise and manipulate data in the form of:
a. Forms b. Tables c. Reports d. None of these
Answer: (B) Tables
2. A DBMS that stores data in the form of tables is called:
a. Relational database management system b. Rotational data management system
c. Related data manipulation system d. None of these
Answer: (A) Relational Database Management System
3. They enable users to find and work on the data from one or multiple tables, according to the specified conditions:
a. Database b. DBMS c. RDBMS d. Queries
Answer: (D) Queries
4. This is the area below the Title Bar:
a. Ribbon b. Navigation pane c. Object tabs d. None of these
Answer: (A) Ribbon
B. Write TRUE or FALSE
1. You can customise the toolbar and add more buttons to it by clicking on the arrow next to the Redo button.
Answer: True
2. When you click on an object tab, the contents of that object are displayed in the work area.
Answer: True
3. The Status bar displays the current record number in an object.
Answer: True
4. File, Home, Create, External Data, Database Tools and Help are the main tabs in the Navigation Pane.
Answer: False
C. Fill in the Blanks
1. Forms provide a user ______ that lets the users to enter and change data in the table.
Answer: interface
2. A ______ can display chosen records or chosen fields within records.
Answer: query
3. Every ______ has a finite number of columns and rows.
Answer: table
4. Installed Templates contain tables, queries, ______ and other objects that you need to start working.
Answer: reports
5. Quick Access Toolbar has buttons for ______ that are used frequently.
Answer: commands
D. Answer These Questions
1. What do you understand by database?
Answer: A database is an organised collection of related data that can be easily stored, accessed, managed and updated.
2. Describe the term RDBMS.
Answer: RDBMS stands for Relational Database Management System. It stores data in tables consisting of rows and columns and allows relationships between tables.
3. Write any two advantages of a database.
Answer:
It helps to store and organise large amounts of data easily.
It allows data to be searched, accessed and updated quickly.
4. What is a table? Define.
Answer: A table is a database object that stores data in the form of rows and columns.
5. Define queries briefly.
Answer: A query is a request used to find, retrieve or work with specific data from one or more tables according to given conditions.
No comments:
Post a Comment