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
- Find all the items with a quantity greater than 199. Save as Greater than 199.
- Find all items in Department F. Save as Dept F.
- Find all items that begin with the letter P. Save as begins with P.
- Find all items from supplier Mead.
Please refer to this tutorial for instructions on how to save your database: