Question: 1 . Using Table Design view, create and save a new table named Vendors with the following fields: Field 1 : Field Name: VendorID Data
Using Table Design view, create and save a new table named Vendors with the following fields: Field : Field Name: VendorID Data Type: AutoNumber Primary Key Field : Field Name: ContactName Data Type: Short Text Field : Field Name: ContactPhone Data Type: Short Text Important note: After adding fields, remember to save your changes to the table Using Database Tools, create the following table relationship: Link the Employees table to the EmployeePhones table, use the EmployeeID attribute. Onetomany relationship: an employee can have many phones, but a phone can only belong to one employee.deg Enforce Referential Integrity
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
