📖 generic · CBSE Class 11 English medium · ACCOUNTANCY · Page 1question

Database Management System · Part 34

Chapter 15: Accounting System Using Database Management System · ACCOUNTANCY

bottom of Left most bottom corner of the Voucher Form. Its shape turns into a cross with command button icon. Paste it by horizontal and vertical dragging to give suitable width and height. Immediately, the Command Button wizard is invoked to seek information about category of operation and the action to be performed using this command button.

Choose Record operation as category with Add New Record as the action. Click at Next to state whether the caption of the command button is to be a text value or an icon. A click at next after appropriate selection results in giving a suitable object name to the command button. Accept the default value and click at finish.

This results in pasting an operational button on the Form with the capability to add a new record. (xv) Repeat this action to create various other command buttons to match the design of Transaction Voucher Form given above. (b) Compound Transaction Voucher : The transaction data of Debit or Credit vouchers, which have already been described as compound transaction vouchers, is required to be stored in VouchersMain and VouchersDetails tables of database. Its design, when transformed in Access Form layout, is expected to appear in the following format : A perusal of the above Access Form for Credit Voucher reveals that there are four labels: Voucher No, Date, Prepared By and Authorised By in Dark bold letters.

These labels are meant to define the pre-printed content of the voucher as per design. Next to first two labels: Voucher No. and Date are text boxes displaying their respective data contents. To the right of labels Authorised By and Prepared By are List Box controls to get and display the first name of employees.

Text Box displays the Title of the Voucher Form Credit Voucher as calculated control because the same voucher design is used for Debit vouchers also. Just below this dynamic title is the Option group control whereby the user can make a mutually exclusive choice for Debit or Credit Voucher. The title of Entries Grid and Text box to the left of a

Related topics

Have a question about this topic?

Get an AI answer grounded in your actual textbook — with the exact page reference.

Ask AI about this topic →