Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
Query 2
Create a parameter/update query that prompts for the incremental amount of a price increase and then
prompts for the product description. Save the query as Updated Prices. Test the query by adding $0.25 to the
cost of a product. View the changed price in your datasheet view of the updated table.
Query 3
Create a query called Favorite Colors. List the colors of the products ordered and determine how many have
been ordered of each; report the amounts in a column labeled Number Ordered. Sort the query output. Note
the column heading change from the default setting provided by the query generator. Your output should
resemble the format shown in Figure 4-4, but the data will be different.
FIGURE 4-4
Favorite Colors query
Query 4
Create a query called Best Selling Product. List the product descriptions and determine how many orders
have been received for each product. Report the amounts in a column labeled Number Ordered. Sort the
output. Note the column heading change from the default setting provided by the query generator. Your output
should resemble the format shown in Figure 4-5, but the data will be different.
FIGURE 4-5
Best Selling Product query
Query 5
Create a query called Best Customers that lists the customers’ names, phone numbers, and the total amounts
of their orders. You will have to calculate the order amounts and sort the output. Note the column heading
change from the default setting provided by the query generator. Your output should resemble the format
shown in Figure 4-6, but the data will be different.
 
Search JabSto ::




Custom Search