.


:




:

































 

 

 

 





. , . , Access , .

. , .

1. (Create → Reports → Report Design).


.

2. | (Report Design Tools | Design → Tools → Add Existing Fields).

(Field List) .

3. , , .

 

. 11.8. ProductName. ,


Access : , , , (. 11.8).

 

 

Access , , , . .

 


. , . , . . 11.9 , .

, <Delete>.

 

. 11.9. , , , . ,

5. | (Report Design Tools | Design → Tools →Controls) (, , ).

.

6. , .

| , , , | , .


, , .

 

 

, (. . " " 10).

 

7. , / .

. . , , , . , .

8. , .

, . , .

9. .

, Office (File → Save) , Access .

 

 

. . Microsoft . .

 

 

, , , . ( 10), .

 

 

. . , .

1. (Create → Reports → Report Wizard).

.


2. , .

(Available Fields) .

 

 

, , , , (. . 6.11).

 

 

3. , , . 11.10. .

, .

 

 
 

. 11.10- > .

 

 

4. .
.

, , . " " .

5. ( ), , , .

, .

6. (. 11.11).

.

o (Columnar) , . , . , .


o (Tabular) , 10. Access .

o

 
 

(Justified) . . "" . , , .

 

. 11.11. Access,

 

7. 90, .

(Landscape) , .

8. .

, Access . , , .

9. .

, .

10. (Preview the report), , (Modify the report's design), . .

Access .


, . . ( , ).

 

, ( , ), Access . , , .

. , , . Avery, , . , .

 

 

, , Access . Access . , Word. Word , Access .

 

 

.

1. .

. , .

 

 

, (join query) (. . " " 6), , .

 

 

2. (Create →Reports → Labels).

3. . , (. 11.12).

4. ( ), ( ).

, , .



, , . , Access. Avery, . ( Avery .) , .

 

. 11.12. 2160,

 

 

, (Customize) (New Label Size) (New) (New Label). .

 

 

5. .

(. 11.13).

6. , . , , . , Access. ( ).

, Access .

7. .



. 11.13. Access , , ,

 


. 11.14. , . <>. (, ": " )

, (FirstName, LastName, Street, City . .). Access . { FirstName}, , FirstName.


. ( , .) . 11.14 , .

8. . 7 .

, , .

9. .

. ( , . , , .)

, (. . " " 6) (, , ).

 
 

, Access , .

10. .

.

 

. 11.15.

 

 

11. , (See the labels as they will look printed), , (Modify the label design), . .


Access (. 11.15) , . , ( . .).

Access, , . , Access , .

. ( ) . , . ( : .)

, . , , , | → → (Report Design Tools | Page Setup Page Layout Columns). , . , , . , , .

 

 





:


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


:

:

80% - .
==> ...

1295 - | 1180 -


© 2015-2024 lektsii.org - -

: 0.067 .