Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.
Lab2: Maintaining the Walburg energy Alternatives Database
Problem: The manager of Walburg energy Alternatives recently acquired some items from a store that is going out of business. You now need to append these new items to the current item table. You also need to change
.
.
.
.
Perform the following tasks:
1. Open the More Items database from the Data Files for Students.
2. Create a new query for the Item table and add all fields to the query.
3. Using an append query, append all records in the More Item database to the Item table in the
Walburg energy Alternatives Database.
4. Save the append query as Walburg Append Query and close the More Item database.
5. Open the Walburg energy Alternatives Database and then open the Item table in the Datasheet view. There should be 20 records in the table.
6. The items added from the More Item database do not have a vendor assigned to them. Assign item 1234 and 2234 to vendor JM. Assign item 2216 to vendor AS. Assign item 2310 and 2789 to vendor SD.
7. Create an advanced filter for the item table. The filter should display records with fewer than 10 items on hand and sorted in ascending order by description. Save the filter settings as a query and name the filter Reorder Filter.
8. Make the following changes to the Item table:
a. Change the field size for the on hand field to integer. The format should be fixed and the decimal places should be zero.
b. Make Description a required field.
c. Specify that the number on hand must be between 0 and 50. Include validation text.
d. Add a calculated field Inventory Value (On Hand* Cost) following the Cost field. Format the fields as currency.
9. Save the changes to the table design. If a dialog box appears indicating that some data may be lost, click the Yes button.
10. Add the Inventory value field to the Inventory status report. Place the field after the Cost field. Save the changes t the report.
11. Specify referential integrity between the vendor table (the one table) and the Item table(the many table). Cascade the update but not delete.
12. Submit the revised More Item database and the Walburg energy Alternatives Database in the format specified by you instructor.
* If you have any issues with the payment method, please let us know at [email protected] and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at [email protected].
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at [email protected] and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at [email protected].
******************************************** Good Luck ***************************************************
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.