A record is a set of entire data items in a row. In the above table if for example we consider the data items in the second row, it contains Martin in the names field, m in the sex field, in the district field and 120,000 in the allowance field. All this information can be described as a record that pertains to Martin. Field names A field name is the title of a particular column (field). For example the titles; names, sex, district, and allowance are field names. They are also referred to as the field labels. Data types A data/field type specifies the format to which the data items are stored. Different data items are stored differently in a database. For example, not all numerals are numeric data types. Microsoft Access supports up to nine different types of data. These could be text, memo, number, data/type, currency, yes, no, OLE object, auto number, lookup or hyperlink field. The table below summarizes the implications of each of these fields. Field Type Data Stored Auto Number A number that is automatically assigned incrementally or randomly to a particular record and decimal place Currency A numeric field that is automatically assigned a currency sign, thousands separator and decimal places. Date/time A date or time data types you can change the appearance of each from the general tab. Hyperlink Stores data types like internet address (e.g. ) Text Any characters that will not be used for calculations for example phone numbers Lookup wizard Stores values that are from an external table, query, or a list of specific values Memo Whole sentences of up to 64,000 characters in length including spaces Numbers Any numerals that may be used in calculations for example amounts. OLE Any linked object like a picture, sound, document or photograph. Yes/No A logical field that will need only a yes or a no, true or false, on or off Field properties A field property is the specific characteristic of a particular field. Field properties are specified from the general tab on the data-table structure. They include field
A record is a set of entire data items in a row. In the above table if for example we consider the data items in the second row, it contains Martin in the names field, m in the sex field, in the district field and 120,000 in the allowance field. All this information can be described as a record that pertains to Martin. Field names A field name is the title of a particular column (field). For example the titles; names, sex, district, and allowance are field names. They are also referred to as the field labels. Data types A data/field type specifies the format to which the data items are stored. Different data items are stored differently in a database. For example, not all numerals are numeric data types. Microsoft Access supports up to nine different types of data. These could be text, memo, number, data/type, currency, yes, no, OLE object, auto number, lookup or hyperlink field. The table below summarizes the implications of each of these fields. Field Type Data Stored Auto Number A number that is automatically assigned incrementally or randomly to a particular record and decimal place Currency A numeric field that is automatically assigned a currency sign, thousands separator and decimal places. Date/time A date or time data types you can change the appearance of each from the general tab. Hyperlink Stores data types like internet address (e.g. ) Text Any characters that will not be used for calculations for example phone numbers Lookup wizard Stores values that are from an external table, query, or a list of specific values Memo Whole sentences of up to 64,000 characters in length including spaces Numbers Any numerals that may be used in calculations for example amounts. OLE Any linked object like a picture, sound, document or photograph. Yes/No A logical field that will need only a yes or a no, true or false, on or off Field properties A field property is the specific characteristic of a particular field. Field properties are specified from the general tab on the data-table structure. They include field
General_43_1506634416.docx