MIS103 – Creating and Querying a Database

Download the file:-

Module 3: Databases

C

reating and Querying a Database (Instructions)

F

ollowing are instructions for the assignment that you will submit the Module 3: Creating and Querying a Database

A

ssignment.

B

e sure to follow the instructions carefully!

You are the manager of the Dewy, Cheatem, and Howell bookstore. You want to use Access to construct a database to meet your needs. The name of the database will be STOCK. You will create a table called

P

RODUCT. You will create a form called PARTS and a report called INVENTORY.

The products you sell are:

F

F

Lay’s

P

Bic

C

P

Bic

F

0.65

Pepsi

C

Champion

C

B

Columbia

200

A

Mead

Product NAME	DEPARTMENT	QUANTITY	PRICE	SUPPLIER
Avocado Dip				F	6	0.99	Jay’s
Ball Point Pen			P	1 50	0.89			Bic
Chips	77		0.65		Lay’s
Class Ring				C	50	98.95	Balfour
Dictionary		B	22	12 .95		Columbia
Doritos	145	2.49
Felt-tip Pen	76	0.98
Logo T-Shirt	250	9.99		Champion
Pencil		200	0. 15
	Pepsi	444
School Jacket	100	34.95
School Tie	15	17.50	Field’s
Thesaurus	12	18.00
Three-Hole Paper		A	1.98		Mead
Three-Ring Binder	122	3.50

Use the database to perform the following. Sort by Department and Product name. Save as Department and Name

1. Find all the items with a quantity greater than 199. Save as Greater than 199.
2. Find all items in Department F. Save as Dept F.
3. Find all items that begin with the letter P. Save as begins with P.
4. Find all items from supplier Mead.

Please refer to this tutorial for instructions on how to save your database: