Databases

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

A group of related records.

• Entity
• Validation
• Field
• Filter

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

A method of only displaying records in a table that match specific criteria...

• Filter
• Validation
• Sort
• Verification

A method for checking data entered e.g. Proof Reading or Double Entry.

• Verification
• Filter
• Data Types
• Query

A database search that can be saved as a separate file.

• Query
• Validation
• Filter
• Verification

A data type used for storing numbers with a fractional part e.g. 3.142

• Integer
• Boolean
• Real / Float
• String

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

A data type that can only hold 2 values e.g. Yes/No or True/False.

• Boolean
• Integer
• Real
• String