Account 4 Marks Question

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.

Saving as Snapshot : After a report is created, it may be saved in such a manner so as to be viewed by others without the help of Access. This becomes possible by saving the report as a snapshot file. As a result, a high quality picture image of each page of report is created with Adobe Acrobat software. Other users of the report can then view the report and print any of its pages without being able to modify its contents. It must be ensured that this feature of saving a report as snapshot is also installed while installing the MS Office 2000 package.

A Parameter Query is a query where for selecting a set of records, the user is asked to enter parameters or criteria through an input box. A Parameter Query is useful when the same query is to be repeated with different criteria. In short, it implies the execution of same set of queries with different requirements.
For example, the same set of queries is required for different accounts code, while extracting the information to prepare ledger. Let us consider the given below SQL statement.
PARAMETERS Accounts Name Text (145)
SELECT Name
FROM Accounts
WHERE Code = AccountNo
In the above query, PARAMETERS clause is used to represent the variable AccountNo. This SQL statement requires the user to provide the different values of Account No.