COMPLETE OUTLOOK ASSIGNMENT 1 outlook

Microsoft Office Outlook Assignment

Complete Outlook Assignment 1

In this assignment you will organize your Outlook. You will need to take screenshots of each required element (listed below). Add these screenshots to a Word or PowerPoint document. Then, upload the document in Moodle. The document should include screenshots of:

1. A Customized Inbox
2. An Organized Mailbox, done by:
   1. Adding 3 folders;
   2. Adding email messages to the appropriate folders
3. An Organized Contacts Group
   1. Creating a “New Contact” for each member of the group;
   2. Assigning a “Category” for the Group.
4. Upload to Moodle

In-Class

• Database Basics: W3Schools

Review, Select, Update, and Insert Commands

Using the Northwinds Database on Wschools or a resource provided by your instructor find the answers to these queries:

A. Select statement (List, display, show, find)

1. List all the records and fields in the Products table
2. List just the product name, unit Price, Units in stock
3. List all the products that discontinued field is true.
4. Display the current product list (hint: query 3 should help)

B. Using the where clause to:

1. List all the products that have a unit price less than 22
2. List all the products that stock level is greater than 33
3. List only the current products that meet both queries 1 and 2 in this section

C. Order By:

1. Redo A2 and sort by unit Price
2. Redo A2 and sort byproduct descending