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

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

MS Access

Share With

---

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

City Tours Ltd.

MULTIPLE-TABLE FORMS

GETTING STARTED

• Open the file SC_AC19_5b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_5b_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 modify tables and create multiple-table forms.
   
   Open the Customers table in Design View. Use the Input Mask Wizard to create an input mask for the Mobile field. Store the data without symbols in the mask. Save the change to the Customers table without closing it.
2. Switch the Customers table to Datasheet View, and then add a new field named CustomerNotes at the end of the table. Use Long Text as the data type for the field. Save the change to the table.
3. With the Customers table still open in Datasheet View, update the record for customer Martha Bers (who has the CustomerID 10010) by completing the following tasks:
    
   1. Using the input mask, enter 585-555-0111 in the Mobile field.
   2. Enter the text Free tour winner in the CustomerNotes field.
      
      Close the table.
4. Open the Tours table in Design View, and then add a new field with the name TourDetails following the DiscountedCost field. Use Attachment as the data type for the field, and use Description as the caption property for the field. Save the change to the table, and then close the table.
5. Modify the Confirmation Update Form by completing these tasks:
    
   1. Open the Confirmation Update Form in Design View.
   2. Open the field list for the form.
   3. Add the TourNumber field to the form directly above the TourDate label and text box. The left edge of the TourNumber text box is at the 4" mark on the horizontal ruler and the top of the label and control are at the 1" mark on the vertical ruler.
      
      Save the changes to the form, confirm that it matches Figure 1, and close the Confirmation Update Form.

 

6. Select the Guides table, and create a new form in Design View. Update the form by completing these tasks:
    
   1. Add the GuideID, LastName, FirstName, Phone, StartDate, and HourlyRate fields from the Guides table to the Detail section of the form. The left edges of the controls are at the 3" mark on the horizontal ruler. The controls are separated vertically by approximately 0.1". If necessary, reposition the controls and their labels after adding them to the form.
   2. Save the form with the name Guide Data Entry Form but do not close the form.
   3. Add a title to the form. The title of the form should match the name of the form.
      
      Save the form, confirm that it matches Figure 2, and then close the Guide Data Entry Form.

7. Open the Confirmation Master Form in Design View, and ensure that the Use Control Wizards button is selected. 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, LastName, FirstName, and Mobile fields from the Customers table to add to the form.
   3. Accept the default link (Show Customers for each record in<SQL Statement> using CustomerID to link the main form to the subform).
   4. Save the subform as Customers subform (which is the default name).
   5. If necessary, reposition the subform so that the top-left edge of the subform control is at the 2.5" mark on the vertical ruler and the .5" mark on the horizontal ruler. The bottom-right edge of the subform control is at the 4" mark on the vertical ruler and the 6" mark on the horizontal ruler.
      
      Save the form, confirm that it matches Figure 3, and then close it.

8. Open the Confirmation-Tour Form in Design View, and then modify it by resizing the width of the subform so that the right edge is at approximately 6.5" on the horizontal ruler. Confirm that the form matches Figure 4, and then save but do not close it.
9. With the Confirmation-Tour Form still open in Design View, modify the form title by completing the following tasks:
    
   1. Change the font color of the title to Red (2nd column, 7th row of the Standard Colors palette.)
   2. Change the font size of the title text to 22 point.
   3. Apply the Chiseled special effect to the title.
      
      Save the form, confirm that it matches Figure 4, and then close it.

10. Open the Segway Tours Form in Design View, and then modify the form by completing the following tasks:
     
    1. Delete the ChildCost control and accompanying label.
    2. Change the label for the AdultCost control using Price as the new label name.
       
       Save and close the form.
11. Open the Driving Tour-Customer Form in Design View, and then modify the form to match Figure 5 by completing the following tasks:
     
    1. Select the CustomerID, FirstName, LastName, State, and Mobile controls and labels simultaneously.
    2. Adjust the spacing of these controls to have equal vertical spacing.
       
       Save but do not close the form.
12. With the Driving Tour-Customer Form still open in Design View, change the tab order so that users tab to the TourNumber field immediately after the ConfirmationID field. Save and close the form.

13. Open the Basic Confirmations Form in Design View, and then change the background color of the form to Light Gray 2 (1st column, 3rd row of the Standard Colors palette). Save the form but do not close it.
14. With the Basic Confirmations Form still open in Design View, modify the form by performing the following tasks:
     
    1. Select the ConfirmationID label, ConfirmationID control, CustomerID label, and CustomerID control simultaneously. Align the controls to the top.
    2. Select the LastName control and the FirstName control simultaneously. Do not select any labels, and make sure the TotalTourCost control is not selected. Align the controls to the left.
       
       Save but do not close the form.
15. With the Basic Confirmations Form still open in Design View, add a title to the form using Basic Confirmations Form as the name. (Hint: This is the default name.) Save but do not close the form.
16. With the Basic Confirmations Form still open in Design View, change the Tab Stop property to No for the TotalTourCost control. Save the form, confirm that it matches Figure 6, and close the Basic Confirmations Form.

17. Open the Guides Special Skills Query in Design View, and then modify the query to find all guides hired after 1/1/2017 who have Spanish skills. (Hint: The SpecialSkills field has the Long Text data type.) The query should return one record. Run the query, and then save and close it.

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.