Homework answers / question archive / Shelly Cashman Access 2019 | Module 7: SAM Project 1b City Tours Ltd

Shelly Cashman Access 2019 | Module 7: SAM Project 1b City Tours Ltd

MS Access

Share With

---

Shelly Cashman Access 2019 | Module 7: SAM Project 1b

City Tours Ltd.

ADVANCED FORM TECHNIQUES

GETTING STARTED

• Open the file SC_AC19_7b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_7b_FirstLastName_2.accdb by changing the “1” to a “2”.
  • 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.
• 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. City Tours Ltd. is a company that provides tours in a city that attracts tourists from around the country. As a customer service manager for the company, you need to be able to create forms that have elements such as combo boxes for finding records, and command buttons to make forms more user-friendly.
   
   Create a new form in Design View by completing the following tasks:
    
   1. Open the Property Sheet for the new form, and then apply the Record Source for the form to the SE_TourCustomers query.
   2. Add the FirstName, LastName, Mobile, and TourNumber fields (in that order) to the form. The left edges of the text boxes are at the 2" mark on the horizontal ruler. The top edge of the FirstName field is at the .5" mark on the vertical ruler.
   3. Adjust the sizing of the controls so that the right edges of the text boxes are at the 3.5" mark on the horizontal ruler.
   4. Add the CustomerID field to the form, and then move the control and its label so that the left edge of the label is at the 1.5" mark on the horizontal ruler.
   5. Save the form using SE_TourCustomers Form as the name, confirm that the form matches Figure 1 and close it.

2. Open the Groups Master Form in Design View, and then complete the following tasks:
    
   1. Add a title to the form.
   2. Expand the Form Header section so that the bottom of the Form Header section is at the 1" mark on the vertical ruler.
   3. Change the background color of the Detail section to Light Gray 1 (1st column, 2nd row of the Standard Colors palette).
      
      Confirm that the form matches Figure 2, and then save and close the Groups Master Form.

3. Open the Confirmation Master Form in Design View. Use the Combo Box Wizard to add a combo box to the Detail section of the form with these options:
    
   1. To display the current data from the bound record source, select I want the combo box to get the values from another table or query.
   2. Select the Customers table as the source of the combo box values.
   3. Add the CustomerID, LastName, and FirstName fields to the combo box.
   4. Sort the combo box by the CustomerID field in ascending order.
   5. Remove the check mark from the "Hide key column (recommended)" check box.
   6. Select Store that value in this field and assign CustomerID as the field in which to store a value.
   7. Assign CustomerID as the name of the combo box.
   8. Move the combo box control and label so that the top edges are at the 2" mark on the vertical ruler and the left edge of the control is at the 3" mark on the horizontal ruler.
      
      Confirm that the form matches Figure 3, and then save and close the Confirmation Master Form.

4. Modify the Customers and Driving Tours Form by completing the following tasks:
    
   1. Open the Customers and Driving Tours Form in Design View.
   2. Add a text box control to the form. The left edge of the control is at the 4" mark on the horizontal ruler.
   3. Create a calculated control that concatenates the FirstName field, a space, and the LastName field. (Hint: Your control should contain the formula =[FirstName]&' '&[LastName]).
   4. Update the label, using Name as the new text.
   5. If necessary, move and resize the text box control and label so that the left edge of the control is at the 4" mark on the horizontal ruler and the bottom edges of the label and control are at the .5" mark on the vertical ruler.
      
      Confirm that the form matches Figure 4, and then save and close the Customers and Driving Tours Form.

5. Open the Confirmations and Customers Form in Design View, and then use the Subform/Subreport Wizard to add a subform with the following options:
    
   1. Use the Customers table for the subform.
   2. Select the CustomerID, FirstName, LastName, and Mobile fields (in that order) from the Customers table to add to the subform.
   3. Accept the default link (Show Customers for each record in Confirmations using CustomerID).
   4. Save the subform as Customers subform (which is the default name).
   5. Resize the width of the subform. The right edge of the subform is at the 6.5" mark on the horizontal ruler.
   6. If necessary, move the subform so that the top-left edge of the subform control is at the 1" mark on the horizontal ruler and the 1" mark on the vertical ruler. The bottom-right edge of the subform control is at the 6.5" mark on the horizontal ruler and approximately the 3" mark on the vertical ruler.
      
      Confirm that the report matches Figure 5, and then save and close the Confirmations and Customers Form.

6. Open the SegwayTours Form in Design View. Use the Command Button Wizard to add a command button with the following options:
    
   1. Select Form Operations as the category and Close Form as the action.
   2. Select the text option button with the text Close Form.
   3. Assign the name Close Form to the button.
   4. Position the button so that the left edge of the button is at the 4" mark on the horizontal ruler and the top edge of the button is at the 2" mark on the vertical ruler.
      
      Confirm that the form matches Figure 6, and then save and close the SegwayTours Form.

7. Open the Guide Search Form in Design View and then modify it by completing the following tasks:
    
   1. Select the Name to Find control. (Hint: Select the control not the label.)
   2. Open the Property Sheet for the control, and then change the name of the control using Name_to_Find as the new name.
   3. With the Property Sheet still open, select the Name to Find label, and then change the special effect for the label to Chiseled.
      
      Close the Property Sheet, save the changes, and close the form.
8. Open the Tours Update Form in Design View, and then place a rectangle around the Name to Find label and control. The top-left edge of the rectangle is at the 2.5" mark on the horizontal ruler and the .5" mark on the vertical ruler. The bottom-right edge of the rectangle is at approximately the 5.9" mark on the horizontal ruler and approximately the 1.2" mark on the vertical ruler. Confirm that the form matches Figure 7, and then save the form and close it.

9. Open the Customer by Tours Form in Design View, then complete the following tasks:
    
   1. Add a tab control to the form. The top-left edge of the control is at the 1" mark on the horizontal ruler and the 1" mark on the vertical ruler. The bottom-right edge of the control is at the 5" mark on the horizontal ruler and the 3" mark on the vertical ruler.
   2. Change the name of the first tab using Datasheet as the tab name.
   3. Change the name of the second tab using Chart as the tab name.
      
      Confirm that the form matches Figure 8, and then save and close the Customer by Tours Form.

10. Open the Hometours by Customer Form in Design View, and then make the following changes:
     
    1. Delete the CustomerID control and label.
    2. Save the form and then switch to Datasheet View.
    3. Resize all columns in the Hometours by Customer Form to best fit the data they contain.
       
       Save and close the form.
11. Open the TotalCost Data Form in Design View, and then select the Datasheet tab control. Resize the subform so that the top-left edge is at approximately the .6" mark on the horizontal ruler and the 2" mark on the vertical ruler and the width is approximately 4". (Hint: The right edge of the subform will be at approximately 5" mark on horizontal ruler.) Confirm that the form matches Figure 9, and then save, but do not close the TotalCost Data Form.

12. With the TotalCost Data Form still open in Design View, modify it by completing the following tasks:
     
    1. Select the Chart tab control, and then select the chart.
    2. Edit the chart object, and then change the chart type to Clustered Bar.
    3. Change the placement of the legend to Bottom.
       
       Confirm that the form matches Figure 10, and then save and close the TotalCost Data Form.

13. Open the Customer Master Form in Design View. Add a combo box control to the Form Header. Use the Combo Box Wizard to create the combo box with these options:
     
    1. Ensure the Find a record on my form based on the value I selected in my combo box. option button is selected.
    2. Add the State field as the field to include in the combo box.
    3. Ensure that there is a check mark in the "Hide key column (recommended)" check box.
    4. Assign the label State to Find to the combo box.
    5. If necessary, move and resize the combo box control so that the left edge of the combo box control is at the 5" mark on the horizontal ruler and the right edge of the control is at the 6" mark on the horizontal ruler. The bottom edges of the label and control are at the 1" mark on the vertical ruler.
       
       Confirm that the form matches Figure 11, and then save and close the Customer Master Form.

14. Open the Guide Combo Sort Form in Design View, and then modify the combo box control by completing the following tasks:
     
    1. Select the Name to Find control. (Hint: Select the control not the label.)
    2. Open the Property Sheet for the control, and then click the Row Source property.
    3. Click the Build button, and then sort the last names in ascending order.
       
       Save the changes to the query, close the query window, save the changes to the form, and then close the form.

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