1. Field Properties 1 (14:40)
Design View
Field Size
AutoNumber Field Size
What is a Replication ID
Text Field Size
Number Field Size
Byte
Integer
Long Integer
Single
Double
Decimal
Warning: data may be lost

2. Field Properties 2 (5:13)
Caption
Changes default form label
Changes column header in datasheet
Don't confuse with Description

3. Field Properties 3 (16:02)
Format Property
Number Formats
General
Currency
Euro
Fixed
Standard
Percent
Scientific
With percent 1 = 100%
Decimal Places
Rounded values displayed
Actual values stored
Currency Formats
Format might hide data
mm dd yyyy
hh nn ss
F1 for Access Help
List of Date Format Codes
Text Format
Phone Numbers
@@@-@@@-@@@@
Yes/No Format

4. Field Properties 4 (5:25)
Input Mask Phone Number
Placeholder characters
Store symbols in the mask?
Enter data
Warning message on invalid data
Date/Time Input Masks
No Wizard for numbers/currency
Help for Input Masks

5. Field Properties 5 (9:47)
Default Value
State of NY
NumEmployees 1
DiscountRate .05
Automatically set current date
Date() Function
Now() Function includes time
Yes/No Default Values

6. Field Properties 6 (16:16)
Validation Rule
Inequality Symbols
NULL Values not the same as ZERO
Existing data violates rule
Validation Text
ESC escape to cancel editing
Range of values
AND OR
BETWEEN keyword
Date Values #1/1/1980#
Date() Function in Validation Rule
Functions in Validation Text