You will plan the information that goes into an Access database It should contain at least two tables , with appropriate relationships Fill out the planning sheet below Assume that each customer will get his her lawn mowed on at least two different dates and will have one other kind of service performed It should contain at least two tables , with appropriate relationships Fill out the planning sheet below Requirements make sure that Each table has at least five fields Each field has an appropriate data type For all Short Text fields, limit the field size appropriately Each table has a primary key field with unique data (Remember, one of the primary key fields must be a field in the second table This is the field that will be used to create a relationship with the other table ) You indicate which field will be used to create a relationship with the other table Each table has at least five records (Remember referential integrityrecords in one table must coincide with a record in the other table ) Customer List Planning Sheet Field Name Data Type (AutoNumber, Text, Number, Date, Y N, etc ) Modify Properties for Short Text Data Type (Field Size, Input Mask, Caption, etc ) Will it be a primary key (Usually the first field unique values only) Second Table Planning Sheet Field Name Data Type Modify Properties for Short Text Data Type Will it be a primary key Will it be a foreign (related) key

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Dec 21, 2020

You will plan the information that goes into an Access database. It should contain at least two tables , with appropriate relationships . Fill out

You will plan the information that goes into an Access database. It should contain at least two tables, with appropriate relationships. Fill out the planning sheet below.

Assume that each customer will get his/her lawn mowed on at least two different dates and will have one other kind of service performed.

. It should contain at least two tables, with appropriate relationships. Fill out the planning sheet below.

Requirements make sure that:

Each table has at least five fields.
Each field has an appropriate data type. For all Short Text fields, limit the field size appropriately.
Each table has a primary key field with unique data. (Remember, one of the primary key fields must be a field in the second table. This is the field that will be used to create a relationship with the other table.)
You indicate which field will be used to create a relationship with the other table.
Each table has at least five records. (Remember referential integrity¾records in one table must coincide with a record in the other table.)

Customer List Planning Sheet

Field Name	Data Type (AutoNumber, Text, Number, Date, Y/N, etc.)	Modify Properties for Short Text Data Type (Field Size, Input Mask, Caption, etc.)	Will it be a primary key? (Usually the first field; unique values only)

Second Table Planning Sheet

Field Name

Data Type

Modify Properties for Short Text Data Type

Will it be a primary key?

Will it be a foreign (related) key?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Table 1 Customer List Field NameData TypeModify PropertiesWill it be a primary key ClientIDAutoNumberYes NameShort TextField Size 30No AddressShort TextField Size 60No PhoneShort TextField Size 15No S... blur-text-image