Microsoft Office Tutorials and References
In Depth Information
3. Create a query that includes the Item Number and Description fi elds for all products where the
description starts with the letter B. Save the query as Lab 2-2 Step 3 Query.
4. Create a query that includes the Item Number and Description fi eld for all products with a cost
less than $5.00. Save the query as Lab 2-2 Step 4 Query.
5. Create a query that includes the Item Number and Description fi eld for all products with a selling
price greater than $15.00. Save the query as Lab 2-2 Step 5 Query.
6. Create a query that includes all fi elds for all products with a selling price greater than $10.00 and
where the number on hand is fewer than 10. Save the query as Lab 2-2 Step 6 Query.
7. Create a query that includes all fi elds for all products that have a selling price greater than $15.00
or a supplier code of AC. Save the query as Lab 2-2 Step 7 Query.
8. Join the Supplier table and the Item table. Include the Supplier Code and Supplier Name fi elds
from the Supplier table and the Item Number, Description, On Hand, and Cost fi elds from the
Item table. Sort the records in ascending order by Supplier Code and Item Number. Save the
query as Supplier-Item Query. Note that the Report Wizard limits the size of the On Hand column
header because it is a number fi eld.
9. Create the report shown in Figure 2–88. The report uses the Supplier-Item query and the Module style.
Figure 2–88
10. Create a query that includes the Item Number, Description, On Hand, and Cost fi elds. Calculate
the inventory value (on hand * cost) for all records in the table. Change the caption for the On
Hand column to In Stock. Format inventory value as currency with two decimal places. Sort the
records in descending order by inventory value. Save the query as Lab 2-2 Step 10 Query.
11. Create a query that calculates and displays the average cost of all items. Save the query as Lab 2-2
Step 11 Query.
12. Create a query that calculates and displays the average cost of items grouped by supplier code. Save
the query as Lab 2-2 Step 12 Query.
13. Submit the revised database in the format specifi ed by your instructor.
Continued >
Search JabSto ::




Custom Search