Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a
Personal Insurance, Inc.
Administering a Database System
GETTING STARTED
Save the file SC_AC365_2021_9a_FirstLastName_1.accdb as SC_AC365_2021_9a_FirstLastName_2.accdb Edit the file name by changing “1” to “2”.
If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
To complete this Project, you will also need the following files:Support_AC365_2021_9a_ClaimTypes.accdb
With the file SC_AC365_2021_9a_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table. If the table does not display your name, delete the file and download a new copy.
PROJECT STEPS
Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, you need to understand database administration tasks. Open the database in Backstage View, and then click the View and edit database properties link. When the Properties dialog box displays, create a custom property for the database as described below:
With the database still open in Backstage View, click the Options tab. Select the Main Menu Navigation Form as the Display Form for the database as shown in Figure 2. (Hint: The Display Form is sometimes referred to as the startup form.)
Save the changes to the options. (Hint: When the Access dialog box appears and displays the message, “You must close and reopen the current database for the specified option to take effect”, click the OK button.)
Open the ClaimsRep table in Design View, and then create a custom input mask for the ClaimRepNumber field as described below:
The ClaimRepNumber field must consist of two letters and two numbers.
All letters should display in upper case. (Hint: Enter >LL99 as the input mask.)
Save the changes to the table but do not close it.
With the ClaimsRep table still open in Design View, modify the ClaimsRepName multiple-field index by completing the following tasks:
Open the Indexes dialog box.
Change the sort order for the LastName field to Descending.
Save the changes to the ClaimsRep table and then close it.
Open the Customers table in Design View, and then create a single-field index on the LastName field. The index should allow duplicate values. Save the changes to the table design but do not close the table.
With the Customers table still open in Design View, create a multiple-field index as described below: Use Location as the name of the index. (Hint: Be careful not to include spaces after the index name.)
Use the State field, sorted in Descending order, as the first field in the index.
Use the City field, sorted in Ascending order, as the second field in the index.
Save the changes to the Customers table and then close it.
Open the Claims table in Design View, and then open the Property Sheet for the table and make the following updates:
Create a validation rule for the table requiring that the Paid field value is always less than or equal to the ClaimAmount field value. (Hint: Enter [Paid]
The post Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a
Personal Insurance, appeared first on Scholars Hub Blog.
