Databases

A collection of data organized in a manner that allows access, retrieval and use of that data.

• database

• spreadsheet

• form

• query

A unique identifier used when creating a table that assures there will be no duplicate data.

• column

• field

• primary key

• query

The columns in a table in a database are called

• keys

• fields

• items

• inputs

The rows in a table in a database are called

• fields

• keys

• lines

• records

To enter records into a table in an Access database you need to be in _______________ view.

• design

• layout

• datasheet

• input

Which of the following icons is for design view in Access?

• 
• 
• 
• 

All of the following are objects in an Access database EXCEPT:

• tables

• queries

• forms

• labels

A query that allows the user to enter a search term and then displays the query results based on the term entered is called a:

• search query

• parameter query

• user query

• data query

To specify a wildcard in a query which symbol is used?

• @

• !

• &

• *

Which Access object contains all of the data in the database?

• form

• macro

• table

• query