Shelly Cashman Access 365/2021 | Module 5: SAM Project 1a #shellycashman #module5 #samproject1a

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
[ Ссылка ]

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
singhal.agrawal.bharati@gmail.com

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

PROJECT STEPS
1. Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, 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 PhoneNumber 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 Xavier Wilcox (who has the CustomerID 11010) by completing the following tasks:

a. Using the input mask, enter 717-555-3443 in the PhoneNumber field.
b. Enter the text Has two rental properties in the CustomerNotes field.

Close the table.
4. Open the Claims table in Design View, and then add a new field with the name ClaimEstimate following the ClaimAmount field. Use Attachment as the data type for the field, and use Damage Estimate as the caption property for the field. Save the change to the table, and then close the table.
5. Modify the Customer Data Entry Form by completing these tasks:

a. Open the Customer Data Entry Form in Design View.
b. Open the field list for the form.
c. Add the PhoneNumber field to the form directly above the Region label and text box. The left edge of the PhoneNumber text box is at the 5" mark on the horizontal ruler and the top of the label and control are approximately at the 1.3" mark on the vertical ruler.

Save the changes to the form, confirm that it matches Figure 1, and close the Customer Data Entry Form.
Figure 1: Customer Data Entry Form—Design View



6. Select the Umbrella table, and create a new form in Design View. Update the form by completing these tasks:

a. Add the PolicyNumber, CustomerID, Premium, and Coverage fields 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.2". If necessary, reposition the controls and their labels after adding them to the form.
b. Save the form with the name Umbrella Data Entry Form but do not close the form.


shelly cashman excel 2019 | module 5: sam project 1a,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 2: sam project 1a,new perspectives word 2019 | module 10: sam project 1a,#shelly cashman excel 2019 | module 1: sam project 1b,module 5 sam project 1a,new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 1: end of module project 2

свернуть