DELHI PUBLIC SCHOOL JAMMU
HALF YEARLY EXAMINATION
SESSION: 2023-24 SET:A
Class: X Time: 2 hours
Sub: Computer M.Marks: 50
General Instructions:
All questions are compulsory.
Q1Multiple Choice Questions: (1x6=6)
1. Microsoft Access is a ___________.
a. Network Database Model b. RDBMS c. ARDBMS d. QODBMS
RDBMS
2. In Access, __________ are used to store the data.
a. Report b. Form c. Table d. Query
Form
3. In MS Access, Field Value may contain:
a. Text b. Date & Time c. Picture d. All of the Above
All the above
4. The overall design structure of a database is called Database_________.
a. Scheme b. Schema c. Preview d. None of these
Schema
5.In MS Access, the function of Primary key is-
a. To identify each row of a table.
b. To relate tables to each other using a foreign key.
c. To maintain reference and referential integrity.
d. All of the above
All the above
6. Which of the following is not a database object?
a. Tables b. Queries c. Relationships d. Reports
Relationships
Q2. Give one word for the following: (1x10=10)
1. A field can have up to characters including spaces: _64__________________
2. A key moves the cursor to the previous field in datasheet view__left
arrow___________________
3. A key which uniquely identified the records__primary key_____________________
4. The key to go to the first field of the current record ____right
arrow_____________________
5. A database object which consists of row and columns: __table___________________
6. A field can have up to characters including spaces: __64_________________
7. A key used to move to the next column________tab key__________________
8. A data type used to store a link to a webpage____ole/hyperlink____________________
9. A key moves the cursor to the previous field in design view____left
arrow_________________
10. Number of characters a table name can have ______64_____________________
Q3. Define the following terms: (2x5=10)
1.Forms: Forms to view, add and update data in the table
2.Reports: Reports to analyze and print data in a specific layout.
3.Queries: Queries to find and retrieve specific data of interest.
4.Primary Key: A primary key is a special relational database table column (or
combination of columns) designated to uniquely identify all table records.
5.Data Consistency: Data consistency refers to managing data across different tables of a
database.
Q4.Differentiate between the following: (4)
1. Design View and Datasheet View
2. Datasheet view shows the data in the database. It also allows you to enter and edit the
data. It does not let you change the format of the database, other than minor changes
(such as displayed column widths).
3. Design view allows you to create or change the table, form, or other database object, and
configure the fields. You can also set keys and restrict the values entered here. But you
can't change the database data in design view.
4. Ms Access and Ms Excel
Access Excel
Microsoft Excel generally deals with
Deals with text, numbers, files and all kinds of data numerical data
Lots of worksheets or documents are
All the data is stored one time, in one place. a store with similar, repeated data.
Helps you to build highly functional data entry Only the primary data entry screen is
forms and report templates. available.
Users will be able to enter the data more efficiently Data accuracy and speed is not much
and accurately. because of the format.
Q6 What are the keys to create relationship between two tables in MS-Access? (3)
Drag the field (Primary Key) from the table to the common field(Foreign Key) in the other
table.
Q7 What is a Query Table? (3)
It is a feature that enables to prepare data for easy reporting and analysis.
Q8 What is database? Name the two types of databases. (3)
Databases allows the user to add, access, change and delete data easily and effectively.Flat
and Relational database
Q9 Write the answers in one line only (5)
Select Queries
Retrieve records or summaries (totals) across records. Also includes cross-tabulations.
Make Table Queries
Similar to Select Queries but results are placed in a new table.
Append Queries
Similar to Select Queries but results are added to an existing table
Update Queries
Modify data in the records.
Delete Queries
Records are deleted from a table.
Q5 Identify, what these windows indicates. Give reasons. (6)
i) Related to primary key and
relationship
ii) Related to foreign key
SET:B
Class: X Time: 2 hours
Sub: Computer M.Marks: 50
General Instructions:
All questions are compulsory.
Q1Multiple Choice Questions: (1x6=6)
1. In Access, __________ are used to store the data.
a. Report b. Form c. Table d. Query
Table
2.In MS Access, the function of Primary key is-
a. To identify each row of a table.
b. To relate tables to each other using a foreign key.
c. To maintain reference and referential integrity.
d. All of the above
All the above
3. What is the maximum characters a field name can contain in MS- Access?
a. 32 b. 64 c. 255 d. 100
64
4. Which of the following characters cannot be used while naming a file in MS-Access?
a. [ ] b. ? c. - (dash) d. , (comma)
[]
5. In MS Access, Field Value may contain:
a. Text b. Date & Time c. Picture d. All of the Above
All the above
6. Which of the following is not a database object?
a. Tables b. Queries c. Relationships d. Reports
Relationships
Q2. Give one word for the following: (1x10=10)
11. Number of characters a table name can have ________64___________________
2.A field can have up to characters including spaces: ______64_____________
3.A key used to move to the next column_____tab key_____________________
4.A database object which consists of row and columns: _____table________________
5.The key to go to the first field of the current record ________right arrow_________________
6.A key which uniquely identified the records_______primary key________________
7.A key moves the cursor to the previous field in datasheet view___Left
arrow__________________
8.A key moves the cursor to the previous field in design view____Left
arrow_________________64
10.A data type used to store a link to a webpage_____Ole/Hyperlink___________________
Q3. Define the following terms: (2x5=10)
1. Data Consistency: Data consistency refers to managing data across different tables of
a database.
2.Queries: Queries to find and retrieve specific data of interest.
3.Reports: Reports to analyze and print data in a specific layout
4.Primary Key: A primary key is a special relational database table column (or
combination of columns) designated to uniquely identify all table records.
5. Forms: Forms to view, add and update data in the table
Q4.Differentiate between the following: (4)
5. Design View and Datasheet View
6. Ms Access and Ms Excel
7. Design View and Datasheet View
8. Datasheet view shows the data in the database. It also allows you to enter and edit the
data. It does not let you change the format of the database, other than minor changes
(such as displayed column widths).
9. Design view allows you to create or change the table, form, or other database object, and
configure the fields. You can also set keys and restrict the values entered here. But you
can't change the database data in design view.
10. Ms Access and Ms Excel
Access Excel
Microsoft Excel generally deals with
Deals with text, numbers, files and all kinds of data numerical data
Lots of worksheets or documents are
All the data is stored one time, in one place. a store with similar, repeated data.
Helps you to build highly functional data entry Only the primary data entry screen is
forms and report templates. available.
Users will be able to enter the data more efficiently Data accuracy and speed is not much
and accurately. because of the format.
Q6 What are the keys to create relationship between two tables in MS-Access? (3)
Drag the field (Primary Key) from the table to the common field(Foreign Key) in the other
table.
Q7 What is a Query Table? (3)
It is a feature that enables to prepare data for easy reporting and analysis.
Q8 What is database? Name the two types of databases. (3)
Databases allows the user to add, access, change and delete data easily and effectively.Flat
and Relational database
Q9 Write the answers in one line only (5)
a. Select Queries
b. Make Table Queries
c. Append Queries
d. Update Queries
e. Delete Queries
f. Select Queries
Retrieve records or summaries (totals) across records. Also includes cross-tabulations.
g. Make Table Queries
Similar to Select Queries but results are placed in a new table.
h. Append Queries
Similar to Select Queries but results are added to an existing table
i. Update Queries
Modify data in the records.
j. Delete Queries
Records are deleted from a table.
Q5 Identify, what these windows indicates. Give reasons. (6)
i) Related to primary key and
relationship
ii) Related to Report
