Access 2010 In Pictures

12 Change the data type of the Date Purchased field to Date/Time, and its format to Short Date.

13 Save the Albums table, then close it.

TIP: If alert windows appear, just click the Yes button.

14 Open the Relationships window.

15 Add the three tables: Albums, Artists, and Tracks.

16 Link the Artist ID fields of the Artists and Albums tables.

17 Link the Album ID field of the Albums table to the Album ID field in the Tracks table.