Describe and discuss the procedure of creating the receipts side of a cash book.
Describe and discuss the procedure of creating the receipts side of a cash book.
The procedure of creating the receipts side of cash book is similar to report generation.
To produce the receipts side of the Cash Book, it is essential to retrieve a set of processed data records providing information on Code (Account Name), Name of Accounts, Particulars, Date Debit Balance and Credit Balance with reference to each particular account, where cash is debited.
In order to get all this information, it is necessary to make certain SQL statements and save them as Query in the Database.
In Access, the receipts side of a Cash Book can be created by following the below mentioned steps.
1. Select the ‘Create Report’ in the design view. With this, the access responds by displaying a blank report design divided into three sections- Page Header, Detail and Page Footer of the available fields of the Query.
2. Now, we design our report with the tools provided by the Access such as, naming the report, defining its size, colour, etc.
3. Select all the fields from the Query, drag and drop them into the ‘Details Sections’. Hence, the receipts side of the Cash Book is created.
The procedure of creating the receipts side of cash book is similar to report generation.
To produce the receipts side of the Cash Book, it is essential to retrieve a set of processed data records providing information on Code (Account Name), Name of Accounts, Particulars, Date Debit Balance and Credit Balance with reference to each particular account, where cash is debited.
In order to get all this information, it is necessary to make certain SQL statements and save them as Query in the Database.
In Access, the receipts side of a Cash Book can be created by following the below mentioned steps.
1. Select the ‘Create Report’ in the design view. With this, the access responds by displaying a blank report design divided into three sections- Page Header, Detail and Page Footer of the available fields of the Query.
2. Now, we design our report with the tools provided by the Access such as, naming the report, defining its size, colour, etc.
3. Select all the fields from the Query, drag and drop them into the ‘Details Sections’. Hence, the receipts side of the Cash Book is created.
