Microsoft Access Review

Filters can be used on query results

• True

• False

A primary key field from one table appears in a second table. What is the field in the second table called?

• A linked key

• A relationship key

• A foreign key

• A primary key

What is it called when you "ask the database a question"?

• Relationship

• Query

• Data Integrity

• Report

What is the advantage of reports over queries?

• Reports can be formatted

• Reports can access more data

• Queries can be formatted

Queries can only use data from one table at a time.

• True

• False

A primary key field from one table appears in a second table. What can be said about these tables?

• The tables are subordinated

• The tables are queried

• The tables are in a duplication

• The tables are in a relationship

Does Microsoft Access need to be told about relationships between tables?

• No, relationships are automatically detected

• No, relationships are not supported

• Yes, relationships need to be defined

• Yes, only when the fields have different names

Sorting from A-Z is also called a descending sort.

• True

• False

You cannot change the order of fields on a report.

• True

• False

What is it called when you view some records and hide others?

• Report

• Sort

• Search

• Filter