. And, , . , . . .
And And. , . , , 1 2000 .:
<Date() And >#l/l/2000#
Or , . , 1000 -1000:
>1000 Or < -1000
. . , Orders (), . Orders : DateOrdered ( ) DateShipped ( ). , , DateOrdered , DateShipped. , , - ?
, . , , .
.
1. | → → (Table Tools | Design →Show/Hide → Property Sheet).
(. 4.16).
. , And (. . " " ) , . , .
. 4.16. , , , . ,
2. .
. . [DateOrdered] < [DateShipped] , DateOrdered , DateShipped.
|
|
. , Access (, Date (), . " " ).
3. .
, . .
Access . ( ), Access .
, , , , | → → .
. , International Cinnamon, , . Orders :
Quantity () Product ()
10 Frosted Cinnamon Buns
24 Cinnamon Buns with Icing
16 Buns, Cinnamon (Frosted)
120 FCBs
( , , , .)
, , : , , Product . (, ), (sales performance), . Access , Frosted Cinnamon Bun FCB , , . , .
, . , , . , , , .
, . , , . , Orders, , , . Frosted Cinnamon Buns ( ).
, , FCB, .
Access : , , , . , . 5 .
|
|
: MEMO, /, , , , OLE, .