5. () MS Access MS Excel.
6. MS Access MS Excel.
7. MS Access .
: .
. Access.
1. .
2. Access.
3. .
4. .
5. Microsoft Excel.
6. : MS Excel Access .
: Access , . (Access ) .
, . , .
Excel , , .
7. .
7.1. Microsoft Access.
7.2. Microsoft Excel.
7.3. Excel , . 2.5, 5-10 .
2.5
Microsoft Excel
| A | B | C | D | E | F | G | |
| _ | |||||||
| 1500,00 | 12.01.2008 | ||||||
7.4. C:\ \ \, , , Personnel1;
7.5. Microsoft Excel.
7.6. Microsoft Access.
7.7. Excel , , Personnel1 .
7.7.1. (File) (Get External Data) , , (Import) ;
, , (Import);
|
|
|
7.7.2. (Import), :
7.7.2.1. (Files of type), , , Microsoft Excel (*.xls);
7.7.2.2. , Microsoft Excel , C:\ \ \;
7.7.2.3. , , Personnel1;
7.7.2.4. (Import).
7.8. ³ , (Import Spreadsheet Wizard) Excel- Access.
7.8.1. ᒺ.
7.8.1.1. , :
Ø ;
Ø .
, ;
7.8.1.2. , , 1 (Sheet1);
7.8.1.3. (Next).
7.8.2. .
7.8.2.1. , (First Row Contains Column Headings);
7.8.2.2. (Next).
7.8.3. .
7.8.3.1. : :
Ø (In a New Table);
Ø (In an Existing Table).
, (In a New Table);
7.8.3.2. (Next).
7.8.4. .
7.8.4.1. , , He () (Do not import field (Skip)) : , ;
: , .
, . 2.6.
2.6
| (Field Name) | (Index) | He () |
| ( ) | ||
| _ | ||
| _ |
7.8.4.2. (Next).
7.8.5. .
7.8.5.1. , :
Ø (Let Access add Primary Key);
Ø (Choose my own Primary Key);
Ø (No Primary Key).
, ;
|
|
|
7.8.5.2. (Next).
7.8.6. () .
7.8.6.1. ..
, Personnel1;
7.8.6.2. (Analyzer Wizard), ;
7.8.6.3. (Finish);
7.8.6.4. , , Ok;
7.8.6.5. Personnel1.
7.9. , .
7.10. .
8. .
9. : (Word, WordPad NotePad)) Access, , - ().
: (Delimited text files) - , , , .
.
.
10. () .
10.1. Microsoft Access;
10.2. Microsoft Word (WordPad NotePad);
10.3. :
, , , ,
125, , , 1500.00, 01.01. 2007
126, , . , 1250.00, 01.10.2007
5-10 .
10.4. C:\ \ \, , , Personnel2 , , (Files of type) (*.txt).
10.5. , , .
10.6. .
10.7. Microsoft Access.
10.8. Personnel2 .
10.8.1. (File) (Get External Data) (Import) , , , (Import);
10.8.2. (Import), :
10.8.2.1. (Files of type), , , (*.txt, *.csv, *.tab, *.asc);
10.8.2.2. , ;
10.8.2.3. , , Personnel2;
10.8.2.4. (Import).
10.9. ³ , (Import Text Wizard) Access.
10.9.1. .
10.9.1.1. , , :
Ø (Delimited);
Ø .
, , ;
|
|
|
10.9.1.2. (Next).
10.9.2. .
10.9.2.1. :
Ø Tab;
Ø ;
Ø ;
Ø ;
Ø .
, , ;
10.9.2.2. (First Row Contains Field Names);
10.9.2.3. (Next).
10.9.3. .
10.9.3.1. : :
Ø (In a New Table);
Ø (In an Existing Table).
, (In a New Table);
10.9.3.2. (Next).
10.9.4. .
10.9.4.1. , , He () (Do not import field (Skip)) : .
, . 2.7.
2.7
| He () | |||
| ( ) | |||
| / |
10.9.4.2. (Next).
10.9.5. .
10.9.5.1. , :
Ø (Let Access add Primary Key);
Ø (Choose my own Primary Key);
Ø (No Primary Key).
, ;
10.9.5.2. ;
10.9.5.3. , , - Ok;
10.9.5.4. (Next).
10.9.6. () .
10.9.6.1. , .
, , Personnel2;
10.9.6.2. (Finish);
10.9.6.3. , , Ok;
10.9.6.4. Personnel2;
10.10. , .
10.11. .
11. : MS Word Access, , - ().
12. г () , Personnel3.
|
|
|
: !
13. : (Word, WordPad NotePad) Access , - .
: (Fixed-length text files) - , , , ( ).
14. .
14.1. Microsoft Access.
14.2. Microsoft Word (WordPad NotePad).
14.3. :
125 1500.00 01.01.2007
126 . 1250.00 01.10.2007
5-10 .
14.4. C:\ \ \, , , Personnel4 , , (Files of type) ҳ (*.txt).
14.5. .
14.6. Microsoft Access.
14.7. Personnel4 :
14.7.1. (File) (Get External Data) (Import) ;
, , (Import).
14.7.2. (Import), :
14.7.2.1. , , (Files of type), , (*.txt, *.csv, *.tab, *.asc);
14.7.2.2. , ;
14.7.2.3. , , Personnel4;
14.7.2.4. (Import).
14.8. ³ , (Import Wizard) Access.
14.8.1. .
14.8.1.1. , , :
Ø (Delimited);
Ø .
, , ;
14.8.1.2. (Next).
14.8.2. .
14.8.2.1. ;
14.8.2.2. (Next).
14.8.3. .
14.8.3.1. : :
Ø (In a New Table);
Ø (In an Existing Table).
, (In a New Table);
14.8.3.2. (Next).
14.8.4. .
14.8.4.1. , , He () (Do not import field (Skip)) : .
, . 2.8.
2.8
| He () | |||
| ( ) | |||
| / |
14.8.4.2. (Next).
14.8.5. .
14.8.5.1. , :
|
|
|
Ø (Let Access add Primary Key);
Ø (Choose my own Primary Key);
Ø (No Primary Key).
, ;
14.8.5.2. ;
14.8.5.3. , , - Ok;
14.8.5.4. (Next).
14.8.6. () ' .
14.8.6.1. , .
, , Personnel4.
14.8.6.2. (Finish);
14.8.6.3. , , Ok;
14.8.6.4. Personnel4.
14.9. , .
14.10. .
15. .
: , Access , , . Access , , Access.
16. , , Excel Models.
17. .
17.1. Microsoft Access.
17.2. Excel Personnel1 , . 2.9.
2.9
| A | B | C | D | |
| _ | _ | _ | ||
| Corolla LiftbackXL | ||||
| Corolla LiftbackGT | ||||
| Corolla CompactGT | ||||
| Corolla CompactXL | ||||
| Corolla Kombi | ||||
| ? | ? | ? |
17.3. , C:\ \ \, , Models ( ).
17.4. Microsoft Excel.
17.5. Microsoft Access.
17.6. , Excel , , Models .
17.6.1. (File) (Get External Data) (Link Tables);
, , (Link Tables);
17.6.2. (Link), :
17.6.2.1. , , (Files of type), , Access, Microsoft Excel (*.xls);
17.6.2.2. , Microsoft Excel ;
17.6.2.3. , , Models;
17.6.2.4. (Link).
17.7. ³ , (Link Wizard) Excel- Access.
17.7.1. ᒺ.
17.7.1.1. , :
Ø ;
Ø .
