Access 1
compacting
. A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available and enhancing the performance of the database.
query
. A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question.
Simple Query Wizard
. An Access wizard that lets you quickly select the records and fields to display in a query datasheet.
record selector
. In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row.
datasheet selector
A box in the upper-left corner of a datasheet that lets you select the entire datasheet.
table
A collection of fields that describes a person, place, object, event, or idea.
database
A collection of related tables stored in the same file.
relational database
A collection of related tables stored in the same file.
record
A complete set of field values for a specific person, place, object, event, or idea.
form
A database object you can create and customize to maintain, view, and print records in a database in different and useful ways.
Access
A database program you use to enter, organize, display, and retrieve related information.
common field
A field that appears in more than one table, allowing you to connect the records in the separate tables.
primary key
A field, or a collection of fields, whose values uniquely identify each record in a database table.
report
A formatted printout (or screen display) of the contents of one or more tables or queries in a database.
relational
A group of related tables is called a(n) _ database.
Add & Delete Group
A group on the Fields tab in Table Datasheet view that contains options for adding different types of fields to a table.
foreign key
A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.
databases
A relational DBMS provides protection of _ through security, control, and recovery facilities.
Navigation Pane
A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.
navigation buttons
A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table.
record
A set of data such as first name, last name, address, etc. for a specific person is a(n) _.
field
A single characteristic or attribute of a person, place, object, event, or idea.
relational database management system
A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.
database management system (DBMS)
A software program that lets you create databases and then manipulate data in them.
design
A table's _ includes the field names and characteristics of the fields themselves, plus any layout changes to the datasheet.
query
Access has a built-in _ language that allows you to ask questions and obtain answers about your data.
Short Text
An Access data type that allows field values containing letters, digits, and other characters.
AutoNumber
An Access data type that automatically assigns a unique number to a record.
Form Wizard
An Access tool that asks you a series of questions, and then creates a form based on your answers.
Query Wizard
An Access tool that asks you a series of questions, and then creates a query based on your answers.
Report Wizard
An Access tool that asks you a series of questions, and then creates a report based on your answers.
Form tool
An Access tool that creates a form containing all the fields in the table or query on which the form is based.
Report Tool
An Access tool that places all the fields from a table or query on a report.
icon
Each object in the Navigation Pane has a unique _, or image to indicate the type of object.
names
Give fields descriptive _ so that you can easily identify them when you view or edit records.
Click to Add column
In Datasheet view for a table, the datasheet column you can use to create a new field in the table.
field selector
In a datasheet, the column heading (also called the column selector)that you click to select the entire column.
column selector
In a datasheet, the column heading (also called the field selector) that you click to select the entire column.
row selector
In a datasheet, the small square at the beginning of a row (also called the record selector) that you click to select the entire row.
primary key
In a given table, a field is defined as a(n) _ _ when its values uniquely identify each record in the table.
backing up
Making a copy of a database file to protect your database against loss or damage.
Datasheet view (for a table)
The Access view that shows a table's contents as a datasheet in rows and columns.
Date type
The _ _ determines what field values you can enter for the field.
field values
The columns in Datasheet view contain the _ _ for each field in the table.
Field Value
The content of a field is the _ _.
All Access Objects
The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on).
ID field
The default field Access creates to serve as the primary key field for all new tables.
datasheet
The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table.
data type
The field property that determines what field values you can enter for the field and what other properties the field will have.
field value
The specific value, or content, of a field in a record.
pencil symbol
The symbol that appears in a row selector to indicate that the record is being edited.
star symbol
The symbol that appears in a row selector to indicate that the row is the next one available for a new record.
Print preview
The view of a report, form, or datasheet that shows you what the object will look like when printed.
Close
To close an open database without exiting the Access program, click the File tab to display Backstage view, and then click _.
scroll bars
To view fields or records that are not visible on your display, you can use the vertical or horizontal _ _.
template
You can search for a(n) _, or predefined database and download it from Office.com.
form
You use a(n) _ to enter, edit, and view records in a database.
