. , . . (list) (database), .
㳿 Microsoft (list) , .
(fields), (records). (256 ´ 65 535 + 1 ).
, :
.
Գ , .
.
.
, .
.
:
.
* .
* , . , , , , , .
* , Excel .
* . . .
* , ³ ð (Window ð Freeze Panes).
* , ().
:
* , .
* .
* .
Excel:
(Auto Complete). , Excel , < Enter >. / , (Edit) (Options).
(Pick Lists). , (Pick from list). , , .
|
|
- ð (Data ð Form). Excel , ( 32 ), , . < Tab > < Shift+Tab >. . :
(New) , ;
(Delete) ;
(Restore) . ij ;
(Find Prev) . , , ;
볓 (Find Next) . , , ;
(Criteria) . ϳ 볓 , ;
(Close) .
Microsoft Access Access Links, Excel. ð MS Access (Data ð Access Form), , .
Excel :
, , ;
;
, ;
, Excel.
, , . , (query) , , .
, Microsoft Query. , ð ð (Data ð Get External Data ð Creat New Query). :
.
ð ð . MS Query.
, MS Query (Query Wizard) ( Excel 97).
, , .
, , .
|
|
.
Գ
Գ , , . Excel :
(AutoFilter) .
(Advanced Filter) .
, ð Գ ð (Data ð Filter ð AutoFilter). Excel , . , . , , , Excel , , . , . , , . , , . : , , 999 Excel 97 250 Excel.
, , , :
(All) . .
10 (Top 10) 10 .
(Custom) , .
(Blanks) , .
(NonBlanks) , .
ð Գ ð . .
Գ 䳺 , .
. .
. , , . :
.
.
ﳿ , , .
. ij (criteria range) , , :
* , , , ;
* .
- , .
( ) 璺 (AND). 璺 (OR).
, - Þ Գ Þ (Data Þ Filter Þ Advanced). , , , , ʔ. .
|
|
:
* . : = ( equal to), > ( greater than), >= ( greater than or equal to), < ( less than), <= ( less than or equal to), <> ( not equal to). :
ij | ij | ||
> | , | * | , |
<> | , , | * | , - |
=ѳ | ѳ | ? | , |
.
* , . , . . : 2 =5 - 5 + 1 >= 30. , ( ) , .
- , :
, , .
- , , , , .
, .
, , , .
. :
(Copy to Another Location) - , (Copy to).
ҳ (Unique Record Only) (), . , .
, , ᒺ .
(pivot table) , . .
, , , .
. ( ) , (. 3).
. 3. .
(pivot table) Microsoft. , :
(page field) , . . 3 , . , .
|
|
(data field) , (, , , , ). . 3 , . - , .
(row field) , . . . 3 . . .
(Column Field) , . .
(Item) , .
(Data Area) , . Excel (, , .)
(Grand Totals) , . , , , .
(Group) , . ᒺ .
(Source Data) , . .
(Subtotals) , .
(Refresh) .