MIS103 - Creating and Querying a Database

Module 3: Databases

Creating and Querying a Database (Instructions)

Following are instructions for the assignment that you will submit the Module 3: Creating and Querying a Database Assignment. Be 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 PRODUCT. You will create a form called PARTS and a report called INVENTORY.

The products you sell are:

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

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: