DBM 280 Week 4 Individual Assignment Creating Queries

DBM 280 Week 4 Individual Assignment Creating Queries
 
 
Instructions:

Before completing this assignment you will need to have:

• Imported the Custom and Item data
• Created entries in the Orders and Order Items tables
• Verified the tables have proper ID values to ensure they are joined

properly

Using the database you created in Week One, create the following

queries:

• A query showing all customers. Name the query, 'All Customers'.

Include all customer columns in the query.

• A query showing all customers whose last name is 'Miller'. Include

all customer columns in the query. Name the query, 'Customers by

Name'.

• A query showing all Items with a price less than $5.00. Name the

query, 'Less Expensive Items'. Include all columns in the query.

• A query showing all orders for a particular customer (you may

choose the customer and use the name or ID to select the customer).

Address the following:

• Display only the order ID, the order date, and the customer name.
• Name the query, 'Customer Orders'. Note: You will only return

orders for a single customer.

Make a copy of the 'Customer Orders' query you created. Name it,

'Customer Invoice', and include the items for the order.

Address the following:

• Include the following for the items: Item Name, Quantity, and Price.
• Display the columns: Order ID, Order Date, Ship Date, Item Name,

Item Price, Quantity, Customer First and Last Name, Address, City,

State, and Zip.

• Add a calculated field called, 'Total', for the item total (the number of

items (Quantity) multiplied by the ItemPrice). The field in the design

view should look like the following: Total: [Quantity]*[ItemPrice]

Submit your Access® database file, as your deliverable for this

assignment, to the Assignment Files tab above.