Shelly Cashman Access 2019 | Module 3: SAM Project 1a | Help in Homework | #homeworkanswers

24 / 7 Live Support
support@helpinhomework.org
+44-7309655268
+91-9828671065

Shelly Cashman Access 2019 | Module 3: SAM Project 1a
Personal Insurance, Inc.
Maintaining a Database
GETTING STARTED
• Open the file SC_AC19_3a_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_3a_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. Personal Insurance, Inc. needs to update their database on a regular basis. For example, customers move, change coverage limits, and add and delete policies. In Query Design View, create an Update query based on the Renters table.
2. Select the PolicyNumber and PersonalProperty fields from the Renters table.
3. Add criteria to select only those records where the PolicyNumber field values equal R11234.
4. Update the PersonalProperty field with 100,000 as the new field value.
5. Save the query using UpdatePersonalProperty as the name, run it, and then close it. The query should update one record.
6. In Query Design View, create a Make Table query that selects all the fields from the Homeowners table in the same order that they are listed in the field list. Select all the fields individually for the design grid; do not use the (*) asterisk.
7. Add criteria to select only those records where the PropertyDamage field value is greater than or equal to 750,000.
8. In the Make Table dialog box, assign the name HighDamageAmts to the new table.
9. Save the query using MakeHighDamageAmts as the name, run it, and then close the query. The new HighDamageAmts table should contain five records.
10. In Query Design View, create a Delete query for the Renters table by performing the following tasks:
11. Select the PersonalProperty field from the Renters table.
12. Add criteria to delete only those records where the PersonalProperty field values equal 45,000.
13. Save the query using DeletePersonalProperty as the name, run it, and then close it. The query should delete one record.
14. Customers who reside in West Virginia should be appended to the MidAtlantic table. In Query Design View, create an Append query for the Customers table.
15. Select all the fields from the Customers table in the same order that they are listed in the field list. Select all the fields individually for the design grid; do not use the (*) asterisk.
16. Add the criteria WV to the State field.
17. Select MidAtlantic as the destination table in the Append dialog box.
18. Save the query using AppendMidAtlantic as the name, run it, and then close it. The query should append two records.
19. Create a Split Form for the Umbrella table and save it, using Umbrella Split Form as the name. Do not close the form.
20. Switch the Umbrella Split Form to Form View, navigate to the record with the PolicyNumber field value U10002, and delete the record. Close the Umbrella Split Form.
21. Because you are a regional manager for Personal Insurance, Inc., it is useful to know in which regions of the country each customer resides. Open the Customers table in Design View and perform the following tasks:
22. Move the Region field so that it immediately follows the PostalCode field. Save the changes to the table design.
23. Use the Lookup Wizard to change the Region field to a Lookup field. Select the option to type in the values that you want.
24. Enter the values shown in Table 1 in the order shown.
25. Limit the values to only the items in the list, and do not allow multiple values for the field.
26. Save the changes to the table design, but do not close the table.

Видео Shelly Cashman Access 2019 | Module 3: SAM Project 1a | Help in Homework | #homeworkanswers канала Help In Homework