right<\/p>\n
-580505<\/p>\n
Shelly Cashman Access 2019 | Module 2: SAM Project 1a<\/p>\n
0<\/p>\n
Shelly Cashman Access 2019 | Module 2: SAM Project 1a<\/p>\n
Personal Insurance, Inc.<\/p>\n
Creating Queries<\/p>\n
3875<\/p>\n
16510<\/p>\n
0<\/p>\n
0<\/p>\n
GETTING STARTED<\/p>\n
Open the file <\/p>\n
SC_AC19_2a_<\/p>\n
FirstLastName<\/p>\n
_1.accdb<\/p>\n
, available for download from the SAM website.<\/p>\n
Save the file as <\/p>\n
SC_AC19_2a_<\/p>\n
FirstLastName<\/p>\n
_2.accdb<\/p>\n
by changing the \u201c1\u201d to a \u201c2\u201d.<\/p>\n
If you do not see the <\/p>\n
.accdb<\/p>\n
file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.<\/p>\n
To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:<\/p>\n
Support_AC19_2a_UmbrellaData.xlsx<\/p>\n
Open the <\/p>\n
_GradingInfoTable<\/p>\n
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.<\/p>\n
PROJECT STEP<\/p>\n
S<\/p>\n
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. <\/p>\n
Create a query based on the <\/p>\n
Customers<\/p>\n
table in Query Design View with the following options:<\/p>\n
Add the <\/p>\n
CustomerID<\/p>\n
, <\/p>\n
FirstName<\/p>\n
, <\/p>\n
LastName<\/p>\n
, and <\/p>\n
DateOfBirth<\/p>\n
fields to the design grid in that order.<\/p>\n
Sort<\/p>\n
the records in <\/p>\n
ascending<\/p>\n
order by <\/p>\n
LastName<\/p>\n
.<\/p>\n
Save the query using <\/p>\n
CustomerLastNameSorted <\/p>\n
as the name.<\/p>\n
Open the query in Datasheet View, then close it, saving if necessary. <\/p>\n
Open the <\/p>\n
HomeownersPremium<\/p>\n
query in Design View and make the following changes to the query:<\/p>\n
Delete<\/p>\n
the <\/p>\n
CustomerID<\/p>\n
column from the design grid.<\/p>\n
Add criteria to select only those records where the <\/p>\n
Premium<\/p>\n
field value is <\/p>\n
greater than<\/p>\n
2,000<\/p>\n
.<\/p>\n
Save the changes to the <\/p>\n
HomeownersPremium<\/p>\n
query.<\/p>\n
Open the query in Datasheet View, then close it, saving if necessary. <\/p>\n
Open the <\/p>\n
LiabilityOrProperty <\/p>\n
query in Design View and add criteria to select only those records where the <\/p>\n
Liability<\/p>\n
field values <\/p>\n
equal<\/p>\n
75,000<\/p>\n
or<\/p>\n
the <\/p>\n
PersonalProperty<\/p>\n
field values <\/p>\n
equal<\/p>\n
75,000<\/p>\n
. Save the changes to the query. Open the query in Datasheet View, confirm that 3 records appear in the <\/p>\n
LiabilityOrProperty<\/p>\n
query results, then close the query, saving if necessary.<\/p>\n
Open the <\/p>\n
ComparisonBirth<\/p>\n
query in Design View and make the following changes to the query:<\/p>\n
Add<\/p>\n
the <\/p>\n
FirstName<\/p>\n
field to the query design grid. The <\/p>\n
FirstName<\/p>\n
field should immediately follow the <\/p>\n
CustomerID<\/p>\n
field.<\/p>\n
Add criteria to select only those records where the <\/p>\n
DateOfBirth<\/p>\n
field value is <\/p>\n
less than 1\/1\/1950<\/p>\n
.<\/p>\n
Set the format to <\/p>\n
Medium Date<\/p>\n
for the <\/p>\n
DateOfBirth<\/p>\n
field.<\/p>\n
Set the caption to <\/p>\n
BirthDate<\/p>\n
for the <\/p>\n
DateOfBirth<\/p>\n
field.<\/p>\n
Save the changes to the <\/p>\n
ComparisonBirth<\/p>\n
query.<\/p>\n
Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary.<\/p>\n
Figure 1: ComparisonBirth query results <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
right -580505 Shelly Cashman Access 2019 | Module 2: SAM Project 1a 0 Shelly Cashman Access 2019 | Module 2:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-38945","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n