Sum(.*.) AS
FROM INNER JOIN
ON . = .
WHERE .=+
GROUP BY .;
SELECT ., Sum(*) AS
FROM INNER JOIN
ON . = .
WHERE .=+
GROUP BY .;
5.2. . 20.
. 20. 1
: , .. , .
SELECT .
SELECT ., Sum(*) AS
FROM INNER JOIN
ON . = .
GROUP BY ., .
HAVING .=+;
, ( WHERE .=+), , (GROUP BY ., .), (HAVING .=+). , , .
5.3. _14_1.
6. 2: SELECT : . 2.22.
2.22
2
(. 21).
. 21. 2
6.3. _9_2.
7. 3: SELECT . 2.23:
2.23
3
| ʳ | |
.
7.1. (.22):
. 22. 3
7.3. _9_3.
8. .
9. .
11. .
[ 3 ], [ 7 ], [ 20 ], [ 24 ], [ 25 ].
10
14. SQL
: SQL .
1. SELECT.
2. ᒺ UNION SELECT.
|
|
|
3. .
: .
. Access.
1. .
2. Access.
3. , :C:\ \ \ \ ( ).
4. SELECT.
I. ᒺ
ᒺ UNION.
ᒺ SELECT :
SELECT FROM
UNION
SELECT FROM ...
ᒺ :
ü
ü , ᒺ, .
ü ( ) SELECT, , SELECT.
ü UNION , , ALL ( UNION) . .
ü GROUP BY () HAVING - .
ü , ORDER BY, .
II.
. , , .
5. 1: SELECT () .
. 2.24.
2.24
3
| ʳ | |
5.1. :
5.1.1. , .
5.1.2. , .
5.1.3. ᒺ . ' ' .
5.1.4. .
: , . .
6.2. _10_1, _10_2.
7. .
8. .
9. .
[ 3 ], [ 7 ], [ 20 ], [ 24 ], [ 25 ].
|
|
|
3. Ͳ ֲ
.
4.
1
13. Microsoft Office. Access
: Access .
1. Access.
2. .
3. .
4. .
5. ( , , , , , , , , .).
6. .
7. .
8. .
9. .
10. .
11. .
12. .
13. .
14. Access.
: .
. Access.
1. .
2. Access, :
ʔ _ _ Microsoft Office _ Microsoft Office Access 2003
(Start _ All Programs _ Microsoft Office _ Microsoft Office Access 2003)
3. ϳ Access .
4. :
(Help) : Microsoft Office Access, Access Access (Help Access) .
Access .
5. .
5.1. (File) (New) (New), (New File).
5.2. (New) (New Database);
5.3. (File New Database), :
5.3.1. (Folder) , ;
5.3.2. (File Name) , .
: 255 .
Access db1, , db2 ..
Access .mdb.
5.3.3. (Save as Type) , :
Microsoft Office Access (Microsoft Access Databases)
(All Files).
: , .mdb, . .
5.3.4. (Create).
5.4. , .
|
|
|
6. .
6.1. ᒺ . , . . Access 32 768 , 255 .
6.2. , - . 볺 . , , , 볺 .
6.3. , , , , .
, .
6.4. Access , ᒺ . , - . ᒺ (, 볺 ), - ᒺ (, 볺).
, :
_
_
_
_
_ .
7. :
7.1. , :
7.1.1. (Objects) (Tables).
7.1.2. (New).
7.2. (New Table), , :
Ø (Datasheet View);
Ø (Design View);
Ø (Table Wizard);
Ø (Import Table);
Ø (Link Table).
7.3. :
7.3.1. (Design View);
7.3.2. k.
7.4. ³ , , :
: Access .
7.5. .
7.5.1. (Field Name) .
: 64- - , , .
, Access .
7.5.2. (Data Type) , , . , .
7.5.3. (Description) . , .
: , , , , , .
[Enter] [Tab]. . , .
|
|
|
7.5.4. .
, , .., , , . (Field Properties), , [F6]. :
Ø [Tab] ;
Ø [ Shift ] + [Tab] .
.
7.6. , :
7.6.1. , _. [Enter] [Tab], ;
7.6.2. , , . , (AutoNumber), . [Enter] [Tab], ;
7.6.3. , , : .
: , , , , , .
, .
7.6.4. _ , :
7.6.4.1. (Edit) (Primary Key) , .
: . , . 1 , (Field Properties) (New Values) (Increment).
. (Indexed) ( ) (Yes (No Duplication)). .
7.6.5. (Field Properties) [F6].
7.6.6. , .3.1.
3.1
| : | |
| : | |
| : | ( ) |
7.6.7. [F6].
7.6.8. [Enter] [Tab].
7.7. , .3.2.
3.2
| _ | ( ) | |||
| - | ( ) |
3.2
| - | ||||
| _ | - | |||
| - | ||||
| _ | - | |||
| _ | - | |||
| - | ||||
| _ | / | - |
: .
( ), , ( ) .
|
|
|
, - .
8. :
8.1. (File) (Save).
8.1.2. (Save), :
8.1.2.1. , 볺;
8.1.2.2. k.
9. , :
9.1. , .
9.2. , , :
9.2.1. (View) (DatasheetView) (View).
10. 10 .
: : , . [Tab]. ϳ [Tab], Access . ͳ : .
_ : .
11. (Close).
12. ³ .
13. :
: .
13.1. ;
13.2. , , ;
13.3. [Tab] [];
13.4. [Shift]+[Tab] [].
: Access , [Tab].
, . Access .
13.5. [Ins]. ٔ (OVR) Access.
13.5.1. .
13.5.2. . , .
13.6. (Record), , , . 23.
 |
. 23.
: ֳ .
13.6.1. [Enter].
13.6.2. [á] [â].
14. , (Table Datasheet) .
14.1. :
14.1.1. , , ⇨, .
14.2. :
14.2.1. , , ⇨;
14.2.1.2. , , () , ;
14.2.1.3. ³ .
14.3. ᒺ , [Tab].
14.4. .
15. (Table Datasheet) :
15.1. , ⇓;
15.2. .
16. (Table Datasheet) :
16.1. , , ⇓;
16.2. , , , ;
16.3. ³ .
17. (Table Datasheet) :
17.1. , ;
17.2. (Insert) (Column).
18. (Table Datasheet) :
18.1. , ;
18.2. (Edit) (Delete Column);
18.3. , , .
19. (Table Datasheet) :
: .
19.1. , ;
19.2. (Edit) (Copy);
19.3. ;
19.4. (Edit) (Paste);
20. (Table Datasheet) :
: .
20.1. , ;
20.2. (Edit) (Cut);
20.3. , , ;
20.4. ;
20.5. (Edit) (Paste);
20.6. , , .
: ij , .
21. (Table Datasheet) :
21..1. , ;
21.1.2. [Del];
21.1.3. , , .
: .
22. (Table Datasheet) :
22.1. , ;
22.2. , , ;
22.1.3. ³ .
23. ( ) (Table Datasheet) :
23.1. , , ; ;
23.1.2. , , ;
23.1.3. ³ .
24. (Table Datasheet) :
24.1. , ;
24.2. ;
24.1.3. ;
24.1.4. [Enter].
: , , , Visual Basic , , , .
25. , , , :
25.1. , , - ;
25.2. ;
25.3. , , , , ;
25.4. ³ .
26. (Table Datasheet) :
26.1. , ;
26.2. (Format) (Hide Columns).
: .
27. (Table Datasheet) :
27.1. (Format) (Unhide Columns);
27.2. ij (Unhide Columns), , . , , ;
27.3. (Close).
28. (Table Datasheet) :
28.1. , , , ;
28.2. (Format) (Freeze Columns).
: . .
.
29. (Format) (Unfreeze All Columns).
30. (Table Datasheet) (Design View) :
30.1. ;
30.2. , , .
30.1.3. , 볺;
30.1.4. (Design View).
31. (Design View) :
31.1. , ;
31.2. (Insert) (Rows).
: .
32. (Design View) :
32.1. , ;
32.2. (Edit) (Delete Rows);
32.3. , , .
33. (Design View) (Edit) (Undo Delete).
: , .
34. (Design View) :
34.1. , ;
34.2. , , ;
34.3. , ;
34.4. , , ;
34.5. ³ .
35. (Design View) 䳿:
35.1. , ;
35.2. ³ , ᒺ Microsoft Access;
35.3. [Enter] - .
: , (Design View).
36. , .
37. (Design View) (Table Datasheet) :
37.1. (View);
37.3.2. , , .
38. , .
39. .
40. ³ , 볺, (Table Datasheet).
41. Access , :
41.1. () (Records) (Data Entry);
41.2. (Records) (Remove Filter).
: .
43. (Insert) (New Record)
(NewRecord).
44. 5 .
45. :
45.1. (Find), :
45.1.1. (Edit) (Find).
45.1.2. 兔 (Find), :
45.2.1. (Find What) ᒺ ( ), , .
: , * ? . dz - , .
45.2.2. , , (Search) (All), .
, , :
Ø (Down) ;
Ø (Up) - .
45.2.3. , , (Match) (Whole Fields), .
, , :
Ø (Any Part of Field) , ᒺ , ;
Ø (Start of Field) , ᒺ .
45.2.4. (Search Only Current Field), .
;
45.2.5. (Match Case), .
, ᒺ , ;
45.2.6. (Search Fields As Formatted). ;
45.2.7. (Find First) . ᒺ Access .
45.2.8. (Find Next) ᒺ ;
45.2.9. ᒺ , 'Microsoft Access' . .;
45.2.10. Ok;
45.2.11. (Close).
46. :
46.1. (Find), :
46.1.1. (Edit) (Replase).
46.2. (Replase), :
46.2.1. (Find What) ᒺ, ;
46.2.2. (Replace With) , ;
46.2.3. , , (Search) (All), . , , :
Ø (Down) ;
Ø (Up) - .
46.2.4. (Find Next) . ᒺ, ;
46.2.5. (Replace), ;
46.2.6. (Find Next), ᒺ;
46.2.7. (Replace All) ᒺ;
46.2.8. ᒺ , 'Microsoft Access' . .;
46.2.9. Ok;
46.2.10. (Close).
47. :
47.1. ;
47.2. , ;
47.3. , ;
47.4. [Enter].
48. :
48.1. , , );
48.2. (Window) (Vertically);
48.3. (Tables) (New);
48.4. (New Table), , :
48.4.1. (Design View);
48.4.2. k.
48.5. .
48.6. (Window) (Vertically);
48.7. 㳿 ( ), .
48.8. .
48.9. (File) (Save);
48.10. (Save), :
48.10.1. (Name Table) , ;
48.10.2. k.
49. :
49.1. ³ .
49.2. (Insert Table) :
49.2.1. , ;
49.2.2. , ;
49.2.3. , , (Copy);
49.2.4. ;
49.2.5. , , (Paste).
49.3. (Insert Table), :
49.3.1. (Name Table) , ϳ;
49.3.2. , :
Ø ;
Ø ;
Ø . ,
- .
49.3.3. k.
50. :
50.1. , , ;
50.1.2. [Delete];
50.1.3. , , .
51. (Table Datasheet) :
51.1. - , ;
51.2. (Records) (Sort);
51.3. , , :
Ø (Sort Ascending);
Ø (Sort Descending).
52. (Table Datasheet) :
52.1. , ;
52.2. (Records) (Filter);
52.3. , , (Filter By Selection).
: , . Д (FLTR) , .
53. (Table Datasheet) (Records) (Apply Filter).
: , , Д (FLTR).
54. (AND filter) (Table Datasheet) :
54.1. (Records) (Filter) , , (Filter By Form)
(Filter By Form);
54.2. (Clear Grid);
54.3. , , ;
54.4. , , , ;
54.5. 䳿 , ;
: * ? , <; >; <=; >=; =; < >. ϳ <Enter>. .
, 10 :
- >10;
*.
54.6. (Filter) (Apply Filter)
(Apply Filter);
54.7. .
55. (OR filter) (Table Datasheet) (Records) (Filter) , , (Filter By Form)
(Filter By Form);
55.1. - , , , :
55.1.1. (Or), ;
55.1.2. , , ;
55.1.3. *; <Enter>.
55.2. .
55.3. .
56. - .
57. .
58. :
58.1. (Format) (Font);
58.2. (Font), , , .
59. :
59.1. (Format) (Cells);
59.2. (Cells Effects), :
59.2.1. (Cell Effect), , :
Ø (Flat) ;
Ø (Raised) , ;
Ø (Sunken) , ;
- , , .
: - (Flat) (Gridlines Shown) :
Ø (Horizontal);
Ø (Vertical),
.
59.2.2. , , (Gridline Color) ;
59.2.3. , , (Background Color) ;
59.2.4. Ok.
60. .
61. , , . , , 볺 . , : 볺 . , , . 볺 .
볺 , , , .
62. 볺. 볺 , , , . 3.3.
3.3
볺
| _ ( ) | |
| _ ( ) | |
| ( ) | |
| _ |
3.3
| _ | |
| _ | |
| _ / | |
| (4 ) |
: , , , . , , _ ( ). ' , SQL .
: , , . , 50- 20-. , 20- , 20- .
62.1. _ ;
: , , :
- ;
- ³ ;
- , .
.
62.2. 볺.
63. , , . 3.4.
3.4
| _ ( ) | |
| ( ) | |
| ʳ_ 2,4 | |
| _ , | |
| _ | |
| _ |
3.4
| _ | |
| _ / |
