DBM 280 Week 4 Individual Assignment Creating Queries


Ask a Question

DBM 280 Week 4 Individual Assignment Creating Queries

Sale price $15.00 Regular price $30.00

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.

Ask a Question