Kerala State Board New Syllabus Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 12 Accounting System Using Database Management System.
Kerala Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 12 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