Programming Challenges

1. Create a new Access database with two tables named Books and Authors. The Books table should have the following fields and properties:

Book_Id: AutoNumber

Author_Id: Number (Long Integer)

Book_Title: Text

Page_Count: Number (Long Integer) Publisher: Text Publish_Date: Date/Time Sales_Price: Currency

The Authors table should have the following fields and properties:

• Author_Id: AutoNumber

• Author_LastName: Text

• Author_FirstName: Text

Create a one-to-many relationship between the Books and Authors tables using the Author Id field. Insert records into both tables and save the database.

0 0

Post a comment