and credit columns to replace existing expressions by = Sum ([Query107]![Debit]) .......... for Debit = Sum ([Query107]![Credit]) .......... for Credit (iv) Right click at report design % click at sorting and grouping. Access responds by providing a window for sorting and grouping as shown in figure .
(v) Define the basis of grouping as CatId in field/expression and its sort order set to ascending. Set the Group Header property to Yes . Access responds by inserting CatId Header section in report design. (vi) Click at field list icon and drag and drop category field in CatId Header section.
Set its Font Size property to , Fore Colour property to Dark Green and Font Weight property as Bold. Save the modifications in the above report design. The trial balance report is generated by double click at this or the previous object. The generated trial balance may be saved or exported as desired.
Key Terms Introduced in the Chapter MS Access Database Management System Accounting Report Transaction Vouchers Compound Vouchers Queries Summary with Reference to Learning Objectives . Accounting Reports : A report displays information that is acquired from data processing and transformation in an organised manner. Reports tend to reduce the level of uncertainty associated with decision-makers and also influence their positive actions. The output of the computerised accounting system are accounting reports.
Financial accounting reports such as Cash book, Bank book, Ledger, and Trial Balance may be generated in Access by adhering to report generation process. . Using Access for Producing Reports : In Access, the reports are created by designing a report, identifying its information requirement, creating the queries in SQL to generate such information so that the final SQL statement provides the record set of information to the report design. Different Models of database design require different sets of SQL statements to produce different types of reports.
. Queries Access : There are several types of queries in Access that may be used to generate information. Such queries are called select queries because they are used to select records from the given set of records. There are