Question

In Microsoft Access, the relationship between two tables is not actually created until:

a. Records are entered into both tables
b. A query is run involving both tables
c. A form is created using both tables
d. A report is generated using both tables

Answer 1

Final answer:

The relationship between two tables in Microsoft Access is created when it is explicitly defined in the database relationships settings, which usually happens before any records are entered or any queries, forms, or reports involving the tables are created.

Step-by-step explanation:

In Microsoft Access, the relationship between two tables is not actually created until the relationship is explicitly defined in the database. The correct answer to when the relationship is created is not covered in the options provided. However, typically, relationships in Access are created through the Relationships window where you define how the tables relate to each other by specifying the primary key of one table, which typically has a unique value for each record, and the foreign key of another table.

This is done before records are entered, queries are run, forms are created, or reports are generated using the tables. Once there is data in both tables, Access can determine the relationships between the fields in the tables.