ACCESS DATABASE - 4

It is the association between two tables through a common field also known as a key or primary key.

• Control

• Management

• Relationship

• Entity

In the following figure, identify what type of relationship it is:

• Many to many

• One to one

• one to many

• None of the above

Type of relationship that is the most common in a database, a table or a record found in it, it can be linked to many other records in another table or tables.

• One to many

• One to one

• Many to many

• None of the above

It is a relationship that occurs when many records in a table are linked to several records in another or other tables.

• One to one

• One to many

• Many to many

• None of the above

These are some of the activities that we can perform in a table in the datasheet view

• Search - Sort - Filter

• Sort - Filter - Format

• Search - Clear - Filter

• Add - Clear - Format

What types of ordering can we do to the records within the datasheet view?

• Ascending and Selection

• Ascending and Descending

• Selection and Advanced

• Descending and Advanced

One of the options to be able to filter the information when choosing the information from the table.

• By filter

• Selection

• Advanced

• Form

What are the options for filtering within tables in MS-Access?

• Selection, Text Filter, Form and Advanced

• Selection, Filter, Report and Advanced

• Selection, Filter, Form and Advanced

• Selection, Report, Form and Advanced

Window where the tables of a Database that are going to be related and show said link ordered between them are presented.

• Design Window

• Relationships Window

• Query Grid

• Datasheet View

The Relations group as shown in the image. In which file is it located?

• Edition

• Watch

• Design

• Format