CBSE Class 11 Accountancy: NCERT Solutions for Accounting System Using DBMS

Solution: Accounting reports are the final physical representations of accounting information. They serve as a comprehensive summary of all pertinent facts and data related to specific events or periods. These reports are crucial as they depict an organization's performance over an accounting period, presenting processed and transformed data in a clear, understandable manner for users. By minimizing risks associated with uncertainty, accounting reports form the foundation for informed decision-making. Common examples include Ledgers, Trial Balance, Cash/Bank Book, and Financial Statements.

Solution: Accounting reports are broadly categorized into Programmed Reports and Casual Reports.

Programmed Reports are designed for situations that users anticipate will occur. These can be further divided into:

• Scheduled Reports: Prepared at regular intervals (daily, weekly, monthly, quarterly, yearly). Examples include Trial Balance, Ledgers, and Statements of Cash Transactions.
• On-Demand Reports: Generated as needed or upon the occurrence of a specific event. Examples include Customer's Statement of Accounts and Inventory Re-order Reports.

Casual Reports, also known as ad hoc reports, contain information that may be useful but is not regularly anticipated. They can be generated randomly without requiring extensive professional assistance.

Solution: A Parameter Query is a type of query that prompts the user to enter specific criteria through an input box before it executes, allowing for dynamic data selection. This is highly beneficial when the same query needs to be run multiple times with different conditions.

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

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

$$SELECT\; Name$$

$$FROM\; Accounts$$

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

In this example, the PARAMETERS clause defines AccountNo. as a variable that requires user input. The SQL statement will then use the value provided by the user for AccountNo. to filter the records from the Accounts table.

Solution: In the SQL environment, functions are named procedures followed by parentheses that accept input arguments and return a value. They are integral parts of expressions used in database operations. The main types of functions and their purposes include:

1. Domain Aggregate Functions: Used to perform calculations based on values within a specific field of a table or query. The syntax is typically DFunction("Fld Name", "Tbl Name" or Qry Name, "Srch Cond"), where DFunction is the function name, Fld Name is the field to search, Tbl Name or Qry Name is the source table/query, and Srch Cond is the search condition.
2. SQL Aggregate Functions: These functions are used in SQL statements that define the record source for forms and reports. They typically require a GROUP BY clause to operate on sets of rows.
3. Other Functions:
   • IIF: Provides a value from a set of mutually exclusive options based on a condition.
   • Abs: Returns the absolute (non-negative) value of a numeric input.
   • Val: Converts a string containing numeric characters into an appropriate numeric data type.

Solution: Creating a query using the wizard method involves the following steps:

1. Navigate to the 'Queries' object in the Database window and select it from the list on the left-hand side.
2. Double-click on 'Create Query' by using wizard on the right-hand side. This action opens the 'Simple Query Wizard'.
3. In the wizard, select the field names from a table or an existing query 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 will be prompted to choose whether the query should be a summary or detail query.
5. Click 'Next' again. You will then be asked to 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.