Tables and fields also have properties that you can set to control their characteristics or behavior.
A table open in Design view
1 Table Property
2 Field Property
_________________________________________________________
In an Access database, table properties are attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in the table's property sheet, in Design view. For example, you can set a table's Default View property to specify how the table is displayed by default.
A field property applies to a particular field in a table and defines one of the field's characteristics or an aspect of the field's behavior. You can set some field properties in Datasheet view. You can also set any field property in Design view by using the Field Properties pane.
Data types
Every field has a data type. A field's data type indicates the kind of data that the field stores, such as large amounts of text or attached files.
A data type is a field property, but it differs from other field properties as follows:
- You set a field's data type in the table design grid, not in the Field Properties pane.
- A field's data type determines what other properties the field has.
- You must set a field's data type when you create the field.
NOTE: You can create a new field in Access by entering data in a new column in Datasheet view. When you create a field by entering data in Datasheet view, Access automatically assigns a data type for the field, based on the value that you enter. If no other data type is implied by your input, Access sets the data type to Text. If needed, you can change the data type by using the Ribbon, part of the new Microsoft Office Fluent user interface.
Examples of automatic data type detection
by Microsoft
Add to Cart
Examples of automatic data type detection
If you enter:
|
Office Access 2007 creates a field with a data type of:
|
John
|
Text
|
http://www.contoso.com
You can use any valid Internet protocol prefix. For example, http://, https://, and mailto: are valid prefixes.
|
Hyperlink
|
1
|
Number, Long Integer
|
50,000
|
Number, Long Integer
|
50,000.99
|
Number, Double
|
50000.389
|
Number, Double
|
12/67
The date and time formats recognized are those of your user locale.
|
Date/Time
|
December 31, 2006
|
Date/Time
|
10:50:23
|
Date/Time
|
10:50 am
|
Date/Time
|
17:50
|
Date/Time
|
$12.50
The currency symbol recognized is that of your user locale.
|
Currency
|
21.75
|
Number, Double
|
123.00%
|
Number, Double
|
3.46E+03
|
Number, Double
|
Overview: Table and field properties
0 comments:
Post a Comment