Class -8th Ch-2 Question Answer 10 July 2025

 Chapter -2  Introduction to Access 2019

Fill in the blanks.

1. retrieves

2. flat file

3. tables

4. record

Exercises (Pgs. 46-48)

A. Tick (✓) the correct answers.

1. b

2. a

3. c

4. b

5. c

B. Fill in the blanks.

1. field

2. title bar

3. query

4. Templates

5. Primary Key

C. Write T for True and F For False.

1. F

2. T

3. F

4. T

5. T

A. Answer the following questions in short.

Q.1     What is database ? 

Ans:-     A database is an organized collection of data that is stored and accessed electronically. It is designed to efficiently store, manage, retrieve, and update information.

Q.2    How does DBMS help us ? 

Ans:-    A Database Management System(DBMS) helps organise data, making it easier to update, retrieve , and protect , improving efficiency and accuracy. 

Q.3     Why do we use MS Access 2019 ? 

Ans:-    Access 2019 is a popular Relational Database Management System (RDBMS),which organises data in tables and links them to related data . 

Q.4    How many types of databases are there?

Ans:-    The two main types of databases are Flat File Database and Relational Database.

B. Answer the following questions in long.

Q.1     Explain the difference between a flat file database and relational database.

Ans:- Flat File Database:-  A flat file database stores data in simple text files , where each line represents a single record , The data is unstructured and this type of data called flat file database. Flat file database include CSV(comma-separeted values ) files and MS excel files.

Relational Database :- A relational database organises data into multiple tables ,each containing rows and columns . These table are interconnected to related information. Popular example of relational database include Microsoft Access ,MySQL, and Oracle.

Q.2    What are the key components of a Database Management System? 

Ans-The key components of a Database Management System (DBMS) are as follows:

Table:. It organises information into rows and columns, with each row representing a record and each column representing a specific type of data.

Field: A field is a column within a table. It is used to store a specific type of information.

Record: A record is a row on a table. It consists of two or more fields and contains all the information related to a single item, person, or entity in the database.

Data: Data refers to a collection of facts, figures, or details that are stored and organised within a database. It can include several types of information, such as numbers, text, or other forms of content.

Query: A query is like a tool that helps you search for specific information in a database. Queries can also be used to modify or update information, such as correcting a mistake in the data.

Form: A form is a user-friendly interface that helps you add or view information in a database.It sends that information to the database for storage and future use.

Report: A report is a way of displaying information from a database in a clean and organised format, often for printing.

Q.3    What do you understand by Datatype ? 

Ans:-   A table consists of multiple fields ,each designed to store diverse types of data . In access ,you can assign data type to each field. The data type of a field determines the kind of data that can be entered into it .

Q.4     What is a primary key ? How does it help in organising a database ? 

Ans:-    The primary key is used to uniquely identify each record on a table. This means that the primary key field cannot have any duplicate values, ensuring that each entry is different. Additionally, a primary key cannot have any empty or blank entries when data is being added.

It helps in organising a database as follows:

• Uniqueness: It ensures that every record in a table can be uniquely identified, which helps to avoid duplicate data.

• Data Integrity: By preventing duplicate or missing values in the primary key field, it maintains the integrity of the data.

• Relationships: The primary key can be used to establish relationships with other tables, such as in a relational database, where foreign keys reference the primary key to link tables together.

• Efficient Searching: A primary key allows for faster data retrieval and more efficient searching since the database system uses indexing for primary keys.

Activity Hub (Pg. 49)

Give one-word answers for the following.

1. Datasheet

2. Design View

3. AutoNumber

4. Field Properties

5. Primary Key

                                                   

Chapter :- 3