Access Flashcards
Data Type
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
Data sheet
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.
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
Finds and shows data that meet a specified criteria.
Report
Organizes data in a specific layout.
Field Properties
Definition of characteristics of and behavior data base field