A feature that can be attributed to data under a certain field (often the primary key) of a table that will automatically create a unique number for each entry. Best used with ‘integer’ data type.
A field which uniquely identifies a record, e.g. Staff ID number or Item Barcode. The database creator can specify which field to set as the primary key. If none of the existing fields have unique identifiers, the autovalue feature can be set for integers to create a unique ID for each record.
A method of linking records between tables to save repeating the same data. E.g. Names in one table, phone numbers in another, linked by staff ID number. Data cannot be altered in a secondary table without the primary table being altered first to preserve integrity.
Characters including * and ? that are used in searches or queries to represent one or more other characters.