
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.
Questions & Answers
Have a Question?
Be the first to ask a question about this.