, ?
. , . Access , .
Employees (SSN), Access . .
, , " . " . " " . 6. , . , , Access .
. , People () . .
, , , . .
, . . , .
, . . 1. | → → (Table Tools | Design → Show/Hide → Indexes).
(Indexes) (. 4.6). .
. 4.6. , .
ID ( Access )
,
2. . (Index Name)
Access , . , (, LastName+FirstName).
|
|
3. (Field Name) (, LastName).
, . . . " . " . " " 6.
4. (Unique) . , ( , ).
(Ignore Nulls), , Access () . , (SSN) . SSN , , . , Access () SSN, , , .
, . " " .
(Primary), .
5. . ( Access , ), (, FirstName).
( ), , . . 4.7 , . .
. 4.7. ,
, . Height (), , ,
. , PhoneNumber ( ), , . , (, (844) 547-1123), (, 847-547-1123), (547-1123), . - (, ).
, 4.8. : PhoneNumber , . , , . PhoneNumber , -. : . 1234567890 , : (123) 456-7890. 1234567890, .
|
|
, , , . ( ) Access, . , Access
, . . 4.8 , Access .
. ,
■ . , -, . (_ _ _)_ _ _ - _ _ _,
.
■ . , . , (012-86-7180), (012867180).
■ . , . , .
■ . .
. - , , ( , ). , , . , (//, -- . .).
. , , . , . . ( , , , 0 -14, , , . .)
, . , .
/.
, Access. , . . .
, .
1.
, .
PhoneNumber.
|
|
2. (Input Mask), .
(...) , . 4.9.
. 4.9. (...) Access , . - (, )
3. .
(. 4.10).
4. .
(Phone Number).
, ? , . " " . , , . .
5. (Next).
(. 4.11).
6. , - .
, . . 4.2.
- , . (_).
, , , (Placeholder character).
. 4.10. . . , , ,
. 4.11. !(999) 000-000. 9 0 9. 0 0 9. , (123) 456-7890 , 123-4567, (123) 456
7. .
, (. 4.12).
, Access , . 9 (Finish).
. 4.12.
8. , .
( , , ). , - . , (416) 123-4567 4161234567. .
. , , , (416) 123-4567. , .
9. .
(Input Mask). , , , . 10, ( 10 ), 14, ( , ).
|
|
10. , Access . .
Access . -. ( IV) . , , (validation rule).