NCERT Solutions for Class 11 Accountancy Financial Accounting Part-2 Chapter 8

Accounting System Using Database Management System Class 11

Chapter 8 Accounting System Using Database Management System Exercise Solutions

<< Previous Chapter 7 : Structuring Database for Accounting

Short answers : Solutions of Questions on Page Number : 617

Q1 :  

State what you understand by accounting reports.


Answer :

The accounting reports are the physical form of accounting information. They act as a summary of all the relevant facts and information related to a particular event. The accounting reports are basically the end (or final) reports depicting the performance of an organisation during an accounting period. They show the information that is acquired from processing and transforming the data in an organised manner. The accounting reports display the information content in such a manner that the users can understand them without any ambiguity. These reports form the basis of the decision making process as they minimise the risks associated with uncertainty. Ledgers, Trial Balance, Cash/Bank Book, Financial Statements etc. are some of the examples of accounting reports.  

Answer needs Correction? Click Here

Q2 :  

What do you mean by programmed or casual reports?


Answer :

Accounting reports can be classified into two broad categories- Programmed Reports and Casual Reports.

1. Programmed Reports- These are those reports that contain information, which can be utilised by the users in the situations that they expect to occur in the near future.

a) Scheduled Reports- These are the reports that are prepared for a specific period of time.  These reports can be prepared regularly on daily, weekly, quarterly, monthly or yearly basis. Trial Balance, Ledgers, Statements of Cash Transactions, etc. are some of the examples of Scheduled Reports.

b) On-Demand Reports- These are the reports that are prepared as and when required or on the happening of some particular event. Customer's Statement of Accounts, Inventory Re-order Report, Stock Purchased Report, etc. are some of the examples of On-Demand Reports.

2. Casual Reports- These are the reports that contain information which may be useful but are only casually required. The users do not anticipate their need. These are also known as ad hoc reports and can be generated randomly without much professional assistance.

Answer needs Correction? Click Here

Q3 :  

With the help of an example, briefly state the meaning of parameter queries.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q4 :  

Briefly state the purpose of functions in SQL environment.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q5 :  

Briefly explain in steps the method of creating a query, using wizard.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q6 :  

List the structure of a good report created in Access.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q7 :  

List the ways to refine the design of a report.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q8 :  

Briefly explain the purpose of grouping and sorting of the data as a means to refine a report.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q9 :  

What do you understand by saving a report as snapshot?


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q10 :  

State the procedure for creating ledger in MS Access.


Answer :

Please Register/Login to get access to all solutions Facebook Login
<< Previous Chapter 7 : Structuring Database for Accounting

Long answers : Solutions of Questions on Page Number : 617

Q1 :  

Describe and discuss the procedure of creating the receipts side of a cash book.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q2 :  

Discuss the concept of accounting reports? Explain the three steps involved in creating such reports. 


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q3 :  

Discuss with a set of inter-related data tables, the basics of creating queries in MS Access?


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q4 :  

Briefly explain the set of SQL statements to produce the receipts side of a cash book for Model-I.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q5 :  

Describe in steps the design view method to create a query in MS Access?


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q6 :  

Discuss the SQL view method of creating a query?


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q7 :  

Describe the ways to refine the design of a report.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q8 :  

Explain the data base design for Model-I for producing the receipts the series of SQL statements for producing the payment side of cash book for Model-II.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q9 :  

Describe the series of SQL statements to produce trial balance data base design for Model-II is used.


Answer :

Please Register/Login to get access to all solutions Facebook Login
Q10 :  

Using Model-I discuss the series of SQL statements to produce a trial balance up to a particular date. 


Answer :

Please Register/Login to get access to all solutions Facebook Login
<< Previous Chapter 7 : Structuring Database for Accounting

Financial Accounting Part-2 - Accountancy : CBSE NCERT Exercise Solutions for Class 11th for Accounting System Using Database Management System will be available online in PDF book form soon. The solutions are absolutely Free. Soon you will be able to download the solutions.

Popular Articles