Base In Pictures

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

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

   

10. Save the Books table, then close it.
    TIP: An alert window will appear saying there was an error, due to changing the Date Purchased data type.
    Click the button.
11. Open the Relationship design window.
12. Add the two tables: Books and Authors.
13. the Author ID fields of the Author and Books tables.