As it is known to all a Cash book is a type of accounting report. The procedure of creating the receipts side of cash book is same as reports generation. In the process of producing receipts side of a cash book, it is necessary to retrieve a set of processed data records which provide information on code (Account Number), Name of Account, Particulars and credit Balance with reference of each account where cash account is debited.
Receipt side of cash book deals with the cash receipts. In the process of creating receipts side we have to find out the amount and particulars of the transaction in which cash is received ie. cash account is debited. For creating it, first we have to find out these amounts and a particular set of SQL statement and save them into Database after giving particular name to each query.
After creating the SQL statement now we will start the process of MS Access Database. Select create report in design view and query (Last Saved). This respond to give blank report design dividend into three sections page header, detail and page footer and of available fields of Query.
Here, we design our report with the tools provided by Access like giving name to the report, defining its size and colour. After this we select the all fields from our Query and drag and drop them into the Detail section. By applying some arithmetical calculations provided by Access we get the receipt, side of cash book.
