Excel 2000 Module 7 Data Management A
database, also referred to as a list, is defined as a collection
of related information. It allows you to sort information, find
information that meets the criteria, and enven extract copies
of information from the large databases.
To
create a database, you will need to define te fields. A field
name is a name that identifies the data stored in a field.
When
a database gets larger, there may be a need to organize the information.
An information can be organized in either the ascending or descending
order. Primary
sort
means giving
1st level Priority in sorting, while Secondary
sort
means giving
next sorting preference. Menu, Point and click <Data> : Click Sort
The
AutoFilter creates the expression in the data form meant to select
a number of records from the large database, if it meets the
criteria specified. Rows of data that do not match the criteria
you specify are filtered out and hidden.
Select the Fields Menu, Point and click <Data>, <Filter> : Click AutoFilter
Filter
by the Selection from the List :
Filter
the list of REGION market from North
Click <File> <Save> Click <File> <Close>
Click <File> <Exit>
Edwin
Koh : We
completed on the New
Knowledge and Skills in
|
|
Next Modules |
---|
|
|
Previous Modules |
---|
|
|
Edwin Koh InfoTech Learning |
---|