Description

Pts

Your Score

Append Query used to append the records from the Product Table in the Inventory Database to a new table called Item in the Backyard Database

Change the description for WF10 to Window Bird Feeder.

Resize all columns to “Best Fit”.

Sort in Ascending order by description.

Add a totals row and display the sum for “on hand” items and the average cost and average selling price.

Save this layout.

Rename the table, “Product”

Print the Item table

Update the table properties to say, “Updated to include items from Inventory database. PRINT SCREEN this change.

Use a delete query to delete all records whose description begins with “S”. Save as “Delete Query”.

Print the Item table again.

TOTAL POSSIBLE POINTS: