Information Technology
Class - VIII
Chapter - 2
Worksheets
Worksheet 1 Multiple Choice Questions (MCQs).
1. In MS ACCESS, which data type stores a unique sequential increment by 1 which is
automatically inserted when a record is added, or decrements by 1 when a record is
deleted?
a. Number
b. Memo
C. Auto Number
D. Yes / NO
2. In MS Access, which technology Data type is used to store rates, prices etc?
a. Text
b. Currency
b. Memo
d. Number
3. Reports are:
a. Formatted output to display / print batches of records
b. Screens displaying data and entering / updating data in the tables
c. Having data storage capability
d. Used to display the records that match a certain, sort the data etc.
4. What are the screens used for displaying data and entering / updating data in tables
known as?
a. Tables
b. Forms
c. Reports
d. Queries
5. Microsoft office Access 2010 from Microsoft Office Suite is a type of:
a. Relation Database
b. Network Database
c. Hierarchical DBMS
d. Word Processor
Worksheet 2 Write (T) for True and (F) for False against the statements.
1. While creating a Table in the Design view, the validation rule lets you create an
expression, which is tested against the data entered. TRUE
2. In the Design view, you can easily define the field names enter data in those in a spreadsheet like view. TRUE
3. Tables can be created in the Datasheet view and the Design view. TRUE
4. Table are building blocks of a database. TRUE
5. Relation database consists of fields, records, and tables. TRUE
Worksheet 3 Select the suitable words and fill in the blanks.
Database, Primary Key, Report, Table, SORT, Query
1. The Primary Key key is used to define the data in a Field uniquely (there should be no duplicate value).
2. In the Database view, you can create Tables and specify the field types and the field lengths according to your requirement.
3. A Report is the formatted output to display / print batches of records.
4. With a Query you display the records that match certain criteria.
5. Table are building blocks of a database.
6. A SORT is an organized way of storing data and record keeping in computer.
Worksheet 4 Answer the following:
1. What is DBMS? Write any two advantages of Database.
Answer: A database or an electronic database refers to an organized collection of data stored on a computer in such a way that its contents can be quickly accessed, updated and queried with the help of a software program.
Advantages of Database
1. Reduces Data Redundancy
2. Data Sharing and Protection
2. What is RDBMS?
Answer: A Relation Database is a type of database where data is stored in a number of separated but related tables.
3. Write about any three data type.
Answer: Text, Memo and Number
4. What is the importance of the primary key?
Answer: The primary key is used to define the Data in Field uniquely (there should be no duplicate value). it helps to make searching faster.
5. What is the object of MS Access?
Answer: Table, Queries, forms and Reports.