-
Change the data type of the Date Purchased field to Date/Time, and its format to 12/31/99.
-
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.
- Open the Relationship design window.
- Add the two tables: Books and Authors.
- the Author ID fields of the Author and Books tables.