Access 2003 In Pictures

• Database Basics
• Working with Tables
• Working with Forms
• Working with Queries
• Working with Reports

5. Set the Artist ID field as the key field.
   The table design should look like this:

   

6. Save the table as Artists, then close it.
7. Create a new table with the following fields (data type in parentheses):
   Track ID (Autonumber)
   Album ID (Text)
   Track Name (Text)
   Track Length (Text)
   Favorite Track on Album? (Yes/No)
8. Set the Track ID field as the key field.
   The table design should look like this: