An arrangement of columns and rows.  The fundamental building block of all databases.

A single piece of data in a database table.

A grouping or category of similar information contained in a table.

A complete description of all of th field related to one item in a table.

Used to control how data in a particular field will be searched, sorted, or used in calculations.  The default format is text.

The data type that is used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations.

The data type used for data that may be calculated, sorted, or filtered.

Number

The data type used for lengthly entries that allows combinations of text and numbers.

The data type used to arrange and sort data chronologically, often used with the input mask field property.

The data type used to format numbers as decimal values with a dollar sign.  The default format is two decimal places.

The data type used to automatically assign a number to each record and to assist in preventing duplication of data.

The data type in toggle format that allows a user to select a yes or no value in a database cell.  The default setting is No.

A data type used to define preset values for database entries.  This feature increases productivity and accuracy by reducing the amount of data entry required.

In a database, it is used to control how data is entered in a field.

Used to control the size of a field.  Measured in characters.

In a database, used to control the layout of the field, such as one or two decimal places.

A template-like field property that regulates how data is entered in a cell. 

A field property used for column naming that allows a more user-friendly and properly formatted field name than the field name stored in the database design.

Allows for the retrieval of information that meets specific criteria.

Allows for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending.

The type of relationship that occurs when a record in one table is linked to more than one record in another table.

The type of relationships that are formed by connecting two or more tables that have a one-to-many relationship. The connection is made by a Junction table.

A relationship compenent that is used to format each record in a database as a unique entity.  This relationship allows database tables to communicate.

The relationship component that is used when tables are linked by the primary key, the related field in the second table is known as this...

A table used to join primary key fields from multiple tables.

A graphical representation of the link between two or more tables.

Useful and practical method for obtaining information from other sources and creating database tables.  Elimates the need for repetitive data entry and assists in the protection of the data's integrity.

Used when you want something other than an exact matched when perofrming a query.