Your Assignment: After You Have Filled in the Required Information in Your Database (In

Your assignment: After you have filled in the required information in your database (in Microsoft Access), you will use that database to complete the questions below! Good Luck!

1)Use the “Sort and Filter” function, and sort each column (“pant price”, “shirt price”, and “sweater/jacket price”) from lowest to highest price.
Looking at the prices you sorted, which outfit is the least expensive to buy?
List the shirt, pants, and sweater/jacket you could buy:
______
How much would the whole outfit cost (before tax)? ______
How much would it cost, if you included a sales tax of 8%? ______

2)Now, use the “Sort and Filter” function and sort each column from highest to lowest price.
Looking at the prices you sorted, which outfit is the most expensive to buy?
List the shirt, pants, and sweater/jacket you could buy:
______
How much would the whole outfit cost (before tax)? ______
How much would it cost, if you included a sales tax of 8%? ______

COLOR / HOW MANY / COLOR / HOW MANY / COLOR / HOW MANY
EX) brown / 4

3)For each category (pants, shirt, and sweater/jacket) use the “Find” function and see out how many different colors of each item you have. (Use the find function for each different color you have listed for each item).
Record your findings below:
PANTS SHIRTS SWEATER/JACKET

4)Now, click on the “Advance Filter” function, and choose “Filter by Form”. In the “Pants Color” column, filter that by one color (use the color that you have the listed the most). Then in the “Pants Price” column, filter by items costing less than your most expensive pair of pants (Example: if your most expensive pair of pants cost $50.00, then type in <50in price column).
List these items below:
______
______
______
______

5)Remembering that you only have $200 to spend on this outfit, try to use “Sort and Filter” for each individual column so that you get an outfit you like, but that costs a total of $200 (before tax).
Below, list some of the combinations (pant, shirt, sweater/jacket) that are possible:

PANT / SHIRT / SWEATER/JACKET / TOTAL COST OF OUTFIT
a)
b)
c)
d)
e)

BONUS: Using your knowledge of combinations, look at the number of pants, shirts, and sweaters/jackets to calculate how many different outfit combinations are possible (regardless of the price of each item).

Now for the big question…..

ITEM / COLOR / PRICE
PANTS
SHIRTS
SWEATER

GRAND TOTAL: ______