View-Tab order or right click and choose tab order to open Tab Order dialog box. Clicking Auto Order generally rearranges the fields in the correct order. It is preferable to try this option first. If the auto order is not correct, the tab order can be set manually by clicking the row selector for a control and then dragging the control up or down into position in the Tab Order.
Fig. . : Conditional formatting window . .
Procedure for Creating Voucher Forms On the basis of above discussion, the following procedure can be followed to create the different types of vouchers : (a) Simple Transaction Voucher : The transaction data of simple accounting vouchers is required to be stored in the Vouchers table of a database by using a data entry Form in Access. The format of such a form is shown in figure . . Fig.
. : Transaction voucher, using database design (model-I) The above voucher form uses database design (Model-I) at the backend. A perusal of the this voucher Form reveals that there are two parts: Left and Right separated by a dark vertical line. Left part is dedicated to the data entry of transaction data while the right part has two list controls: one each giving the accounts to be debited and credited.
The pre-printed contents of simple transaction voucher appear to the left of above Form as bold dark words. The access resource required to display such pre-printed matter is label control. The data entry spaces against Voucher Number, Dated, Amount and Narration are Text Controls. The list controls have been deployed against Debit Account, Credit Account, Prepared By and Authorised By.
The Title of the Voucher Form has been written by using the Label Control. Four operation buttons called Command Buttons control the data entry into the voucher Form. On the Right hand side of above voucher Form, the list controls have been used in expanded Form to choose debit and credit accounts. The resources used in creation of above voucher Form, therefore, consist of Labels, Texts, List controls and Command Buttons.