CBSE SOLUTIONS-2025-26
CLASS-7
CHAPTER-4 Introduction to MS Access 2019
A. Tick the correct answer:
1. Quick access toolbar consists of:
a. Save button b. Undo button c. Redo button d. All of these
Answer: All of these
2. The standard file name extension for database in MS Office Access 2019 is____.
a. .accdb b. .accb c. .db d. .acb
Answer: .accdb
3. What lets us find and work on the data from one or multiple tables according to the specified conditions.
a. Tables b. Queries c. Forms d. Reports
Answer: Queries
4. To open an existing database, press ___________ keys.
a. Alt+O b. Ctrl+O c. Ctrl+E d. Ctrl+D
Answer: Ctrl+O
5. __________ is a software program that enables us to create, modify and extract data from a database.
a. DBMS b. DBBS c. DMBS d. None of these
Answer: DBMS
B. Write T for true and F for false:
1. MS Access provides a graphical user interface for managing data.
Answer: T
2. DBMS stands for Data Mange System.
Answer: F
3. Access comes with several pre-installed templates.
Answer: T
4. Reports provide a user interface that lets the users enter and change data in the tables.
Answer: F
5. Tables store the complete data in a structured manner.
Answer: DBMS
C. Fill in the blanks:
1. A ________ is an organized way of storing information.
Answer: Database
2. A database helps us to mange and access large amount of information ______ and _______________.
Answer: Quickly and efficiently
3. Data redundancy means _________ of data.
Answer: Duplication
4. Databases in MS Access 2019 are composed of ___________ main objects.
Answer: Tables, queries, forms and reports
5. ___________ are the building blocks of a database.
Answer: Tables, entities and attributes
D. Answer the following questions.
1. What is a database?
Answer: A database is an organized way to storing information. It helps us to manage and access large amounts of information quickly and efficiently. Logically interelated data is called database.
2. What do you understand by the term RDBMS?
Answer: RDBMS stands for Relational Database Management System. A DBMS that stores data in the form of tables and enables you to join the tables by creating a link between them is called Relational Database Mangement System.
3. Explain any two advantages of a database.
Answer: Advantages of a database:
1. Facilitates sharing of data: Different users can use the same database to extract data based on their individual needs.
2. Reduces data redundancy: Data redundancy means duplication of data. The redundancy or duplication of data is reduced in a database as we can arrange the data in a particular order.
4. Define the term tables.
Answer: Tables are the building blocks of a database. They store the complete data in a structured manner, i.e. in the form of rows and columns. Every table has a finite number of columns and rows.
5. What do you mean by the term queries?
Answer: A query is a special view of a table corresponding to some desiredd information to be extracted. A query can display chosen records or chosen fields within records. A query can apply to one table or to multiple tables, if they are linked by common data fields.
.jpg)
No comments:
Post a Comment