,
, . , Excel. :
1. , .
2.
, , .
, . , :
1) , .
2) , , , .
3) .
s SQL transform(transform ANSl SQL.
, . "" ( ) ( ). , , , , .
.
:
1. , .
2. ; , .
3. , , .
4. , .
5. , .
6. , .
7. ( ) . .
,
|
|
,
:
;
;
;
, , ', ;
:
1. (Table Wizard).
2. (Table Design).
3. .
4. ' .
Access , , , ³ :
1. ' (Objects) (Tables) (Create Table By Using Wizard) (. . 23.2).
2. (New) (. . 23.2) (New Table) (Table Wizard) (. 23.11).
. 23.11
ϳ ' (Objects) (Tables) (Create Table By Using Wizard) (. . 23.2), . ij (Business) (Personal) (. 23.12). , , .
. 23.12
(Sample Tables) , , (Sample Fields) , .
, :
< ;
<< ;
> ;
>> .
(Fields in my new table). , .
(Rename Field) ' , ' . , , . . , .
(Next) (. 23.13):
Microsoft Access (Yes set primary key for me) . ˳ (AutoNumber).
(No, I'll set primary key) .
|
|
. 23.13
.
' ', ' (What Do You Want To name Your Table?).
, ' , , , . Visual Basic. , , ' .
. , 䳿 :
.
, .
, , .
- (Finish) .
(), , . , . , , . , . ' , .
(Null) . - . Null , , , , . Null , .
˳ (AutoNumber) , (. ). .
(composite primary key) . ³ , . , (. ' ).
, . , . , . ' .
(No, I'll set primary key) (. 23.13) , (What field -will hold data that is unique for each record?) (. 23.14). , :
, (Consecutive number Microsoft Access assigns automatically to new record) Access , , .
|
|
, (Numbers I enter when I add new records) .
, (Numbers and/or letters I enter when I add new records) , .
MS Access , :
.
, .
.
( , ).
' ' Access ; Access. .
:
1. ( ).
2. .
3. .
4. .
5. ().
6. .
:
1. ().
2. .
3. .
4. .
5. .
6. .
7. .
8. ().
9. .
:
1. ( ).
2. .
3. :
< ( ( )), << ( ( ) ( )), > ( ( )), >> ( ( ));
( Access );
䳿 : , .
(), (). ³ (), ().
4.
ϳ . . . ' , .
, Tab ( Shift+Tab ).
|
|
, , .
5.
³ "--" , .
"--" ' .
³ "--" , "--" , ' .
, HTML .
Table Wizard - Table Design ( ). (. 4.27).
. 4.27.
, . , , ' :
, Rows (), +, -;
, Columns (), +, -;
, , ( , . . 4.27) ;
' , :
1. ( );
2. Column Span + (' );
' , :
1. ( );
2. Row Span (' ).
Row Span Column Span - , ' .
, HTML, , , , :
Rows <TR>, <TABLE>;
Columns <TD>, <TR>;
Column Span COLSPAN <TD>;
Row Span ROWSPAN <TD>.
. 4.28.
, , . 4.28, :
1. .
2. Columns ( ).
3. Column Span + ( ' ).
ϳ , Finish (). HTML-.
, Next ().
- Table Properties ( ) - , <TABLE> (. 4.29):
ALIGN - 䳿 , : , ; , Alignment ();
CELLSPACING ( ) ; Cell Spacing ( );
CELLPADING ( ) ; Cell Padding ( );
WIDTH, HEIGTH , ( ) , ; , %;
|
|
BGCOLOR ( ); , , ' Use Color ( );
BORDER , - , ; , , , ( ); 0, ; Size (); 0, ' Frames Rules: , .
. 4.29. , <TABLE>
ϳ - , - Cell Properties ( ). , , Finish.
, - , (. 4.30). , . , .
. 4.30. ,
Cell Properties :
ALIGN- ; , Horizontal'
VALIGN- ; - , Vertical;
WIDTH - ( ) , ; , ; ;
NOWRAP - ; , , ; NOWRAP , . ; No Wrappin (He ).
, Header () , ( ). ֳ <>.
Content ().
HTML-, , , . .