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

Database Management System · Part 25

Chapter 15: Accounting System Using Database Management System · ACCOUNTANCY

appears to the left of where the text control is dropped. Further, the following steps are taken to develop a data entry Form : (i) Click at New to open the New Form dialog. Two list controls appear in the dialog box : one provides for various options to create a Form such as Design view, Form Wizard, Auto Form; etc. and another to “choose the table or query where object’s data comes from” (also called record source).

From First List control choose Design view(default) by a click. (ii) Choose a table as the record source because the entire data is stored in the table record by record. Click OK after the table is selected. (iii) Access responds by providing three windows : one for new blank Form, second for tool box and third for Field list corresponding to the selected record source.

The Form object henceforth shall act as a container for other controls to be used in designing Form. (iv) Select and drag a field from the Field list and place it in the blank Form by drag and drop method. Repeat this process for every field in succession. Alternatively, all the fields can be selected by clicking at every field in the field list while Ctrl Key is kept pressed .

The selected fields can be dragged and dropped at the Voucher Form. (v) Adding a Title : The Form must be suitably titled for its identity, which should be self-descriptive. To add a title, use tool box by clicking at the label control. While the pointer is moved back into the design area, it changes to a large letter A with crosshairs .

Move the pointer into the header area and click where the label is desired to be placed and then type the text of title. Once the text is entered, the focus from the label control can be freed by clicking anywhere in the Form. The label can be reselected by a click, followed by using the formatting tool bar to format the title. Alternatively and in addition to the above, more formatting options

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 →