{"id":44310,"date":"2024-02-19T09:17:21","date_gmt":"2024-02-19T03:47:21","guid":{"rendered":"https:\/\/www.aplustopper.com\/?p=44310"},"modified":"2024-02-19T14:38:36","modified_gmt":"2024-02-19T09:08:36","slug":"plus-one-accountancy-chapter-wise-previous-questions-chapter-13","status":"publish","type":"post","link":"https:\/\/www.aplustopper.com\/plus-one-accountancy-chapter-wise-previous-questions-chapter-13\/","title":{"rendered":"Plus One Accountancy Chapter Wise Previous Questions Chapter 13 Accounting System Using Database Management System"},"content":{"rendered":"

Kerala Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 13 Accounting System Using Database Management System<\/h2>\n

Question 1.
\nKrishna intends to create a table in MS-Access. Suggest suitable data types for the following fields. (March 2015)<\/span>
\n\"Plus
\nAnswer:
\nField Name – Data Type
\na) Job Id – Number\/Text
\nb) Job Name – Text
\nc) Job Type – Text
\nd) Job Department – Text
\ne) Job Unit – Number
\nf) Job Time – Date\/Time<\/p>\n

Question 2.
\nA company has supplied certain information required for creating a table under MS Access. (Say 2015)<\/span>
\n\"Plus
\nFill in the blanks with suitable data types wherever you find a question mark.
\nAnswer:
\nField Name – Data type
\na) Account code – Number\/Text
\nb) Account name – Text
\nc) Debit\/Credit – Number\/Text
\nd) Amount – Number
\nc) Narration – Text<\/p>\n

Question 3.
\nSorting or filtering of records is not possible in _____ data type. (March 2016)<\/span>
\na) text
\nb) number
\nc) memo
\nd) date
\nAnswer:
\nc) Memo<\/p>\n

Question 4.
\nFill in the blank with a suitable data type on the basis of the hint given: (March 2016)<\/span>
\na) Name : Text
\nb) Birthdate : ________
\nAnswer:
\nb) Birthdate : Date\/Time\/Text<\/p>\n

Question 5.
\nList any two ways in which queries may be created in access. (March 2016)<\/span>
\nAnswer:
\nDesign view, SQL, wizard<\/p>\n

Question 6.
\nConsider the following table and answer the questions given below. (Say 2016)<\/span>
\n\"Plus
\na) Name of the entity.
\nb) Primary key.
\nc) Generate a meaningful record by writing an example in the above boxes with a question mark.
\nAnswer:
\na) Student
\nb) Student Adm. No.
\nc)
\n\"Plus<\/p>\n

Question 7.
\nMention the steps for creating a simple table in MS Access. (Say 2016)<\/span>
\nAnswer<\/p>\n