Module 2 Flashcards
Building a Database and Defining Table Relationship (28 cards)
Composite Key
A primary key that consists of two or more fields.
data redundancy
A condition that occurs when you store the same data in more than one place; it wastes space and can cause inconsistencies.
properties
The characteristics of each field in a table.
Cascade Delete Related Records option
An option you can set to enforce the referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values.
set
To select or enter a value for a property of a field.
Field Size property
The property that defines a field’s maximum storage size for Short Text, Number, and AutoNumber fields.
Byte
The Field Size property that stores whole numbers from 0 to 255 in one byte.
Integer
The Field Size property that stores whole numbers from -32,768 to 32,767 in two bytes.
Long Integer
The Field Size property that stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.
Single
The Field Size property that stores positive and negative numbers to precisely seven decimal places in four bytes.
Double
The Field Size property that stores positive and negative numbers to precisely 15 decimal places in eight bytes.
Replication ID
The Field Size property that establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions in 16 bytes.
Caption property
A field property that specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports.
Decimal
The Field Size property that stores positive and negative numbers to precisely 28 decimal places in 12 bytes.
Decimal Places property
The property that specifies the number of decimal places that are displayed to the right of the decimal point.
entity integrity
The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table.
null value
The value that results from not entering a value for a field; a null value is not permitted for a primary key.
keyboard shortcut
A key or combination of keys you press to complete an action more efficiently.
import
A process that allows you to copy the data from a source, without having to open the source file, and to add the imported data in an Access table.
Data Type gallery
An Access tool that allows you to add a group of related fields to a table at the same time, rather than adding each field individually.
Quick Start selection
The name given to the group of fields you add to a table at the same time using the Data Type gallery.
Address Quick Start selection
The Quick Start Selection that adds a collection of fields related to an address to the table at one time.
Default Value property
The property that specifies what value will appear, by default, for a field in each new record you add to a table.
delimited text file
A type of text file in which fields of data are separated by a character such as a comma or tab.
