- ;
- ;
- 䳿 .
.
.
, () . - , , , ..
- ᒺ (), .
ᒺ () - , , , . ᒺ , , .
ᒺ . ᒺ. , ᒺ.
, ᒺ - 볺 .
- , , .
.
- , ( ). , ᒺ , . . , .
:
1. .
. ֳ . , . .
2. ᒺ .
ᒺ, ᒺ, ᒺ, , ᒺ, , ᒺ.
. ᒺ .
³, , ᒺ . г , :
) (1: 1);
) (1: );
) (: ).
, ᒺ ᒺ .
ᒺ 0, 1 ᒺ , ᒺ 1 ᒺ .
|
|
, ᒺ 0, 1 ᒺ .
3. .
.
ᒺ , () , .
. , . , .
, .
. , , , .
.
. , (). .
:
1 .
2 ³
3
4
, , , . , . , , , . . , .
Microsoft Access.
Microsoft Access . Access . , - .
. 䳺 , , . , 볺 . . . , ̒ ˲ .
, . .
|
|
(TEXT): (, ), (, ), , (, ), ( / -).
(NUMBER): , (, ).
(DATE/TIME): /
(CURRENCY) - . (), $ (), DM ( ) ..
(YES/NO), /Ͳ (YES/NO) (TRUE/FALSE).
(MEMO): ( 32 000 )
.
Access , 璺 . .
.
, . . Access . , , . . ³ , .
, 볺, , ..
, ᒺ.
䳿, . : 䳿, , , - .
. , Access. ³ Access-Basic. 䳿, , . , . , Access-Basic, .
, Access ᒺ Access. , , , , , , , , , ᒺ, , (Clipboard).
.
Access . . ֳ .
.
, , . , 䳿. .
.
, 䳿. . , 䳿. , . , . ϳ . , .
, , Microsoft Access.
.
(Builder) - Access, . - . , . , Access . - , , , , .
|
|
.
, . , , 볺 . . ϳ , .
(Dynaset), , , - , , . - , . .
.
. , , , , , .
䳿. , , ֳ , .
䳿.
, , , .
, .
. , .
, , , . , , , , . , . .
. , , . , , .
. , -, .
.
.
QBE-, , .
, SQL-, , .
- , SQL-. , , , .
|
|
Access SQL-.
- .
.
Access , , . : - , , , .
- , , , .
.
Access. , , .
Access , , , , (볺) . , . , .
, . . , .
.
, . MS Access (, , , ), -
, . . . - 볻 , , . .
1. ?
2. ?
3. ?
4. ?
5. ?
6. ?
7. ᒺ ?
8. ?
9. .
10. .
11. .
12. .
13. .
1
13. Microsoft Office. Access
: Access .
1. .
2. .
3. .
4. .
5. .
6. .
7. .
: .
. Access.
1. .
2. Access;
3. .
4. ³ .
5. (New Query), :
5.1. (Queries);
|
|
5.2. (New).
5.3. (New Query), , :
Ø (Design View) - ;
Ø (Simple Query Wizard ) - ;
Ø (Crosstab Query Wizard) - , , ;
Ø (Find Duplicates Query Wizard ) - , ;
Ø (Find Unmatched Query Wizard) - , , .
5.3.1. ;
5.3.2. Ok.
6. :
6.1. (New Query) (Design View) Ok;
6.2. (Show Table).
6.3. (Show Table), , , :
Ø (Tables);
Ø (Queries);
Ø (Both).
6.3.1. (Tables), ;
6.3.2. ;
6.3.3. (Add);
6.3.4. 볺;
6.3.5. (Add);
6.3.6. , (Close), .
: (Show Table) (Query) (Show Table) .
6.4. ³ . . .
, . .
, . , . ( 1).
.
:
1. .
2. .
3. .
6.5. :
: (Table) , (View) (Table Names).
6.5.1. Drag and Drop , , (Field) , , (Field) .
6.5.2. , [Ctrl] (Field).
, .
, .
6.6. , 볺 .
- _;
- ;
- _;
- _;
- ;
- _.
6.7. :
6.7.1. , , , ;
6.7.2. [Del].
6.7.3. , .
6.8. * , , , . , ' *, *.
: : , .
6.9. - , , - ; [Del].
: , , .
6.10. , 볺 :
- _;
- ;
- _;
- _;
- _;
볺:
- ;
- _;
- ;
- _.
7. , 볺 볺, , .
7.1. Access, . .
볺 , , (Criteria) :
- _ -.
7.2. :
7.2.1. , (Criteria) _, .
7.2.2. ϳ [ Enter], Access ;
7.3. :
7.3.1. (Query Design) (Save).
7.4. , :
7.4.1. (Query Name) , , , ;
7.4.2. Ok.
7.5. (Query) (Run)