Question: 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
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... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help