Create and edit tables for Coast Jewlers.
a. Create a new table for Coast Jewelers that includes fields labeled Buyer ID, Buyer Name, and Buyer Phone. The first field (Buyer ID) is an AutoNumber data type; the rest are Text data types. All should have captions that separate each word (e.g., Buyer ID). Set the Buyer ID field as the Primary Key and save the new table as Buyers Table. Enter the following buyer information into the Buyers table, and then print the new table.

b. Add a field to the Product table called Buyer ID, a Number data type. Add the specific Buyer ID information to the following products in the Products table and then print the new table
c. Establish a one-to-many relationship between the Buyers table and the Product table using Buyer ID as the related field. Print the relationships report.
d. Create and print a query for Coast Jewelers that lists the product name, buyer name, and buyer phone number for every product. Save the query as Product Buyer Query.

Transcribed Image Text:

Buyer Phone 555-7894 555-1324 555-9137 Buyer ID Buyer Name Lopez Ng Fortier