Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Access Assignment #1: Its A Grind Coffee. 1. Create the tables from the data given. (Hint: there should be 5 tables) 2. Create the E-R
Access Assignment #1: Its A Grind Coffee.
1. Create the tables from the data given. (Hint: there should be 5 tables)
2. Create the E-R diagram with the tables that you have created.
3. Create the relationships for the table. (Hint: All relationships are 1 to many)
a. For relationships: referential integrity should be enforced.
4. You can enter the data into the database in three different ways:
a. Manually enter data using the datasheet view
b. Create a form to enter data and add button controls for navigation
c. Import data from an external Excel file.
5. Create a new column called Book Revenue and have this column calculate the revenue from the sales.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started