not anticipated is called ........................reports. (b) ................query does not involve use of any query function to produce a summary of data. (c) ................ query prompts the user to enter criteria for selecting a set of records.
(d) ................clause is used to specify the fields to display data or information. (e) .................. is meant to include page number, data and time of report. (f) The purpose of .................
is to organise the information of report into categories whereas ............ arranges information into numerical or alphabetical order. (g) When saved as ......................., the contents of reports can not be modified by the user. .
. Designing Accounting Reports using Access Financial Accounting Reports such as Cash book, Bank book, Ledger Accounts and Trial Balance may be generated in Access by adhering to report generation process. The exact process in the context of each of these reports is described below : Trial Balance The Trial Balance is one of the accounting reports, which provides the net amount by which each account, during a given period of time, has been debited or credited. The format of a typical trial balance is as given below : Trial Balance Account Title L.F.
Debit Credit Amout Amount Rs. Rs. Total Fig. .
: Format of trial balance To produce a trial balance, it is necessary to retrieve a set of processed data records each of which provides information on Code (or Account Number), Name of Account (or Particulars), Debit balance and Credit balance with reference to a each account. In order to find net balance corresponding to every account along with its identity, following steps are taken : (i) To find the total amount by which every account has been debited; (ii) To find the total amount by which every account has been Credited; (iii) To find a collective record set of accounts with their debit and credit totals; (iv) To find the net amount with which every account has been debited or credited; and (vi) To find the record set which consists of Account code, name of Account, Debit and Credit Amount. Above steps to produce