Databases

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

A rule to make sure that only reasonable and sensible data is entered.

• Filter
• Query
• Validation
• Verification

Text, Number, 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 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

Which of these is not a type of validation?

• Proof Reading
• Range
• Limit
• Presence