Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel 2024 In 7 Days

Authors: Alan Dinkins

1st Edition

B0CJ3X98XK, 979-8861224000

Students also viewed these Databases questions