Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
Access 2013 Vocab Chapter 1
Terms in this set (32)
To add to the end of.
Access templates that can be used to create database objects such as tables, forms, or reports.
Alternate text that appears instead of a field's actual name in tables, forms, and reports.
To order copies of a multi-page document so that complete sets are together.
Two or more fields that collectively define the primary key by unique combinations of their values.
An organized collection of information about a subject.
Database Management System
A computer program that includes both the stored database and the tools required to use the database.
A spreadsheet-like view of a table in which each record is a row and each field is a column.
To add protection to a file so others cannot read it.
A mode in which only one user at a time can work with a file.
A suffix at the end of a file name that indicates its type, such as .accdb.
A piece of data stored about each record in a table. For example, ZIP Code is a field in an address box.
An optional brief comment or explanation of a field. It appears in the status bar at the bottom of the window when the field is selected.
The top block in a vertical field in a table, containing the field name.
Characteristics of a field.
In Table Design view, the gray rectangle to the left of the field name. Click it to select that field; drag it up or down to move the field in the field list.
A view of a table or query's data, designed for lookup or input of records.
To set a field so that it always remains onscreen, in the left-most position, as you scroll left to right.
A field that can contain more than one separate entry per record.
An item, such as a table, query, form, or report, in an Access database file that is used to store, display, or manage data.
The field that uniquely identifies each record in a table.
A view that shows you exactly how a report will look when printed.
A specification that describes how a set of records should be sorted, filtered, calculated, or presented.
The stored information about one particular instance such as one person's data in an address book.
A database that contains (or can contain) multiple tables with relationships between them.
A printable layout of the data from a table or query.
A field for which each record must contain an entry.
A collection of records that share the same fields.
Table Design View
A view in which you can add, edit, and delete fields from a table; change data types and descriptions; set a primary key; and more.
A database that contains formatting, styles, and sample text that you can use to create new databases.
A field for which each record must contain a unique entry.
A series of dialog boxes that guide you step-by-step through a process.