right<\/p>\n
-580505<\/p>\n
Shelly Cashman Access 2019 | Module 1: SAM Project 1a<\/p>\n
0<\/p>\n
Shelly Cashman Access 2019 | Module 1: SAM Project 1a<\/p>\n
Personal Insurance, Inc.<\/p>\n
Creating and Modifying Tables and Other Database Objects<\/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_1a_<\/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_1a_<\/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
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’ve decided to create an Access database to better manage information on customers and policies. <\/p>\n
Create a new table in Datasheet View with the following options:<\/p>\n
Rename the default primary key ID field <\/p>\n
PolicyNumber<\/p>\n
and change the data type to <\/p>\n
Short<\/p>\n
Text<\/p>\n
. <\/p>\n
PolicyNumber<\/p>\n
should remain the primary key.<\/p>\n
Add a new field with the name <\/p>\n
CustomerID<\/p>\n
and the <\/p>\n
Short Text<\/p>\n
data type.<\/p>\n
Change the field size of the <\/p>\n
CustomerID<\/p>\n
field to <\/p>\n
7<\/p>\n
.<\/p>\n
Add a new field with the name <\/p>\n
PersonalProperty <\/p>\n
and the <\/p>\n
Currency<\/p>\n
data type.<\/p>\n
Save the table using <\/p>\n
Renters<\/p>\n
as the name.<\/p>\n
With the <\/p>\n
Renters<\/p>\n
table still open in Datasheet View, add the record shown in Table 1. Save and close the <\/p>\n
Renters<\/p>\n
table.<\/p>\n
Table 1: Record for Renters Table<\/p>\n
PolicyNumber<\/p>\n
CustomerID<\/p>\n
PersonalProperty<\/p>\n
R10223<\/p>\n
11004<\/p>\n
75,000<\/p>\n
Create a new table in Design View to store the clients of Personal Insurance, Inc. who own homes as follows:<\/p>\n
Add a field with the name <\/p>\n
PolicyNumber<\/p>\n
and the <\/p>\n
AutoNumber<\/p>\n
data type. <\/p>\n
Set <\/p>\n
PolicyNumber <\/p>\n
as the table’s <\/p>\n
primary key<\/p>\n
.<\/p>\n
Save the table with the name <\/p>\n
Homeowners<\/p>\n
but do not close it.<\/p>\n
With the <\/p>\n
Homeowners<\/p>\n
table still open in Design View, add a second field to the table with the field name <\/p>\n
CustomerID<\/p>\n
and the <\/p>\n
Short Text<\/p>\n
data type. Save the table and then close it.<\/p>\n
Open the <\/p>\n
Customers<\/p>\n
table in Design View and change the name of the field named <\/p>\n
First<\/p>\n
to <\/p>\n
FirstName<\/p>\n
and use <\/p>\n
LastName<\/p>\n
to change the name of the field named <\/p>\n
Last<\/p>\n
.<\/p>\n
With the <\/p>\n
Customers<\/p>\n
table still open in Design View, change the data type property for the <\/p>\n
CustomerID <\/p>\n
field from Number to <\/p>\n
Short Text<\/p>\n
.<\/p>\n
In Design View, add a new field to the <\/p>\n
Customers<\/p>\n","protected":false},"excerpt":{"rendered":"
right -580505 Shelly Cashman Access 2019 | Module 1: SAM Project 1a 0 Shelly Cashman Access 2019 | Module 1:<\/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-45052","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n