Write two data types of a field with example?
Answers
Answer:
There are four different types of record-level fields in Progeny: Individual, Pedigree, Sample, Marker. Individual database fields—Individual database fields are stored at the individual record level.
Basic Types
Format
Use to display
Text
Short, alphanumeric values, such as a last name or a street address. Note, beginning in Access 2013, Text data types have been renamed to Short Text.
Number, Large Number
Numeric values, such as distances. Note that there is a separate data type for currency.
Currency
Monetary values.
Yes/No
Yes and No values and fields that contain only one of two values.
Date/Time, Date/Time Extended
Date/Time: Date and time values for the years 100 through 9999.
Date/Time Extended: Date and time values for the years 1 through 9999.
Rich Text
Text or combinations of text and numbers that can be formatted using color and font controls.
Calculated Field
Results of a calculation. The calculation must refer to other fields in the same table. You would use the Expression Builder to create the calculation. Note, Calculated fields were first introduced in Access 2010.
Attachment
Attached images, spreadsheet files, documents, charts, and other types of supported files to the records in your database, similar to attaching files to e-mail messages.
Hyperlink
Text or combinations of text and numbers stored as text and used as a hyperlink address.
Memo
Long blocks of text. A typical use of a Memo field would be a detailed product description. Note, beginning in Access 2013, Memo data types have been renamed to Long Text.
Lookup
Displays either a list of values that is retrieved from a table or query, or a set of values that you specified when you created the field. The Lookup Wizard starts and you can create a Lookup field. The data type of a Lookup field is either Text or Number, depending on the choices that you make in the wizard.
Lookup fields have an additional set of field properties, which are located on the Lookup tab in the Field Properties pane.