Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started