1. Open the Relationships window and add the Billboard table to it. Create a one-to-many relationship between the BillboardID field in the Billboard table and the BillboardID field in the Rentals Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationship.
2. With the Relationships window still open, modify the relationship between the AdRep and Advertiser tables to cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships and close the window.
3. Open the Billboard table in Design View. Use the Lookup Wizard to change the Type field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Digital, Bulletin, Poster, and Junior Poster. Limit the field values to only the items in the list, and do not allow multiple values for the field.
4. With the Billboard table still open in Design View, delete the Facing
5. With the Billboard table still open in Design View, add a new field named SqrFt after the Width This field is a calculated field. Use the expression Height * Width to calculate the field values. Save and close the Billboard table.
6. Open the AdRep table in Design View and move the PhoneNumber field so that it appears after the PostalCode Save and close the AdRep table.
7. Open the Rentals table in Design View and make the following updates:
   1. Change the BillboardID field to a required field.
   2. Change the Field Size property for the Facing field to 6.
   3. Change the data type of the Cost field to Currency, and change the Decimal Places property to 0.
   4. Change the default value of the Months field to 1.

Save the changes to the Rentals table. (Hint: Because there was a change to a field size, the “Some data may be lost” warning message will appear. Continue saving the table. The data fits within the valid ranges, so ignore this warning and continue saving the table.)

8. Switch to viewing the Rentals table in Datasheet View, and then add the Total row to the table. The Total row should average the values in the Cost Sort the records in ascending order by the AdvertiserID field. Save the changes to the table, and then close the datasheet.

DETAILED ASSIGNMENT

2020092920273620180429204647instructions_sc_ac16_3a