, ;
17.7.1.2. , , 2.
17.7.1.3. (Next).
17.7.2. .
17.7.2.1. , (First Row Contains Column Headings);
17.7.2.2. (Next).
17.7.3. () ' .
17.7.3.1. 2 ..
, , , , Models;
17.7.3.2. (Finish).
17.7.4. , , Ok.
17.7.5. Models.
: , , Access.
17.8. .
: ³ , , , Access-, .
17.9. , .
17.10. Microsoft Excel , Excel.
17.11. Microsoft Excel F, , , Models.
17.12. , Excel .
18. Microsoft Access .
: Access- , , , Access.
19. MS Access Excel .
20. .
20.1. Microsoft Access.
20.2. ³ , , 볺.
20.3. , 볺.
20.4. (File) / (Save As/Export).
, 볺, , , / (Save As/Export).
|
|
|
20.5. (Save As), , :
Ø ( an External File or Database);
Ø (Within the Current Database as).
20.5.1. , ;
20.5.2. Ok.
20.6. : ⅔, :
20.6.1. , , (Files of type), , Microsoft Excel (*.xls);
20.6.2. , ;
20.6.3. (File Name) , 볺. , , , , Personnel;
20.6.4. (Export).
: Access Excel- Access- Excel.
20.7. Microsoft Excel .
20.8. Microsoft Excel.
21. : , MS Access , Personnel1, .
: Access, , .
22. .
23. .
24. Microsoft Access.
25. .
:
[ 1 ], [ 2 ], [ 3 ], [ 11 ], [ 12 ].
5
13. Microsoft Office. Access
: Access .
1. .
2. .
3. .
4. .
: .
. Access.
5. , .2.10.
2.10
| .. | , | |
| : , , , , . | ||
| : , . | ||
| : , , , , . | ||
| : , , ( ). | ||
6. , . 6.
|
|
|
. 6:
7. . , , , .. 2.11-2.15.
2.11
| 1/256 | 05.01.07 | + | |
| 2/134 | 06.01.07 | + | |
| 06.01.07 | - | ||
| 07.01.07 | - | ||
| 5/5 | 15.01.07 | + | |
| 16.01.07 | - |
2.12
| " " | |||
| .. | |||
| " " | |||
| .. | |||
| .. | |||
| "" |
2.13
| 1/256 | 5200,00 | ||
| 1/256 | . | 900,00 | |
| 1/256 | 3900,00 | ||
| 1/256 | . | 2800,00 | |
| 2/134 | . | 900,00 | |
| 2/134 | . | 2500,00 | |
| . | 1100,00 | ||
| 6000,00 | |||
| 4900,00 | |||
| . | 1200,00 | ||
| 5/5 | 4000,00 | ||
| 5800,00 |
2.14
| 4500,00 | ||
| . | 1000,00 | |
| . | 3000,00 | |
| 5500,00 |
2.15
: . .
8. , . 8. .
9. , .. 2.11-2.15.
:
. 6-10.
:
[ 1 ], [ 2 ], [ 3 ], [ 11 ], [ 12 ].
:
[ 1 ], [ 2 ], [ 3 ], [ 11 ], [ 12 ].
14. SQL
: , SQL.
14. SQL. SQL-.
15. SELECT, UPDATE, INSERT, DELETE.
16. From, Where, In, Group by, Having, Order by.
17. All, Distinct Distinctrow.
18. Inner join.
19. SQL-.
20. Count, First/Last, Min/Max, Avg, StDev/StDevP, Sum, Var/VarP.
14 , , : , , . , , , , .
SQL, SQL, .
|
|
|
SQL (Structured Query Language) , : , , .
.
, (), . ֳ , .
, , .
SELECT ,
UPDATE .
DELETE .
INSERT .
, Access SQL. SQL. , SQL, .
. SQL, . . , ᒺ.
SELECT :
SELECT [] ( ) [INTO [IN ]]
FROM [,...] [IN ]
[ORDER BY [ASC | DESC]
[WHERE ³ ]
[GROUP BY ]
[HAVING ]
UPDATE , . :
UPDATE
SET _
WHERE _;
UPDATE , , . UPDATE .2.16.
2.16
UPDATE
| , , . | |
| _ | , . |
| _ | , . |
UPDATE :
ü UPDATE . ³ , , . , , , .
ü ﳿ . , .
:
UPDATE
SET = * 1.1,
= * 1.03
WHERE = '';
: " 10 , 3 .
1. SQL?
2. ?
3. ?
4. SELECT?
|
|
|
5. UPDATE?
6. DELETE?
7. INSERT?
6
14. SQL
: SQL .
1. SELECT.
2. SELECT.
3. ( 1,2,3).
4. ( 4).
5. ( 5).
6. ( 6).
: .
. Access.
1. .
2. Access.
3. , :C:\ \ \ \ ( ).
4. SELECT.
I. ̳ SELECT.
̳ SELECT SELECT :
SELECT FROM
SELECT - SELECT, , . . , ( ). , , *.
FROM , , .
, .
, .
5. 1: ( ) .
6. , .
6.1. ³ , : <> (New)_(Design View)_ Ok;
6.2. <> (Close) (Show Table) ( );
6.3. SQL: (View) _ SQL;
6.4. SQL SQL:
