lil_amb
December 13th, 2005, 02:11 PM
Got a friend needing some help with a clas, she cannot get the question asked...therefore she cannot move on. Any help is appreciated.
1) The manager wants to know the inventory value of items in stock. Create a query to display Item ID, Description, On Hand, Cost, and Inventory Value (On Hand * Cost). Name the query, Query1. (Inventory Value is a calculated field.)
�� 2) The owner of Logo Greats has decided to increase the cost of their items by 15 percent. The hockey shop manager has decided to raise the selling price of all Logo Greats items by 10 percent. Create an update query to reflect the new costs of all Logo Greats items and the new selling price of all Logo Greats items. Name the query, Query2.
�� 3a) Management needs more information about the shop’s vendors. Add the following to the Vendor table.
�� 3b) Notes is a Memo data type field.
�� 3c) Last Order Date is a Date/Time data type field
1) The manager wants to know the inventory value of items in stock. Create a query to display Item ID, Description, On Hand, Cost, and Inventory Value (On Hand * Cost). Name the query, Query1. (Inventory Value is a calculated field.)
�� 2) The owner of Logo Greats has decided to increase the cost of their items by 15 percent. The hockey shop manager has decided to raise the selling price of all Logo Greats items by 10 percent. Create an update query to reflect the new costs of all Logo Greats items and the new selling price of all Logo Greats items. Name the query, Query2.
�� 3a) Management needs more information about the shop’s vendors. Add the following to the Vendor table.
�� 3b) Notes is a Memo data type field.
�� 3c) Last Order Date is a Date/Time data type field