Kerala Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 13 Accounting System Using Database Management System
Question 1.
Krishna intends to create a table in MS-Access. Suggest suitable data types for the following fields. (March 2015)
Answer:
Field Name – Data Type
a) Job Id – Number/Text
b) Job Name – Text
c) Job Type – Text
d) Job Department – Text
e) Job Unit – Number
f) Job Time – Date/Time
Question 2.
A company has supplied certain information required for creating a table under MS Access. (Say 2015)
Fill in the blanks with suitable data types wherever you find a question mark.
Answer:
Field Name – Data type
a) Account code – Number/Text
b) Account name – Text
c) Debit/Credit – Number/Text
d) Amount – Number
c) Narration – Text
Question 3.
Sorting or filtering of records is not possible in _____ data type. (March 2016)
a) text
b) number
c) memo
d) date
Answer:
c) Memo
Question 4.
Fill in the blank with a suitable data type on the basis of the hint given: (March 2016)
a) Name : Text
b) Birthdate : ________
Answer:
b) Birthdate : Date/Time/Text
Question 5.
List any two ways in which queries may be created in access. (March 2016)
Answer:
Design view, SQL, wizard
Question 6.
Consider the following table and answer the questions given below. (Say 2016)
a) Name of the entity.
b) Primary key.
c) Generate a meaningful record by writing an example in the above boxes with a question mark.
Answer:
a) Student
b) Student Adm. No.
c)
Question 7.
Mention the steps for creating a simple table in MS Access. (Say 2016)
Answer
- MS Access
- Table/Table design
- Data Type
- Set primary key
- Save the table
Question 8.
Entity in MS Access is a ________ (March 2017)
a) object of relation
b) present a working model
c) thing in the real world
d) model of the relation
Answer:
c) Things in the real world
Question 9.
What is the maximum length a text field can be in MS Access? (March 2017)
a) 120
b) 255
c) 265
d) 75
Answer:
b) 255
Question 10.
Write any two data types in MS-Access with suitable examples. (March 2017)
Answer:
The followings are the different data types:
- Text → Example: Job name, Job type, etc.
- Number → Example: Job unit, Job ID
- Date/Time → Example: Job time
- Currency → Example: Dollars, Rupees, etc.
- Yes/No