IC3 Database Applications

Question 1

In a database, what is a 'record'?

Accepted Answer

A complete set of fields about one entity

Answer

A single piece of data in a cell

Answer

A category label for a column

Answer

A formula used to calculate values

Question 2

Which of the following best describes a 'field' in a database table?

Accepted Answer

A single category of information stored in a column

Answer

A row containing all data for one item

Answer

A query used to search for data

Answer

A report generated from the database

Question 3

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record in the table

Answer

To sort records alphabetically

Answer

To link two tables together automatically

Answer

To restrict who can view the table

Question 4

In Microsoft Access, which object is used to enter and view data in an easy-to-use layout?

Accepted Answer

Form

Answer

Query

Answer

Report

Answer

Module

Question 5

What does a database query do?

Accepted Answer

Retrieves specific data from one or more tables based on set criteria

Answer

Prints formatted data for distribution

Answer

Creates a visual layout for data entry

Answer

Backs up the entire database

Question 6

Which data type should be used to store a person's age in a database field?

Accepted Answer

Number

Answer

Text

Answer

Date/Time

Answer

Hyperlink

Question 7

What is the purpose of a database Report object in Microsoft Access?

Accepted Answer

To display and print data in a formatted, organized layout

Answer

To run automated macros on data

Answer

To establish relationships between tables

Answer

To import data from external sources