. . ( , BoutiqueFudge.accdb, , .) , 2007 . . 6.6.
. 6.1. 5
, .
1. → → (Create → Other → Query Design).
, . Access (Show Table), (. 6.1).
2. , , (Add) ( ).
Boutique Fudge Orders.
Access , . , .
3. (Close).
, .
. 6.2. Access . . , ,
4. , .
(. 6.2). ,
. Boutique Fudge, , , ID, DatePlaced CustomerID.
, (*). . , , .
. , ( ).
5. , , .
, . ( , , .) , ( . 6.3).
|
|
. 6.3. , . . DatePlaced
6. , (Show).
, Access , . , . , .
7. .
, , . ( ) , , . , , (Sort) . , (. 6.4).
. 6.4. , , .
. , , () . , 5.
8 .
(. . "" 3) , .
. ( .)
, (Criteria) (. 6.5). DatePlaced , , : >=#1/1/2007# And <=#3/31/2007#
. , , .
. 6.5. , , ( 1 1 2007 ). , (, 1 2007 . ), #
|
|
9, | → → (Query Tools | Design → Results → Run).
. , , ( ) . ( . 6.6 Orders.)
, (Design View).
. 6.6. , , . , ,
, . - Orders, , Orders. , .
10. .
<Ctrl>+<S>. , Access , ( ). , . . , .
Access . , . , . FirstQuarterOrders_2007 ( 2007) . 6.6.
, , , , . , .
(. 6.7). (All Tables), , . , .
, . , TopProducts,
Products ( >50 Price). , , TopProducts. .
. 6.7. , . , TopProducts ( ) Products
Access , . ( .) , .
, , . . → → → (Home → Records → Refresh → Refresh All). , Access , .
|
|
, . , Access . , , , .
. Access, ( ), .
. , 1032, :
=1032
, (Criteria) CustomerID.
1032 =1032, , . ( ), Access, ( 1032), .
(. . " " 5), Access , . , Classes InstructorID ( , ). =1032 InstructorID, Access , 1032 , .
, .
, . CustomerID Orders, , 1032. , Hancock, John ( ).
, . -1032 CustomerID , =Hancock, John , . ( Customers, Orders.)
, . , Orders, , . :
(ID) Customers . Orders;
Customers . , . " " .
|
|
, . Access , .
="Harrington Red"
. OrderTotal , 10 50 :
<50 And >10
( 50 10), And (. . " " 4). Or, , . 7 .
. # (. . " " 4). DatePlaced, , 2007 .:
<#1/1/2008# And >#12/31/2006#
1 2008 ., 31 2006 .
, , , , . , Access .