Relational Databases

Question 1

Rows in an Access table are called

Answer 1

records

Question 2

With Access databases, it is only possible to query one recordsource at a time.

Answer 2

false

Question 3

Access Tables can be modified either in the design view or ___________ view

Answer 3

datasheet

Question 4

which of the following establishes relationships between Access tables?

• secondary keys
• primary keys
• input masking

Answer 4

primary keys

Question 5

Columns in an Access table are called

Answer 5

fields

Question 6

________ make it easier and faster to enter your data into an Access database

Answer 6

Forms

Question 7

Which of the following are advantages of relational databases over single lists?

• improves quality of data retrieved
• reduces amount of data managed
• reduces amount of data entry
• increases accuracy

Answer 7

All of them

Question 8

Relational databases organize information into separate folders, each containing unrelated data.

Answer 8

False

Question 9

A primary key is a field, or a combination of fields, with a value that makes each row in a table unique.

Answer 9

True

Question 10

When you run a select query, Access displays a recordset

Answer 10

True