Posted: October 31st, 2022
EX16_AC_CH08_GRADER_CAP_HW – Replacement China, Inc.
You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and collectibles. You need to add a hyperlink field that will store a URL for each manufacturer’s website. The HR department manager wants to store a photo and the most recent performance review for each employee. You also export inventory items in three different formats. Finally, you import information from Excel, Access, and text files. Compact and repair the database when you are finished.
Start Access. Open the downloaded Access database named exploring_a08_Grader_h1.accdb. Save the database as exploring_a08_Grader_h1_LastFirst.
Create a new field in the Manufacturer table after RlMfgCode named Website with the Hyperlink data type. Save the table.
Switch to Datasheet view, add the website http://www.lenox.com to the Lenox China record (7).
Place an order in 3 easy steps. Takes less than 5 mins.