#AccessModule2SAMProject1a
#Personal Insurance, Inc
#ShellyCashmanAccess365/2021
=============================================
Contact us:
WhatsApp:+923005083849
WhatsAppLink:[ Ссылка ]
Email: myit51214@gmail.com
============================================

#SC_AC365_2021_2a_FirstLastName_1accdb
#SC_AC365_2021_2a
#SC_AC365_2021_2a_FirstLastName
#SC_AC365_2021_2a_FirstLastName_2accdb
#AccessModule2
#samproject1a
#AccessModule2SAMProject1a
#ShellyCashmanAccess365/2021
#NewPerspectiveAccess365/2021
#samproject1b
#sam
#ShellyCashmanAccess2019
#NewPerspectiveAccess2019
#SAMProject1B

Personal Insurance, Inc. is a national company that insures homeowners and renters. It also offers umbrella policies that provide additional coverage. As a regional manager, you need to be able to query the database to help make decisions and to answer questions from other employees.

Create a query based on the Customers table in Query Design View with the following options:

Add the CustomerID, FirstName, LastName, and DateOfBirth fields to the design grid in that order.

Sort the records in ascending order by LastName.



Open the StateCitySort query in Design View and make the following changes:

Move the State field to the beginning of the design grid so that the order of the fields in the grid is State, City, FirstName, and LastName.







Add parameter criteria to the State field to replace the current "FL" criteria. The new parameter criteria should prompt the user with Enter desired state as the text.

Save the changes to the query.

View the query in Datasheet View. Enter PA when prompted.
Confirm that 8 records appear in the query results then close the query, saving if necessary.

Open the TopValuesProperty query in Design View. Modify the query to sort the PropertyDamage amounts in descending order. Change the Return value to display only the top 5 records. Open the query in Datasheet view, then close the query, saving if necessary.

Open the TotalCoverage query in Design View. Modify the query by creating a calculated field. Enter TotalCoverage: [Liability]+[PropertyDamage] in the Zoom dialog box of the first empty column in the design grid. Save the query. Open the query in Datasheet View, then close the query, saving if necessary.

Open the AveragePremium query in Design View and perform the following tasks:

Add a Totals row to the design grid.

Select Avg as the calculation in the Total row.

Set the caption to Avg Prem for the Premium field.

Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query, saving if necessary.

Figure 2: AveragePremium query results

Open the CustomersWithoutHomes query in Design View and perform the following tasks:

Change the join property for the relationship between the Customers and Homeowners tables to select ALL records from the Customers table and only those records from the Homeowners table where the joined fields are equal.

Add the Is Null criteria for the PolicyNumber field and add an Ascending sort order on the LastName field.
Save the changes to the query. Open the query in Datasheet View and confirm that there are 21 records in the query result. Close the query, saving if necessary.

Open the UniqueStates query in Design View. Modify the query to list all states only once. Save the changes to the query. Open the query in Datasheet View and confirm that there are 15 records in the query result. Close the query, saving if necessary.

Create a crosstab query based on the MidAtlantic table with the following options:

Use only data from the MidAtlantic table in the crosstab.

Use the State field for the row headings.

Use the City field for the column headings.

Use a Count of the CustomerID field as the calculated value for each row and column intersection, and include row sums in the crosstab query.

Save the query using State-City Crosstab as the name.
View the query, then save and close it.

Export the Renters table as an Excel file (.xlsx) with the name Renters to the same folder as the one that stores your database. Do not export the data with formatting and layout. Save the export steps using Export-Renters as the name. Do not add a description.
Save the changes to the table and close it.

Use the Import Spreadsheet Wizard to import the data from the Support_AC365_2021_2a_UmbrellaData.xlsx support file and append it to the Umbrella table. Do not save the Import steps. Open the Umbrella table in Datasheet View. It should contain 14 records. Close the table.

Rename the PennsylvaniaOwners query as PennsylvaniaCustomers in the Navigation Pane.

Group the objects in the Navigation Pane by Tables and Related Views.

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

свернуть