You have a database that contains information about all of the employees from your company. There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?
What will be an ideal response?
Open the database, click on the Database Tools tab on the Ribbon, then click on the Relationships button in the Relationships group. Click the Show Table button in the Relationships group, and click Employees, click Add, click Pay, and click Add, then click Close. Drag the Emp ID field from the Employees table to the Emp ID field in the Pay table. Click the Enforce Referential Integrity check box to add a check mark, and click Create.
You might also like to view...
A(n) ________ is a place where a person can go to eat and drink and have a connection to the Internet
Fill in the blank(s) with correct word
A(n) ____ if statement is another word for an extended if statement.
A. multiway B. nested C. two-way D. looped
Each author is uniquely identified by his or her AUTHOR_NUM.
Answer the following statement true (T) or false (F)
A standard JFIF JPEG file has a header value of __________________ from offset 0 and the label name JFIF starting at offset 6.
Fill in the blank(s) with the appropriate word(s).