MS+Office

You will be completing the following two assignments using Microsoft Office 2007.

Assignment 1
Part 1: Go to each fast food restaurant below. You must use at least 5 restaurants. McDonald's: http://www.mcdonalds.com/usa/eat.html Burger King: http://www.bk.com/ Wendy's: http://www.wendys.com/food/Menu.jsp You may pick your other restaurants!!! Once there, plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc), a drink, and a dessert. For each item on your menu, record the total calories and the calories from fat. Part 2: Enter your data in an Excel spreadsheet. [|Click here to see a sample and directions for completing the spreadsheet]. When you have finished your spreadsheet and charts, [|complete the handout].

When finished, print out the Excel spreadsheet to hand in.

=**Assignment 2**=

25 Most Wanted Music CD’s Microsoft ACCESS Database Project

Project Description

In Microsoft ACCESS create a database of 25 music CD’s that you would purchase if money were no object. Obtain your information through Internet research. **List all sites used in a WORD document entitled “Sites Used”**. List them in alphabetical order.

In your database include the following fields:

• Artist • Title • Record Company • List Price • Best Price Found • Genre (category-i.e. Rock, Country, R & B, etc) • Release Date (if available-if not available type n/a in that field)

Part 1: Create your database then sort it in ascending order by the Title. Print one copy to turn in.

Part 2: Next assign a preference number (1 through 25) for the order in which you would purchase each CD. With (1) being the first purchase you would make and (25) being the last purchase you would make. Then sort your database in ascending preference order and print one copy to turn in.

Part 3: Design a query to list all CD’s with a price of $16.99 or greater. Save your query and print one copy to turn in.

Part 4: Design a query to calculate the average (AVG) price of all the CD’s in your database. Save your query and print one copy to turn in.

Part 5: Using the report wizard design a tabular report which list the Title, Artist, Record Company, Genre, and Best Price Found in the same order (1 thru 25) from your preference sort. Save and print one copy in landscape orientation.

NOTE: Print all items in landscape orientation. Staple all printouts together and turn them in all at once.