CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS

right

-580505

Shelly Cashman Access 2019 | Module 1: SAM Project 1a

Personal Insurance, Inc.

Creating and Modifying Tables and Other Database Objects

3875

16510

GETTING STARTED

Open the file

SC_AC19_1a_

FirstLastName

_1.accdb

, available for download from the SAM website.

Save the file as

SC_AC19_1a_

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 STEP

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.

Create a new table in Datasheet View with the following options:

Rename the default primary key ID field

PolicyNumber

and change the data type to

Short

Text

PolicyNumber

should remain the primary key.

Add a new field with the name

CustomerID

and the

Short Text

data type.

Change the field size of the

CustomerID

field to

Add a new field with the name

PersonalProperty

and the

Currency

data type.

Save the table using

Renters

as the name.

With the

Renters

table still open in Datasheet View, add the record shown in Table 1. Save and close the

Renters

table.

Table 1: Record for Renters Table

PolicyNumber

CustomerID

PersonalProperty

R10223

11004

75,000

Create a new table in Design View to store the clients of Personal Insurance, Inc. who own homes as follows:

Add a field with the name

PolicyNumber

and the

AutoNumber

data type.

Set

PolicyNumber

as the table’s

primary key

Save the table with the name

Homeowners

but do not close it.

With the

Homeowners

table still open in Design View, add a second field to the table with the field name

CustomerID

and the

Short Text

data type. Save the table and then close it.

Open the

Customers

table in Design View and change the name of the field named

First

FirstName

and use

LastName

to change the name of the field named

Last

With the

Customers

table still open in Design View, change the data type property for the

CustomerID

field from Number to

Short Text

In Design View, add a new field to the

Customers