Question: Using Microsoft Access, you are required to design a database based on the following ERD, which contains the following: Create 3 Tables with their fields,

Using Microsoft Access, you are required to design a database based on the following ERD,
which contains the following:
Create 3 Tables with their fields, Primary keys, and the appropriate data type for
each field.
Create the relationship between Salesperson and Product.
Fill all tables with data (3 Records in each table).
Create 1 Query and 1 Report.
Using Microsoft Access, you are required to design a database based

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Using Microsoft Access, you are required to design a database based on the following ERD, which contains the following: Create 3 Tables with their fields, Primary keys, and the appropriate data type...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

a. Create a complete ERD with entities and relationships using given scenario. Make sure that relationship types, participation and cardinality is shown in ERD. b. Convert the ERD to a set of...

Q:

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Q:

INFORM ATION TECHNOLOGY 3 0 2 L AB B L AB ASSIGNMENT 1 Due: January 2 5 , 1 1 : 5 9 pm . Topics: Create a table with formatted fields. Set up filters for a table. Using Microsoft Access, create a...

Q:

(( EITHER ATTATCH THE DOCUMENT HERE, IF POSSIBLE OR SIMPLY POST THE WAY IT SAYS OR YOU CAN SEND IT TO MY EMAIL: jaspreet_12376@yahoo.com )) ONLY ON MICROSOFT ACCESS Assignment #1A: Firefighters After...

Q:

Create a database using Microsoft access for a small Computer Consulting Company. 1. You must determine how many tables and the appropriate attributes (fields) required. The type and size of each...

Q:

Problems (60 points): 1. Transform each of the following ER or EER diagrams to a relational schema that shows referential integrity constraints and functional dependencies [see the Mapping Example...

Q:

Using Microsoft Access, you are requested to define a database called Student Advising consisting of one table Students 93. 112 marksI LO S In this question you are requested to do the following: A....

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

Give the correct name for the following alkanes: 1. CH3 - CH2- CH3: a) propyl b) butane c) propane 2. CH3 - CH2 - CH2 - CH3: a) propane b) butane c) pentane} 3. CH3- CH3 : a) ethane b) propane c)...

Q:

Wilbur Corporation is considering replacing a machine. The replacement will cut operating expenses by $24,000 per year for each of the five years the new machine is expected to last. Although the old...

Q:

You believe the Gordon growth model is appropriate to value the stock of Apex Autos Corp. The firm had an EPS of $5.00 last year. The plowback ratio is 0.50. The firm is expected to earn an ROE of 15...

Q:

Question 4 Noninterest revenue sources for a bank are called: commitment fees on loans. fee income. supplemental income. noninterest margin. None of the options are correct.

Q:

(Appendices) Courtney, age 22, is a junior at a large midwestern university. In late March, she filed applications for summer jobs with three companies. However, she does not want to start work until...

Q:

(Appendices) The Unemployment Insurance Modernization Act was included in the fiscal stimulus package of early 2009. The act was designed to modernize and make corrections to serious defects found in...

Q:

(Appendices) Kelly, age 35, spends most of her time at home taking care of her home and children. However, she works all day Friday and Saturday in her husbands computer store. She receives no...