, .
, (, 153 49), (49, 153). . Access , , . , . . 49 153 , 153, 49, 4 ( 49) 1 ( 153).
, . , Access ( Z):
1. .
2. .
3. (, ).
4. .
5. .
, ( ). , (Van Hauser), , , , , .
, Access , , . , , . , , , :
Smith, Star
Smith, Susan
Smith, Sy
Smith, Tanis
, , . . .
1, → → (m →Sort & Filter →Clear All Sorts).
Access .
2. .
( , ), FirstName (). . 3.1 , .
3, .
LastName ().
. , , . ( ). : Middlelnitial ( ), FirstName (), LastName (). :
|
|
Smith, Star
Smith, Susan
Smith, Susan P
Smith, Sy
, 3 . , . , .
, , . , - , , , (dating service) , . , , , . - , .
Access . .
(quick filter) , , , . , , . . , , . , . . 3.9 , .
( ) (Clear Filter).
. , , , , , , , / . MEMO (, , ), .
. , , . . , . , . → → (m → Sort & Filter → Remove Filter).
, . , , , .
|
|
, , , , . ( , .)
. 3.9. ( ) , -. , .
(filter by selection) , . , , . , .
. , . (. 3.10).
, , . , , .
. 3.10. . ( City, ) , ( "Chicago"), , ( "Chicago"). , , , "Chicago". , "Chicago land" "Little Chicago"
, .
. , .
■ . , .
/. , .
. 3.11. / , . ,
, , . "Great at darts" ( ) Description () , "darts" . , "darts". .
Access , . 3.11.
. , : . , .
|
|
. 3.12. : , PurchasePrice ( ), , . : . , . , ,
, , 85 .
85, . , 85 , ? .
. . . , (Text Filters), (Number Filters) . . . 3.12 .
, , .
■ . , , , .
■ . , , , , . . , , .
■ /. , , , , , (Yesterday) (Last Week), (Next Month), (Year to Date), (First Quarter) . .