Access 2003 In Pictures

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

9. Save the table as Tracks, then close it.
10. Open the CDs table and view it in Design View.
11. Change the name of the Artist field to Artist ID. Set its data type to Number.
12. Change the data type of the Date Purchased field to Date/Time, and its format to Short Date.

    

13. Save the CDs table, then close it.
    TIP: An alert window will appear saying there was an error, due to switching the Artist data type to Number. Click the button.