Go Digital A Book Of Computers Class-8
Chapter-2 : Learn To Use Access 2013
Multiple Choice Questions
Page-24
Ans 1. (c) 2. (a) 3. (a)
Page-28
Ans 1. (c) 2. (b) 3. (b)
Section–A
A. Picture Quiz
Ans 1. (b) 2. (a)
B. Multiple Choice Questions
Ans 1. (c) 2. (b) 3. (b)
C. Fill in the blanks
Ans 1. Cirrus 2. single file 3. table structure 4. Long text
Section–B
A. Answer the following
Ans 1. There are two ways to create a database in Microsoft Access 2010.
(i) creating a blank database
(ii) creating a database using a template
Ans 2. Advantages of database are :
easy retrieval of data reduction of data inconsistency
easy manipulation of data reduction of data redundancy
easy sharing of data data security
Ans 3. Record - Rows in a table are called records.
Field- Columns in a table are called fields.
Table- A table is a collection of information where data is stored.
Query- A query is used to extract information from a database.
Computers-8 Answer Key 1
Ans 4. Design View
Datasheet View
It displays the view in a row/column It displays the view which allows you to
format which allows you to view, enter or enter field names, data types and the
manipulate data. description into your table.
Ans 5. Primary key is a field that uniquely identifies each record in a table. For example, in a
school database, the Roll Number of each student uniquely identifies each student.
A Primary key does not allow Null Values and must always have a unique value.
A Primary key is used to relate a table to foreign keys in other tables.
Ans 6. The manipulations operations that can be done on a table are :
(i) Add a new record (ii) Add a new field
(iii) Update a record (iv) Delete a row
(v) Delete a column
Ans 7. (a) The data type Short Text contains letters, numbers and symbols. The numbers in a
text field are considered as text and cannot be used for calculations.
For example, Aman, Vita13, A258297T, etc.
(b) The data type Number contains numeric values. It does not accept letters or other
symbols except numbers. For example, 46, 2004, 2012, etc.
(c) The data type Currency contains symbols for currency, decimals and commas
wherever needed. For example : $45.
Ans 8. Steps to create a table structure are as follows :
Step-1 : Click the CREATE tab.
Step-2 : Click Table Design from the Tables group. A new table in design view opens up.
Step-3 : Type the name of a field in the Field Name column and press the Tab key to
move to the Data Type column.
Step-4 : An arrow appears for the drop down list in the Data Type column. Click the
arrow and select the data type according to your field name from the list.
Step-5 : Press Tab key to move to the Description column and type a description of the
field. The description of the field is optional.
Step-6 : Save the table after adding all your fields by clicking the Save button on the
Quick Access Toolbar. The Save As dialog box appears.
Step-7 : Type the table name and click the OK button.
B. Computer In Everyday Life (Application-based Questions)
Ans 1. Access 2013
Ans 2. Admission No or Roll No can be set as Primary key as it helps to uniquely identify each
student of a class.
2 Answer Key Computers-8
Fun Zone
Activity
Ans 1. Text
2. Text
3. Number
4. Currency
5. Date/Time
6. Yes/No
Computers-8 Answer Key 3
