Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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