Year 12 Database Flash Cards

Front

Definition of Data Dictionary

Back

Contains details of the field headings and data types in a database.

Front

Definition of Data Type

Back

A formal description of the kind of data being stored or manipulated within a program or system, such as alphanumeric data, numerical data, or logical data.

Front

Use of Text (or String) or Alphanumeric Data Type

Back

Text and data that is a mixture of text and numbers, such as a postcode.

Front

Use of Number Data Type

Back

Numeric data that requires a mathematical calculation, such as integers or real numbers.

Front

Use of Date/Time Data Type

Back

Dates and times, allowing addition and subtraction of dates.

Front

Use of Currency Data Type

Back

Monetary data such as item price, including two decimal places.

Front

Use of Autonumber Data Type

Back

Generates sequential numbers automatically for each new record created.

Front

Use of Yes/No Boolean Data Type

Back

Contains one of two possible values, such as Yes/No or True/False.

Front

Use of Calculated Data Type

Back

For the result of a calculation produced from another field in the record.

Front

Use of Lookup Wizard

Back

Creates a list of values that can be selected and entered into fields.