PART 2:

You must have the Microsoft Access database system installed for this part.

Using your physical model, create a database in Microsoft Access. Each entity in your diagram represents a table object in your database.

1. Start by creating a new, blank database.

Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.

Chapter 2: åtting Started with Access / How to Create a Blank Database/p>

1. Create the tables in your database. Use the table names, field names, primary key information and data types from your physical model to design your tables.

Hints:

• Use the utoNumber$ata type to assign unique values for primary key fields.
• Set the required field property to yes for fields that must have a value. For fields you had identified as nullable (allowed to be blank), you can leave the default value of no.

Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.

Chapter 3: òeating Access Tables / Creating a New Table / Changing a Table Design / Setting the Primary Key/p>

For extra help see Optional Resources for Assignment under the Academic Tools, Library link:

Required property (Access)

https://docs.microsoft.com/en-us/office/vba/access…

1. Open each table you created in the design view and take a screenshot (showing the fields, data types and field properties in the design view for each table you defined).

1. Append the screen shots to the end of the document before the final reference page.