g. Finally, add a button to the form. To insert a button, we click the Button button in the ribbon. Move the we’ll cursor crosshair to a location in the press the mouse button, and drag to draw the button. When Form Footer, the mouse button is released, the Command Button Wizard window is displayed. Highlight the category of action to be performed in the left box and highlight the specific action to be performed (when the button is clicked) in the right box. Choose and for this example. Then continue “Record Navigation” “Find Record” through the wizard, giving a name (or picture) for display, and an internal name that will be used later as sort of a variable name in a database application. h. Something similar to the following picture is the result of the work described above. Switch to Form View and try the button. A dialog box will be displayed which will allow a user to search conveniently “Find Record” through the table for a specific record. i. What the wizard has done here is automatically create a written in Visual Basic for Applications (VBA) macro that is performed when the button is clicked. You can get a look at the script by right-clicking on the button in Design View, selecting clicking the in the Property Sheet and then clicking on the three Properties, “Event” tab that appear when you click in the window. We will look at writing macros of our own dots (“…”) “On Click” later in the course. More practice with creating forms Create the following forms as part of your grades database. Your forms do not have to look exactly like the forms shown here, but they should contain the same information and the same buttons. Colors, location and size of fields and their labels are choices that you can make. You should, however, attempt to produce attractive as well as useful forms. Note the inclusion of the for GPA. Can you figure out how to include it? (Hint: FStudentInfo: calculated field GPA is calculated by dividing hours attempted into quality points.) And to format it to two decimal places? Also note that the wizard gives you a checkbox field instead of a text field for Financial Aid information. Can you figure out how to change this?
g. Finally, we’ll add a button to the form. To insert a button, we click the Button button in the ribbon. Move the cursor crosshair to a location in the Form Footer, press the mouse button, and drag to draw the button. When the mouse button is released, the Command Button Wizard window is displayed. Highlight the category of action to be performed in the left box and highlight the specific action to be performed (when the button is clicked) in the right box. Choose “Record Navigation” and “Find Record” for this example. Then continue through the wizard, giving a name (or picture) for display, and an internal name that will be used later as sort of a variable name in a database application. h. Something similar to the following picture is the result of the work described above. Switch to Form View and try the “Find Record” button. A dialog box will be displayed which will allow a user to search conveniently through the table for a specific record. i. What the wizard has done here is automatically create a macro written in Visual Basic for Applications (VBA) that is performed when the button is clicked. You can get a look at the script by right-clicking on the button in Design View, selecting Properties, clicking the “Event” tab in the Property Sheet and then clicking on the three dots (“…”) that appear when you click in the “On Click” window. We will look at writing macros of our own later in the course. More practice with creating forms Create the following forms as part of your grades database. Your forms do not have to look exactly like the forms shown here, but they should contain the same information and the same buttons. Colors, location and size of fields and their labels are choices that you can make. You should, however, attempt to produce attractive as well as useful forms. FStudentInfo: Note the inclusion of the calculated field for GPA. Can you figure out how to include it? (Hint: GPA is calculated by dividing hours attempted into quality points.) And to format it to two decimal places? Also note that the wizard gives you a checkbox field instead of a text field for Financial Aid information. Can you figure out how to change this?