Chapter 2. System Training
Field
A field is one item of information for a record. For example, the records in the
Customer Master File include customer name, address, phone number, tax type,
price level, and so forth. Each one is considered a field.
9
9
9
X
Y
Z
C
O
M
P
A
N
Y
1
4
0
0
W
e
s
t
M
o
u
n
ta
i
n
R
d
.
A
n
y
t
o
w
n
,
U
S
A
9
9
9
9
9
(
1
2
3
)
4
5
6
-
7
8
9
0
T
A
X
T
Y
P
E
:
1
-
-
-
-
-
-
-
-
-
-
P
R
I
C
E
L
V
L
:
2
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Certain fields are also identified as keys.
Key
A key is a special field (or fields) in a record used to organize the record for more
efficient retrieval. For example, the Customer Master File keys are the customer
number and customer name. The customer number and name must be unique to
each customer so it is used as the key to the record.
The Customer Master File can be
sorted by customer number or name.
Customer reports can be printed in
either customer number or name
order. Also you can enter the
customer number or name to have t
computer display further infor
about that customer.
9
9
9
X
Y
Z
C
O
M
P
A
N
Y
1
4
0
0
W
e
s
t
M
o
u
n
ta
i
n
R
d
.
A
n
y
t
o
w
n
,
U
S
A
9
9
9
9
9
(
1
2
3
)
4
5
6
-
7
8
9
0
T
A
X
T
Y
P
E
:
1
-
-
-
-
-
-
-
-
-
-
P
R
I
C
E
L
V
L
:
2
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
he
mation
Dimensions 14 39
To Next Page
Loading...