Lesson 22: Getting Started with Access Essentials Flashcards
Data Type
A field property in acces 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 store subject based data; a primary object in a database
entry
Data entered in a database cell
field
In Accses a single piece of database information, such as a first name, a last name, or a telephone number
field name
A label that helps identify the field
field properties
Defination of hte characteristics and behavior of a database field
primary key
unique identifier of each record in an Access table
record
A group of realted field in a database, such as all the contact inforamtion for an individual
relational database
A database in which inforamtion is organized into seperate subject-based tables, and the relationship of hte data in one or more tables is used to bring the data together
table
A datasheet that store subject-based data. It is a primary object an Access database