Tag: objective in dbms

Queries object class is meant to create the SQL compatible query statement with or without the help of Graphic User Interface (GUI) to define tables, store data and retrieves both data and information.

The need for which is not anticipated, the information content of which may be useful but casually required are known as casual reports.These are adhoc reports and are generated casually by executing some simple queries without requiring much of professional assistance.

The reports, which are generated only on the triggering of some event are called On demand reports. Some examples of on demand reports are customer's statement of account, inventory re-order report, Stock in hand report for a selected group of items, etc.

The process of generating accounting reports in access involves three steps: Designing the report, Identifying the accounting information queries, and finally creating an accounting report by using such queries.

A report is prepared with a definite objective. Every report is collection of related information for a particular need and purpose and must meet the twin objectives of reporting: one to reduce the level of uncertainty that is faced by a decision-maker; second to influence the behavior (or positive actions) of the decision-maker.

The record set of final SQL that relies upon preceding SQL statement, is collection of report-oriented information. This record set need be embedded in the report being produced.