yes

To add on to the end of an object, such as to add records to the end of an existing table, is to:

append

The process of adding data from an Excel spreadsheet to an existing Access table that is closed.

appending

Term used to describe a unique sequential or random number assigned by Access as each record is entered.

autonumber

The data type that describes a unique sequential or random number assigned by Access as each record is entered is:

autonumber

A field in one or more tables that stores the same data.

common field

The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is:

currency

Facts about people, events, things, or ideas.

data

A classification or the kind of data that you can store in a field, such as numbers, text, or dates.

data type

An organized collection of facts about people, events, things, or ideas related to a specific topic.

database

A preformatted database that contains prebuilt tables, queries, forms, and reports that perform a specific task, such as tracking events.

database template

The Access view that displays data in columns and rows like an Excel worksheet is:

datasheet view

An Access view that displays data in rows similar to the format of an Excel worksheet.

dataview

An Access view that displays the underlying view of an object.

design view

A single piece of information that is stored in every record and represented by a column in a table.

field

Characteristics of a field that control how the field displays and how data is entered are:

field properties

Settings that control how the field displays and how data can be entered into the field.

field properties

An Access field property that limits the number of characters that can be typed into a text or number field.

field size

A principle stating that data is organized in tables so that there is no redundant data.

first principle

A simple database file that is not related or linked to any other collection of data.

flat database

Data that is organized in a useful manner.

information

The action of filling a database with records.

populate

The field that uniquely identifies a record in a table is known as the:

primary key

The required field in the table that uniquely identifies a record.

primary key

Precise changes to the properties—characteristics—of selected items in database can be made in the:

property sheet

The object that retrieves specific data and then displays only the data that you specify is a:

query

A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.

record

The box at the left of a record in Datasheet view that you click to select an entire record is the:

record selector box

Information repeated in a database in a manner that indicates poor design is said to be:

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

The window area that organizes the database objects and from which you open objects.

navigation pane

The process of applying design rules and principles to ensure that a database performs as expected.

normalization

The window area that displays each open object on its own tab.

object window

The basic parts of a database; for example tables, queries, forms, and reports.

objects

The object that displays fields and records from a table or query in a printable format is a:

report

A principle stating that techniques are used to ensure the accuracy of data entered into a table.

second principle

A data type that describes numbers that represent a quantity and may be used in calculations.

short number

The data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a ZIP code is:

short text

The underlying design of a table is referred to as the:

structure

The database object that stores the data, and which is the foundation of an Access database.

table