. Contacts () Marketing.accdb PotentialClients ( ) Sales.accdb. ( "Missing CD" Web- www.missingmanuals.com.)
1. -.
Marketing.accdb, .
2. , → →
(Create → Other → Query Design).
(Show Table).
3. -, , . (Close).
Contacts.
4. , | → → : (Query Tools | Design → Query Type → Append) ( | → →
: (Query Tools │ Design → Query Type → Make Table) ).
( PotentialClients Sales.accdb) . .
, Access (, ), . 8.6.
. 8.6. Access , . . , , ...
5. , , ... , .
Sales.accdb.
, . ( ), Access .
6. (Table Name) , .
, - , . .
, , Access . PotentialCIients.
|
|
7. , .
8. ( ), -.
, . FirstName LastName.
9. , (Append To).
FirstName F_Name. Access FirstName - F_Name (. 8.7). LastName L_Name.
. 8.7. Contacts Marketing PotentialClients Sales. ID , ID ID . ( , ID Contacts PotentialClients , .)
10. -, .
Access, , -. .
, , .
, , .
11. , .
, .
12. , , j → → (Query Tools │ Design → Results → Run).
Access , . . Access , , .
- . -, . " " ,
13. <Ctrl>+<S> ( ). .
, .
, 1
Access : , 1.
|
|
2, Access , 1. ( , , . " " 2.) , . , Boutique Fudge 1000, 5000, 10 000. . , , , 1.
, ( ) Access . , , . . , Access , . , 999, Access 1000 . .
.
1. ( → → (Create → Tables → Table Design)).
.
2. . , , .
(ID).
3. ( ) , (Long Integer) ( ).
4. .
, Access , , 1 . Access , .
5. , 1 , .
100 , 99. .
6. ( → → (Create → Other → Query Design)).
(Show Table) (!.) (Close).
7. J → → :
(Query Tools | Design → Query Type → Append) .
Access , , , .
8. , ( (ID)).
Access , , .
9. | → →
(Query Tools | Design → Results → Run).
, Access , .
10. , , .
, , .
11. , 1, .
. , , Access . ( ), .
|
|
. , : , Access . , .
, . . . " " 1 , .
. , , , , . .
.
1. ( → → (Create → Other → Query Design)).
2. , , . .
3. , | → → : (Query Tools | Design → Query Type → Delete).
(Delete).
4. , , .
, , . , Access .
5. , .
, , , , , . (*) . (From), , , .
. 8.8 .
6. , , .
, . (*), , .
7. , , | → → (Query Tools | Design → Results → Run) .
|
|
. 8.8. , ( DatePlaced ( ) 1900 .). (*) , , ,
Access , . , .
8. , <Ctrl>+<S> ( ). .
, . , .