.


:




:

































 

 

 

 





, , . , .

, . Access Office, . , .

, .

1. (Create →Other →Query Wizard).
Access (. 6.10).

2. . (Simple Query).

. .


.

o (Simple Query Wizard)
, .
.

o (Crosstab Query Wizard) , . . " " 9.

o

 
 

(Find Duplicates Query Wizard) , , , , . (. . " " 4), .

o , (Find Unmatched Query Wizard) , , , . , . , . " " .

 

. 6.10.

3. .

.

4. . (Tables/Queries) , . , , . 6.11.


. , .

 
 

. , , . , . . " " .

 

. 6.11. > ( ). , , <.

 

 

5. (Next).

, , . 7. , , ( ) (Detail), a (Next).

(. 6.12).

6. (What title do you want for your query?).

7. , (Modify the query design). , , (Open the query to view information).

, - (. . "" 3)


. , .

8. (Finish).

 
 

, 7. | (Query Tools | Design → Results → Run).

 

. 6.12.

 

 





:


: 2016-03-28; !; : 508 |


:

:

- , .
==> ...

1565 - | 1378 -


© 2015-2024 lektsii.org - -

: 0.009 .