State the procedure for creating ledger in MS Access.
State the procedure for creating ledger in MS Access.
Financial Accounting Reports can be generated in MS access easily. Ledger is one of the financial reports through which accounting transactions are shown in a particular account, during a given period of time.
A ledger contains eight columns as follows
Dr Ledger Account Cr
DateParticularJFAmt.(Rs.)DateParticularsJFAmt. (Rs.)
For creating a ledger in MS Access it is necessary to retrieve a set of processed data records each of which provide information Code (Account Number), Name of Account, Partuculars, Date Debit Balance and Credit for Creating Balance with reference to each particular account.
For creating Ledger in MS Access we have to take the following steps.
1. Select 'Reports' from the 'Object' list in the Database window.
2. Click 'New' button so that 'New Report' window is displayed.
3. Select 'Design View' and 'Query L' from the combo control.
4. Click 'OK'.
With this, the access responds by displaying a blank report design divided horizontally into three sections- Page Header, Detail and Page footer. Also, a list of available fields of Query L is provided for embedding on to this blank design.
5. Click at 'Properties' of the report and select 'Data' tab to define the recorded source as Query L. This displays a list of available fields of Query L.
6. Right click at any part of the report design and choose Report, Page Header and Footer. With this, the Access responds by providing two more sections- Page Header and Pager Footer.
7. Click at the 'icon' of the toolbar and pick up a label control to be placed at the Page Header section and assign its caption.
8. Select all the fields of Query L by clicking at every field, while keeping the 'Ctrl key' pressed. Drag and drop the selected field on the 'Details Section'.
9. Select the total control of all the six fields by clicking at each, while keeping the 'Shift key' pressed. Right click at the 'Select Label Control' and choose 'Cut'. Now, place the mouse at the Page Header Section and 'Paste' these controls.
10. Choose the 'Properties' provided by the Access.
11. Align the text controls in the 'Details Section'.
12. Select the 'Text Controls' and 'Amount Field' and modify their properties.
Hence, the required ledger in access is created.
Financial Accounting Reports can be generated in MS access easily. Ledger is one of the financial reports through which accounting transactions are shown in a particular account, during a given period of time.
A ledger contains eight columns as follows
Dr Ledger Account Cr
DateParticularJFAmt.(Rs.)DateParticularsJFAmt. (Rs.)
For creating a ledger in MS Access it is necessary to retrieve a set of processed data records each of which provide information Code (Account Number), Name of Account, Partuculars, Date Debit Balance and Credit for Creating Balance with reference to each particular account.
For creating Ledger in MS Access we have to take the following steps.
1. Select 'Reports' from the 'Object' list in the Database window.
2. Click 'New' button so that 'New Report' window is displayed.
3. Select 'Design View' and 'Query L' from the combo control.
4. Click 'OK'.
With this, the access responds by displaying a blank report design divided horizontally into three sections- Page Header, Detail and Page footer. Also, a list of available fields of Query L is provided for embedding on to this blank design.
5. Click at 'Properties' of the report and select 'Data' tab to define the recorded source as Query L. This displays a list of available fields of Query L.
6. Right click at any part of the report design and choose Report, Page Header and Footer. With this, the Access responds by providing two more sections- Page Header and Pager Footer.
7. Click at the 'icon' of the toolbar and pick up a label control to be placed at the Page Header section and assign its caption.
8. Select all the fields of Query L by clicking at every field, while keeping the 'Ctrl key' pressed. Drag and drop the selected field on the 'Details Section'.
9. Select the total control of all the six fields by clicking at each, while keeping the 'Shift key' pressed. Right click at the 'Select Label Control' and choose 'Cut'. Now, place the mouse at the Page Header Section and 'Paste' these controls.
10. Choose the 'Properties' provided by the Access.
11. Align the text controls in the 'Details Section'.
12. Select the 'Text Controls' and 'Amount Field' and modify their properties.
Hence, the required ledger in access is created.
