Question: could anyone do the full qustion ? as a complete file ? cuz i dont have my laptop plzz ? i know the answer but

could anyone do the full qustion ? as a complete file ? cuz i dont have my laptop plzz ? i know the answer but i need it as access file
could anyone do the full qustion ? as a complete file ?

Management Information Systems Course Database Assignment By using Microsoft Access create database called DB_MIS and then create two tables Sunolier and Product as the followine reauirements: Once you have started the database, perform the following activities: 1. Import the attached products.txt \& suppliers.txt first and then specify the above tables. 2. Make the field Supplier Number primary key in the Supplier table 3. Make the field Product Number primary key in the Product table 4. Make the field ZIP Code size five numbers only (Hint: see the properties of the field check validation rule) 5. Make the field Company Name required field (Hint: see the properties of the field) 6. Draw the relation between the two tables using Database Tools > Relationships tool in MS Access. 7. Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to least expensive, the quantity on hand for each, and the markup percentage for each 8. Create separate table in the database called student table with the following details and put your real information

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!