Purchase Solution

Query Database Questions

Not what you're looking for?

Ask Custom Question

. List all active customers. Include the following fields, in the order in which they appear below:

Customer ID
Customer Name
Contact First Name
Contact Last Name
Contact Phone

2. Sort by Customer Name, then by Contact Last Name, then by Contact First Name.

NOTE: All 3 of these Sorts need to be done at the same time. In other words, the Customer Name field is the primary Sort key. When there are duplicate Customer names, the list will be sorted by the Contact Last Name field, and when there are duplicate last names the list will be sorted by Contact First Name.

3. Name the query qry#1ActiveCustomers.

Query #2

1. List all customers in territories 1 and 5 who have bought Standard lumber, and all customers in territory 3 who have bought 3+ Ash.

2. Include the following fields in the query, in the order in which they appear below:

Customer ID
Customer Name
Territory Name
Sales Rep ID
Sales Rep Last Name
Product Code
Product Description

3. Sort by Product Description, then by Customer Name, in Ascending order.

4. Name the query qry#2TerritoriesAndProducts.

Query #3

1. List all customers with the products they have ordered since and including 1/1/03.

2. Include the following fields in the query, in the order in which they appear below:

Customer Name
Product Description
Product Code
Quantity Ordered
Date of Order

3. Format the Quantity Ordered field to display with commas and zero decimal places.

4. Sort by Product Description, then by Customer Name, in Ascending order.

5. Name the query qry#3CustomersAndOrders.

Query #4

1. Create a query that calculates the total product cost and the discounted price for all products.

2. Include the following fields in the query, in the order in which they appear below:

Product Description
Product Code
Customer Name
Quantity Ordered
List Price
Discount
Base Price (=Quantity multiplied by the List Price)
Discounted Price (=Base Price minus the Base Price multiplied by the Discount)

3. Format the Base Price and Discounted Price fields to Currency with 2 decimal places.

4. Format the Quantity Ordered field to display commas with 0 decimal places.

5. Format the Discount value to Percent with 1 decimal place.

6. Sort in Ascending order by Product Description, then by Customer Name.

7. Name the query qry#4TotalProductCost.

Purchase this Solution

Solution Summary

The expert examines a query database questions. The discounted price fields to currency are determined.

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.