, (. . " " 6) . Boutique Fudge OrderDetails . ( ) . , , , .
, ProductID CustomerID, (, , ). , , , , , . . .
, ( Customers, Products Orders) . . 7.10 . CustomerID.
. 7.10. : , : Customers, Orders OrderDetails, , . $25. DatePlaced, , , , . . : OrderID LastName FirstName,
, , . 7.10. :
1. , → → (Create → Other → Query Design).
2. (Show Table) (Close).
. 7.10 Customers, Orders OrderDetails. Access , .
3. | → → (Choose Query Tools | Design → Show/Hide → Totals).
.
4. , , .
. .
o OrderID . , OrderDetails OrderID. . ( , , OrderID OrderDetails Orders .)
|
|
o OrderTotal , [Price] * [Quantity] OrderDetails. . Access , Sum. OrderTotal >=25, $25.
- LastName FirstName , . . ( OrderTotal) ( OrderID). , . , . ( , OrderDetails , . .) Access LastName FirstName, .
, . , Access . ( , ), OrderID CustomerID. , , ProductID Products, (, ProductName Description).
5. .
Access. . Access . .
. , , . , New York Customers, CaliforniaCustomers, Ohio Customers . .
, . , , . , .
:
1. , → → (Create → Other → Query Design).
2. (Show Table) (Close).
Customers.
|
|
3. | → → (Choose Query Tools | Design → Show/Hide → Parameters).
(Query Parameters).
. 7.11. , . , CustomerState
4. (. 7.11).
( , ). , . . : , , /.
5. .
, . , State:
[CustomerState]
, , Access , .
Access (Enter Parameter Value) (. 7.12). . State.
. 7.12. . -
, , . , Access . , .
, , . . .
, ( ). , IV, .
8