6-7
: .
: ³ Access.
: .
.
‑ , . . .
, . - , . , , , , . , : , , , , . , .
. ' FORM (), . NEW (). ³ NEW FORM ( ) : DESIGN VIEW (), ; FORM WIZARD ( ), , ; AU FORM () : COLUMNAR ( ), TABULAR (), DATA-SHEET (); CHART WIZARD ( ) ; PIVOT TABLE WIZARD ( ) , EXCEL.
: (DESIGN VIEW), (FORM VIEW), a (DATASHEET VIEW). VIEW VIEW .
1. .
1. .
NEW FORM ( ) FORM WIZARD ( ) OK. ³ . TABLES/QUERIES (/) , , , . AVAILABLE FIELD ( ) ">" SELECTED FIELD ( ) . ', ">>". SELECTED FIELD ( ) AVAILABLE FIELD ( ), "<". , , NEXT (). ³ , . , FORM WITH SUBFORM(S) ( ) NEXT (). , ', . , ' . , , , COLUMNAR (). , . NEXT. . , STANDART () NEXT. FORM . SUBFORM ( ) ‑ . OPEN THE FORM TO VIEW OR ENTER INFORMATION ( ). , . FINISH (). , ACCESS .
|
|
2. . EDIT => SELECT ALL. FONT , . SIZE - 12.. .
3. .
4. ֳ, * ʳ.
TEXT BOX . ‑ . ' ֳ, = []*[ʳ]. . VIEW => FORM VIEW.
5. . VIEW => DESIGN VIEW. VIEW => FORM HEADER / FOOTER ( ). FORM HEADER DETAIL, , , DETAIL . LABEL TOOL BOX . .
6. .
³ . L CONTROL WIZARDS ( ) ( ). ( ) , . ' , FIND A RECORD ON....( ...) NX (). , . NEXT (). , NEXT (). . FINISH (). . ³ FORM VIEW (). . ENTER, . , , .
|
|
.
7. .
³ . , . PROPERTIES (), OTHER (). CONTROLTIP TEXT (). . .̳.г. . . ϳ . .
㳺 , .
8. .
, . . , . : , , , ( ). - , , . . . ij ' . . ' , . ' , . '. ֳ , .
. 5 . . FORMS () ' NEW. NEW FORM ( ) CHART WIZARD ( ), , , 5 . ' , , , FIELD FOR CHART .
SS . . , SS . , .
DATA, . D , . . ' SUMOF . , . , . . ' , . NONE ( 䳿) . AXIS ( X) . . NX (). , , DIAGRAMA. FINISH (). FILE () => SAVE () ' ij.
|
|
9. .
. . VIEW () => FORM HEADER/FOOTER (/ ). FORM HEADER ( ) INSERT () => OBJECT ('). ' , , '. INSERT, CLOSE. , . PROPETRIES (), FORMAT. SIZE MODE ( ) : CLIP () ‑ ; STRETCH ( ) ‑ , , ; ZOOM ( ) ‑ .
9. ().
³ . CONTROL . ' . PROPERTIES, FORMAT, CAPTION . ' . . . LABEL . ϳ . . . . .
˳:
., ., ., ., . Microsoft Excel 2000 Microsoft Access 2000. SQL VBA. .- : , 2004.- 224 . (.121-133).