Base In Pictures

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

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

   

6. Save the table as Authors, then close it.
7. Open the Books table and view it in Design View.
8. Change the name of the Author field to Author ID.
   Set its data type to Integer.