EX16_AC_CH08_GRADER_CAP_HW – Replacement China, Inc.

Project Description:

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).