Question: could anyone do the full qustion ? as a complete file ? cuz i dont have my laptop plzz ? i know the answer but
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
Get step-by-step solutions from verified subject matter experts
