Greeting Card and Winter Scene

If you are done with your calendar project, you are to create a holiday greeting card using Publisher and a winter scene using OpenOffice Draw. You will do the winter scene only if you finish the greeting card. Below are the instructions:

Greeting Card

1. Open Publisher and choose 'Greeting Cards' from the list. 
2. Select Side Fold Card or Top Fold Card.
3. Click Yes when asked to automatically insert pages.
4. At the bottom of your document you should see four pages. Page 1 is the front, 2/3 are the inside, and 4 is the back.
5. Design a holiday greeting card for a friend or family member. You may use the pre-designed card templates in Publisher for ideas and you can also type "Holiday Greeting Cards" into Google images for ideas. However, you may NOT use a template for your design!
6. Front of card MUST have a graphic, a border, and a message (e.g., Happy Holidays!, Merry Christmas, Happy Hanukah, etc...).
7. Inside left must have a holiday quote with the author's name included (search for one on the internet).
8. Inside right must be the message and include a small graphic.
9. Back must include: Designed Especially for you by: Your Name © 2009. (To make the copyright symbol type ( c ) and then hit space. It will automatically be created.)
10. When you are finished, save it in your Desktop Publishing folder as "Holiday Greeting Card".
11. Print in color (4600/4700) and hand in.

Winter Scene

1. Use either OpenOffice Draw or Publisher.
2. You will be creating a winter scene of your choosing using the drawing tools in either program.
1. The winter scene must include use of fill colors, autoshapes, line styles, a text box, 3D, shadow effects, a border (if using Publisher), and a background.
3. TYPE your name on the front of the document
4. When you finish, save it in your MP2 folder as "Winter Scene"
5. Print out and hand in.

Movies Database - Part 3 (Queries)

Today, you will be creating a query based on the movies table that you created.

• Create a query using the wizard based on the movies table
• Click on Queries on the left hand side of your screen
• Then, click on Create Query using Wizard.
• Select the Movies table and select ALL fields EXCEPT Director to be included.
• Click Next
• Sort by Movie Title in DESCENDING order
• Then, click on MATCH ALL OF THE FOLLOWING
• Choose Total Gross as the Field, Is Greater Than for the condition, and type in 100,000,000 for the value. (This will filter movies that only made more than $100 Million)
• Click Next
• Choose Detailed Query
• Leave the aliases as is
• Name the Query "Income Query, then select modify query
• Click Finish

You have now created a query!! Save as Income Query and close.