Question

Lance has three tables in his database he wants to generate a report to show the data from the three table so he decides to link the tables which type of field will help plants to create the relationships

Answer 1

He could create foreign keys, which are basically columns in a table with values that identify a record from another table.

However, even without foreign keys you can construct queries that link data from multiple tables together.

Answer 2

The answer is: Importing, although you can also do it by copying and pasting, or creating a subreport.

Step-by-step explanation:

If, for example, Lance, you want to see customer data, but you also want to see information about customer orders at the same time. A subreport is a useful tool in Access to perform this task because it allows you to display the order information in the report with the customer information, in a logical and readable way. Access provides several ways to create subreports quickly.

He can also Import database objects to the current Access database. Access provides several ways to copy an object such as a table or form from one database to another. The simplest is to copy and paste an object, but importing an object from another Access database to the current database offers more options.

The answer is: Importing, although you can also do it by copying and pasting, or creating a subreport.