Excel 2000 Module 7
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.
create a database, you will need to define te fields. A field
name is a name that identifies the data stored in a field.
a database gets larger, there may be a need to organize the information.
An information can be organized in either the ascending or descending
1st level Priority in sorting, while Secondary
next sorting preference.
Menu, Point and click <Data> : Click
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
by the Selection from the List :
the list of REGION market from North
Click <File> <Save>
Click <File> <Close>
Click <File> <Exit>
Koh : We
completed on the New
Knowledge and Skills in
|Edwin Koh InfoTech Learning|