Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access database named
Exp19_Access_Ch09_Cap_Trading_Cards.accdb. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

You will first establish relationships between the Cards, Brands, and Rarity tables based on the common fields that they share.

Open the Relationships window. Add the
Cards,
Brands, and
Rarity tables to the layout.

0

3

After creating a relationship between two tables, you will enforce referential integrity, which ensures that the relationship will remain intact if/when data is updated in either table. Furthermore, you will ensure that all changes to the primary key in your Cards table will be reflected in the foreign keys that exist in the Rarity table by selecting the Cascade Update Related Fields option.

Create a relationship between the
Cards and
Rarity tables tables, ensuring you check the
Enforce Referential Integrity and
Cascade Update Related Fields options for the relationship.

12

4

After also establishing the relationship between the Cards and Brands tables, in the same manner, you will analyze the database to identify any flaws in the design as well as suggested low-risk improvements that can be made to your database.

Create a relationship between the