microsoft access 2013 tutorial 5 review assignment

The next step in the Option Group Wizard is to assign a value to each of the option group’s optoins.

Select the option for No, I don't want a default and click on the Next> button to continue: For this example, the default values will be set from the underlying table so there is no need to set a default. The next step in the Option Group Wizard is to set the default choice for the Option Group.For this example assign the following to the labels: The first step in the Option Group Wizard is to assign labels to each option.The Option Group Wizard takes care of setting up the Option Group and assigning internal values to the various options within the group. As soon as the Option Group is drawn on the form, the Option Group Wizard will launch.Click on the Option Group control and then draw the option group on the form.With the AccountsDataEntry form opened in Design View, click on the Design item in the ribbon bar and scroll thorugh the controls list until you find the Option Group control.However if the values are not integers, then we will need to use an unbound option group with some macro code or VBA code to actually set the right values in the fields that are bound to the data tables.įor this example we will add an Option Group that will control the AccountType field on the AccountsDataEntry Form. If the values are integers, then we can bind the Option Group directly to the table column. In many cases a table column (field) will take one of two or three values and we may want to use Option Buttons as the user interface control to set those values. 5.2 Adding Option Buttons as Unbound Controls

Microsoft access 2013 tutorial 5 review assignment