access Flashcards
datatype
a field property in access that determines the type of data a database field can store.
database
A collection of related information organized for rapid search and retrieval.
datasheet
A database table that stores subject-based data; the primary object in a database
entry
Data entered in a datasheet cell.
field
In Access, a single piece of database information, such as a first name, a last name, or a telephone number; in Word, an indication of a location in which variable text
or data can be inserted
field name
A label that helps identify the field
field properties
Definitions of the characteristics of and behavior of a database field
primary key
Unique identifier of each record in an Access table.
record
A group of related fields in a database, such as all the contact information for an individual
relational database
A database in which information is organized into separate subject-based tables, and the relationship of the data in one or more tables is used to bring the data together
query
A database object which allows you to organize, summarize, and print all or a portion of the data in a database
report
A database object which enables you to locate multiple records matching specified criteria