Sri Sevugamoorthy Matric School (Hi-Tech)
Std : VIII I MID TERM TEST Marks : 50
Name: Computer Science Time: 1 hr 30 mins
[Link] the correct answer. 5x1=5
1) Which process retrieves specific records from a table?
a) Primary key b)Sorting c) Filtering
2) Filters are available in the ____________
a) Sort&Filter group b)Font group c) Clipboard group
3)When will you use the Relationships button?
a)when adding a new table. b)when building a new relationship. c)when deleting a record
4). When will you use this icon?
a)when deleting records. b)when creating a database c)when sorting records
5)To delete a record, which button must be used from the Records group?
a)Insert. b)Rename c) Delete
[Link] in the blanks. 8x1=8
1) A table is a set of ________________ and _______________ where data is arranged.
2) ___________is a relational database management system.
3) By default, the database will be created in the ___________folder.
4) To create a table, click on the __________tab.
5) A _______________ identifies a record uniquely in a table.
6) To get information from a database _______________ are used.
7) Arranging the data in a particular order in the table is__________.
III. Identify the objects in the table. 6x1=6
1) Pg no 32
IV. Find the common term for the following pairs of words. 3x1=3
Stores Fields &
1) data Records
2)
Reports Tables
Date Character
3)
V. Answer the following questions in one word. 6x1=6
1) In a Relational database, what does a row refer to?
2)Which view will you select to create a table?
3) Which key helps to move between fields within a record?
4) Which tab contains controls to manage the database?
5) Which database object helps you to print the results?
6) What does help you to avoid duplicate records in a table?
VI. Answer any 6 of the following. 6x2=12
1)What is primary key?
2)Define a table.
3)What is the use of the datasheet view?
4)Name the tabs available in MS Access.
5)Acronym : SQL , RDBMS.
6)In how many ways can you sort a column? Name them
7)Write types of views available in Views group.
VII. Answer the following in detail. 2x5=10
1)Write the steps to launch MS Access.
2)Define sorting.