key of primary table. Make sure the Control Wizards tool is selected before adding the SubForm/SubReport control to the Main form. (f) Option Groups : Control, when applied to Option button, allows the designer to select a particular option from out of a set of mutually exclusive options. This option is useful in designing a common Voucher Form for Debit and Credit Voucher for compound transactions.
(g) Command Button : It is meant to execute a defined action on the Form. Access provides for six categories of command buttons as described below: Record Navigation : The record navigation set of command buttons are meant to facilitate pointer movement on data records. At a point of time, only one row of a table, called data record, is accessed. To access other rows, there has to be a pointer for causing record movement.
Record Operation : There are several operations on data records. These are meant to facilitate such operations as add new record, delete record, undo record, save record, duplicate and print record. Form Operation : These operations are meant to be performed on the entire form as an object. These are Open form, Close form, Print form, Refresh form data and so on.
Report Operation : These operations are related to the report object. Once a report is created, further actions, which can be taken on such report are Mail report, Preview report, Print report and Send report to file. Access provides separate command buttons for each of these actions. Application : There are five command buttons especially designed for possible operations pertaining to other application programs.
Run application is meant to execute any existing program ; and Quit application is used to stop the execution of a running application; Run MS Excel command button is used for calling the MS Excel, spread sheet program which is part of MS Office package. Similarly, a command button to run MS Word results in calling the text processing program of MS Office package; Run Note Pad command button when executed calls the text writing program provided by the Operating System- Windows.