ACCESS Chapter 1: End of Chapter Quiz
The Access view that displays data in columns and rows like an Excel worksheet is: Layout view Design view Datasheet view
Datasheet view
To add on to the end of an object, such as to add records to the end of an existing table, is to: run append import
append
The data type that describes a unique sequential or random number assigned by Access as each record is entered is: currency short text autonumber
autonumber
The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is: short text currency autonumber
currency
The characteristic that defines the kind of data you can store in a field is the: data type data source field property
data type
Characteriestics of field that control how the field displays and how date is entered are: data types field properties data sources
field properties
The field that uniquely identifies a record in a table is known as the: primary key common field attachments field
primary key
Precise changes to the properties--characteristics of selected items in database can be made in the: caption property sheet database template
property sheet
The object that retrieves specific data and then displays only the data that you specify is a: report form query
query
The box at the left of a record in a Datasheet view that you click to select an entire record is the: navigation area record selector box link
record selector box
Information repeated in a database in a manner that indicates poor design is said to be: truncated relational redundant
redundant
A more sophisticated type of database that stores multiple collections of data that are related to one another for example, data about the students, the courses, and the faculty members at a college is a: relational database database management system flat database
relational database
The object that displays fields and records from a table or query in a printable format is a: form query report
report
The data type that describes text, a combination of text and numbers or numbers that re not used in calculations, such as ZIP code is: currency autonumber short text
short text
The underlying design of a table is referred to as the: source file structure caption
structure
