Plus One Accountancy Chapter Wise Previous Questions Chapter 12 Accounting System Using Database Management System

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)
Plus One Accountancy Chapter Wise Previous Questions Chapter 13 Accounting System Using Database Management System March 2015 Q1
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)
Plus One Accountancy Chapter Wise Previous Questions Chapter 13 Accounting System Using Database Management System Say 2015 Q1
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)
Plus One Accountancy Chapter Wise Previous Questions Chapter 13 Accounting System Using Database Management System Say 2016 Q1
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)
Plus One Accountancy Chapter Wise Previous Questions Chapter 13 Accounting System Using Database Management System Say 2016 Q1.1

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

Leave a Comment

error: Content is protected !!