Database Lesson 4 Quiz

Which of the following is a common error when creating database tables?

• Failing to add a foreign key

• Failing to add a common field

• Entering the wrong data type in a field

• Failing to uniquely identify each record

Which of the following should you use to display specific information from a database table?

• A select query

• An action query

• An update query

• A table query

Which of the following should you use to perform an action on specified records in a database table?

• A select query

• An action query

• An update query

• An append query

The word "query" means:

• populate.

• question.

• answer.

• locate.

How can you add two unrelated tables to a query?

• Add a foreign key.

• Add a primary key.

• Create a table join.

• Combine the tables.

Which operation would allow you to convert a spreadsheet into a database?

• Query

• Export

• Import

• Translate

Which operation would allow you to convert a database into a spreadsheet?

• Query

• Export

• Import

• Translate

What should you create if you need to see a printout of the current data in a database?

• A form

• A query

• A report

• A spreadsheet

What should you do if you want to alter the "look and feel" of a report?

• Create a form.

• Create a query.

• Add a report theme.

• Import the report into a presentation application.

Why would you create a database report?

• To relate database tables through common fields

• To share and present database information in print form

• To select database information from multiple tables

• To create an object in which to view, enter and edit database information