Question

State the procedure for creating ledger in MS Access.

Answer 1

For creating a ledger in the MS Access, the procedure is provided below in the explanation.

Explanation:

With the use of MS Access, financial reports can be generated easily. Ledger is a type of financial report in which accounting transactions are recorded. There are eight columns in a ledger.

For creating a ledger in the MS Access, the procedure is as follows:

i. Firstly, select the reports from the Database window.

ii. Now, click on 'New Button' which displays the New report window.

iii. Now, select the design view. Also choose Query L from the combo control.

iv. Then, click OK.

v. Now, click on the properties of the report and choose the data tab.

vi. Select page footer and header by clicking on the report design.  

vii. Now, click on the icon of toolbar to describe the specifications. Also, pick a label control and set its caption properly such as font color, font size, and bold.

viii. Now, select the field of Query L with Ctrl key.

ix. Now, select the properties that are provided by MS Access.

x. Align Details section and the test controls.

xi. Select the Amount field and text controls to modify the properties.