CBSE Class 11 Financial Accounting: Chapter 16 NCERT Solutions

Accounting reports are the physical manifestations of accounting information, serving as a consolidated summary of all pertinent facts and data related to a specific event or period. These reports are essentially the final outputs that depict an organization's financial performance over an accounting period. They present information derived from the systematic processing and transformation of raw data in a structured and comprehensible manner. The primary goal of accounting reports is to convey information clearly and unambiguously to their users, thereby minimizing risks associated with uncertainty and facilitating informed decision-making. Common examples of accounting reports include ledgers, trial balances, cash/bank books, and financial statements.

Accounting reports can be broadly categorized into two main types: Programmed Reports and Casual Reports.

1. Programmed Reports: These reports contain information that is useful for users in situations they anticipate occurring in the near future. They are further divided into:

1. Scheduled Reports: These are prepared for specific, recurring periods, such as daily, weekly, monthly, quarterly, or yearly. Examples include Trial Balances, Ledgers, and Statements of Cash Transactions.
2. On-Demand Reports: These reports are generated as and when they are needed or upon the occurrence of a particular event. Examples include Customer's Statement of Accounts, Inventory Re-order Reports, and Stock Purchased Reports.

2. Casual Reports: Also known as ad hoc reports, these contain information that may be useful but is only required occasionally. Users do not typically anticipate the need for these reports, and they can be generated randomly without extensive professional assistance.

A Parameter Query is a type of query that prompts the user to enter specific criteria or parameters through an input box before executing the query to select a set of records. This feature is particularly useful when the same query needs to be run multiple times with different criteria. Essentially, it allows for the execution of the same query logic with varying requirements.

For instance, when extracting information to prepare a ledger, the same query structure might be needed for different account codes. Consider the following SQL statement:

$$PARAMETERS\; AccountsName\; Text\; (145)$$

$$SELECT\; Name$$

$$FROM\; Accounts$$

$$WHERE\; Code\; =\; AccountNo.$$

In this SQL statement, the PARAMETERS clause is used to define a variable, AccountNo.. When this query is executed, the user will be prompted to enter a specific value for AccountNo., allowing the query to retrieve data for that particular account.

In database environments like SQL, functions are named routines that accept input arguments, perform operations, and return a single value. They are often used as part of expressions for calculated fields or to manipulate data. The main types of functions used in the SQL environment and their purposes are:

1. Domain Aggregate Functions: These functions perform calculations based on the values within a specific field of a table or query. They typically follow the syntax: DFunction("Fld Name", "Tbl Name" or Qry Name, "Srch Cond"), where DFunction is the function name, Fld Name is the field to be processed, Tbl Name or Qry Name is the source table or query, and Srch Cond is the condition for searching records.
2. SQL Aggregate Functions: These functions are used within SQL statements that define the record source for forms and reports. They typically require a GROUP BY clause when used in an SQL statement to aggregate data across groups of records.
3. Other Functions: Several other useful functions exist, including:
   • IIF: Used to return one of two mutually exclusive values based on a condition.
   • Abs: Returns the absolute (non-negative) value of a numeric input.
   • Val: Converts a string containing numeric characters into an actual numeric value.

Creating a query using a wizard involves a guided, step-by-step process. Here are the typical steps:

1. Navigate to the 'Database' window and select 'Queries' from the list of objects on the left-hand side.
2. On the right-hand side, double-click on the option that says 'Create Query' by using wizard. This action will launch the 'Simple Query Wizard'.
3. The wizard will then prompt you to select field names from available tables or existing queries that you wish to include in your new query.
4. After selecting the desired fields, click 'Next'. If you have included a number or currency field, you may be asked to choose between creating a summary query or a detail query.
5. Click 'Next' again. In this step, you will specify a name for the query you are creating.
6. Finally, click 'Finish' to save the query and execute it. The results of the created query will be displayed in the datasheet view.