Access module 1 textbook project

Illustrated Access 2016 | Module 7: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.pngIllustrated Access 2016 | Module 7: SAM Project 1a

Dive Trips Database

ENHANCING FORMS

GETTING STARTED
Open the file IL_AC16_7a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as IL_AC16_7a_FirstLastName_2.accdb by changing the “1” to a “2”.

0. If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

1. Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS
1. Open the blank form titled Countries in Design View and set the Record Source property to the Countries table. Save and close the form.

2. Open the DiveTripEntry form in Design View, then open the Field List. Add all fields from the DiveTrips table to the form. Select all controls in the form and move them to the approximate location shown in Figure 1 on the next page. Save the form and close it.

Figure 1: DiveTripEntry Form in Design View

3. Open the Members form in Design View. On the Ribbon, make sure the Use Control Wizards button is selected so that controls that have associated wizards are available.

Add a subform control to the form with the following options:

a. The subform should be added below the Phone Number label at about the 1" mark on the horizontal and vertical rulers.

b. The subform should be based on the DiveTrips table (not the DiveTrips form) and contain the following fields: DiveMasterID, City, State, Country, and StartDate (in that order).

c. Connect the subform to the main form using the common DiveMasterID field.

d. Name the subform DiveTripsSubform. (Hint: Do not type the period.)

Save the form without closing it.

4. While still viewing the Members form in Design View, open the Form Header section and add a title to the left side of the form with the following options:

a. Add the text Club Members and Dives as the caption of the title label.

b. Format the new Club Members and Dives label using 20 pt. font size and Black font color (2nd column, 1st row of the Standard Colors palette).

c. Resize the label so that its right edge is located at approximately the 4" mark on the horizontal ruler.

Save the form without closing it.

5. While still viewing the Members form in Design View, add a combo box to the Form Header section (at approximately the 6" mark on the horizontal ruler) with the following options:

a. The combo box should be used to find records in the form.

b. Select DiveMasterID and LName (in that order) as the fields for the combo box.

c. Hide the key column.

d. Label the combo box Find Member. (Hint: Do not type the period.)

e. Change the font color of the Find Member label to Dark Blue (2nd to last column, last row of the Standard Colors palette).

Save the form without closing it.

6. While still viewing the Members form in Design View, add a command button to the Form Footer section (at approximately the 6" mark on the horizontal ruler) with the following options:

a. The button should use form operations to close the form.

b. Use Close as the text on the button.

c. The meaningful name of the button should be cmdClose. (Hint: Do not type the period.)

Save the form, then view it in Form View.

Switch to Layout View, then resize the width of the City and Country columns to 14". Confirm that the Members form matches Figure 2 on the next page, then save and close the form.

Figure 2: Members Form in Form View

7. Open the DiveTrips form in Design View. Select the Location, City, and State labels in the Detail section and align their edges using the Left option. Select the ID, DiveMasterID, and Location controls in the form and align their edges using the Right option. Confirm the form matches Figure 3 on the next page, then save and close the DiveTrips form.

Figure 3: DiveTrips Form in Design View

8. Create a blank form and save it using DiveInfo as the name.

9. View the DiveInfo form in Layout View, add a tab control to the form, then modify it as described below:

a. Change the Name property of the first tab to Dives. (Hint: Do not type the period.)

b. Change the Name property of the second tab to Members. (Hint: Do not type the period.)

10. With the DiveInfo form still open in Layout View, click on the Dives tab and add a command button with the following options:

a. The button should use form operations to open the DiveTrips form.

b. The DiveTrips form should open and show all records. (Hint: This is the default option in the Command Button Wizard.)

c. The text on the button should be Dive Trip Entry. (Hint: Do not type the period.)

d. The meaningful name of the button should be cmdDiveTripEntry. (Hint: Do not type the period.)

e. The command button should be resized as shown in Figure 4 below.

Save and close the DiveInfo form.

Figure 4: Dives Tab of the DiveInfo Form in Layout View

11. Open the Divemasters form in Form View. Using the first combo box, change the name of the first record (ID 1) from Schwartz to Lincoln. (Hint: Do not type the period.)

12. Switch to viewing the Divemasters form in Design View, then set the Row Source of the Country combo box to CountryList.

13. Expand the size of the Detail section so the bottom edge of the section reaches the 4" mark on the vertical ruler.

14. Using the Option Group Wizard, add an option group to the form and position it under the Participants text box as shown in Figure 5 on the next page with the following options:

a. The label names should be 1, 2, 3, 4, and 5. (Hint: Do not type the period.)

b. Do not choose a default option.

c. The values should be 1, 2, 3, 4, and 5 and should correspond to the labels with the same names.

d. Store the value in the Rating field.

e. Choose option buttons with a Flat style.

f. Enter Rating as the caption for the option group.

Switch to viewing the Divemasters form in Form View, then select the 5 as the rating for the first record (ID 1) as shown in Figure 5 below.

Figure 5: Divemasters Form in Form View

Save and close any open objects in your database. Compact and repair your database, close it, then exit Access. Follow the directions on the SAM website to submit your completed project.