Microsoft assignments

Assessment 2 Finding, Adding, and Deleting Records; Formatting Datasheet 1. Begin with 1-WBInventory-A2-HOA open and enable the content, if necessary. 2. Open the InventoryList table. 3. Adjust all column widths to accommodate the longest entry. 4. Locate and then delete the records for the inventory items Pita Wraps, Tuna, and

Lake Erie Perch. 5. Add the following new records to the InventoryList table.

ItemNo ItemDescription Unit SupplierCode 051 Atlantic Scallops case 9 052 Lake Trout case 9 053 Panini Rolls flat 1

6. Change the font size for all data in the table to 10 points. 7. Preview the table in Print Preview and, if necessary, adjust the top and/or bottom

margin settings until all of the records will print on one page. 8. Close the InventoryList table. Click Yes if prompted to save changes.

Marquee Series © Paradigm Publishing, LLC Access 365, 2019 Edition: Section 1, Skills Assessment 2 Hands On Activity