|
|
|
These tables are a reference to Database (Creating) tutorial. Field properties are set in Design View. There are many drop-down menus for the field properties: Field Size A text field is limited to a specific number of characters. Size Largest Number Decimal Places Byte 0 to 255 (no fractions) No decimal places / rounded Integer -32786 to 32786 (no fractions) No decimal places / rounded Long Integer -2,147,483,648 to 2,137,483,648 (no fractions) No decimal places / rounded Single -3.4x10 to 38th to 3.4x10 to38th Up to 7 decimal places Double -1.797x10 t0 308th to 1.797x10 to 308th Up to 15 decimal places The default is Double Format Controls the way data appears Number Formats General Displays a number the way it was entered. This is the default. Currency Uses a comma as a thousands separator and displays the currency symbol. Negative numbers display in parentheses and the default is two places. Fixed Displays at least one digit. Default number is 2 decimal places. Standard Uses a comma as a thousands separator and the default number is two decimal places. Percent Multiplies the number by 100 and places a percent symbol at the end; the default is 2 decimal places Scientific Expresses numbered as multiples of exponents of 10 in standard scientific notation Date and Time Formats General Date Only a date or time is displayed. This is the default Long Date Day and month are spelled out : Thursday, January 21, 1999 Medium Date Month is abbreviated and the name of day is omitted: 01-21-99 Short Date Date appears as numbers separated by slashes : 1/21/99 Long Time Time appears in hours, minutes, seconds : 10:30:15 AM Medium Time Time appears in hours and minutes : 10:30 AM Short Time Time appears in the 24-hour clock format: 18:30 Yes / No Formats Fields display as: Yes or No True or False On or Off If you specify Yes/No and a user enters True, Access automatically converts is to Yes, etc. Decimal Places Used for number of currency fields, this field displays a set number of decimal places Input Mask Creates a pattern for the input of data; for example, the hyphens used in a telephone number Caption A label other than that found in the field name Default Value Displays a specific value for a field in new records. The default value is automatically entered in the field when you crate a new record. To set a default value, open the property box. Use the Expression Builder if needed. Example: ="Net 30 days" Validation Rule Limits the data entered to value that meet certain criteria. Example: Credit Limit field cannot be over $10,000 Validation Text The text you want to appear in an error message if the data entered violates the validation rule Required Specifies whether or not a field is mandatory. Indexed Speeds retrieval of data in a field. All primary key data is automatically indexed. February 02, 2010 Sr. Arlene Callahan |