USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
No, relationships are automatically detected
|
|
|
No, relationships are not supported
|
|
|
Yes, relationships need to be defined
|
|
|
Yes, only when the fields have different names
|
Detailed explanation-1: -Does Microsoft Access need to be told about relationships between tables? Yes, relationships need to be defined.
Detailed explanation-2: -You define a relationship by adding the tables that you want to relate to the Relationships window, and then dragging the key field from one table and dropping it on the key field in the other table.
Detailed explanation-3: -One of the major advantages of databases such as Microsoft Access is their ability to maintain relationships between different data tables. The power of a database makes it possible to correlate data in many ways and ensure the consistency of a (Foreign key) of this data from table to table.
Detailed explanation-4: -Requirements for a table relationship. Each table must have a single column that uniquely identifies each row in that table. This column is often referred to as the primary key. The data values in the lookup column must be unique.