PROJECT STEPS City Tours Ltd. is a company that provides tours in a city that a

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

PROJECT STEPS
City Tours Ltd. is a company that provides tours in a city that a

PROJECT STEPS
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.
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.
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:

Using the input mask, enter 585-555-0111 in the Mobile field.
Enter the text Free tour winner in the CustomerNotes field.

Close the table.
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.
Modify the Confirmation Update Form by completing these tasks:

Open the Confirmation Update Form in Design View.
Open the field list for the form.
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.
Select the Guides table, and create a new form in Design View. Update the form by completing these tasks:

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.
Save the form with the name Guide Data Entry Form but do not close the form.
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.
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:

Use the Customers table for the subform.
Select the CustomerID, LastName, FirstName, and Mobile fields from the Customers table to add to the form.
Accept the default link (Show Customers for each record in using CustomerID to link the main form to the subform).
Save the subform as Customers subform (which is the default name).
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.
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.
With the Confirmation-Tour Form still open in Design View, modify the form title by completing the following tasks:

Change the font color of the title to Red (2nd column, 7th row of the Standard Colors palette.)
Change the font size of the title text to 22 point.
Apply the Chiseled special effect to the title.

Save the form, confirm that it matches Figure 4, and then close it.
Open the Segway Tours Form in Design View, and then modify the form by completing the following tasks:

Delete the ChildCost control and accompanying label.
Change the label for the AdultCost control using Price as the new label name.

Save and close the form.
Open the Driving Tour-Customer Form in Design View, and then modify the form to match Figure 5 by completing the following tasks:

Select the CustomerID, FirstName, LastName, State, and Mobile controls and labels simultaneously.
Adjust the spacing of these controls to have equal vertical spacing.

Save but do not close the form.
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.
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.
With the Basic Confirmations Form still open in Design View, modify the form by performing the following tasks:

Select the ConfirmationID label, ConfirmationID control, CustomerID label, and CustomerID control simultaneously. Align the controls to the top.
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.
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.
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.
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.
Figure 1: Confirmation Update Form—Design View
Figure 2: Guide Data Entry Form—Design View
Figure 3: Confirmation Master Form—Design View
Figure 4: Confirmation-Tour Form—Design View
Figure 5: Driving Tour-Customer Form—Design View
Figure 6: Basic Confirmations Form—Design View
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 website to submit your completed project.

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!