Microsoft Office Tutorials and References
In Depth Information
(b)
Client
Financial
Information
(Excel
Workbook)
Recruiter
Number
Last Name
First Name
Street
City
State
Postal
Code
21
Kerry
Alyssa
261 Pointer
Tourin
CO
80416
(c)
Recruiter
Address
Information
(Word Table)
24
Reeves
Camden
3135 Brill
Denton
CO
80412
27
Fernandez
Jaime
265 Maxwell
Charleston
CO
80380
34
Lee
Jan
1827 Oak
Denton
CO
80413
(d)
Recruiter
Financial
Information
(Excel
Workbook)
Figure 1–2 (continued)
For clients, JSP needs to maintain address data. It currently keeps this address
data in a Word table (Figure 1–2a). It also maintains fi nancial data for each client. This
includes the amount paid and the current due from the client. It keeps these amounts
along with the client name and number in the Excel workbook shown in Figure 1–2b.
JSP keeps recruiter address data in a Word table as shown in Figure 1–2c. Just as
with clients, it keeps fi nancial data for recruiters, including their rate and commission, in a
separate Excel workbook, as shown in Figure 1–2d.
Finally, it keeps track of which clients are assigned to which recruiters. Currently,
for example, clients AC34 (Alys Clinic), FD89 (Ferb Dentistry), and PR11 (Peel
Radiology) are assigned to recruiter 21 (Alyssa Kerry). Clients BH72 (Berls Hospital),
BL12 (Benton Labs), FH22 (Family Health), MH56 (Maun Hospital), and WL56 (West
Labs) are assigned to recruiter 24 (Camden Reeves). Clients EA45 (ENT Assoc.) and
TC37 (Tarleton Clinic) are assigned to recruiter 27 (Jaime Fernandez). JSP has an
additional recruiter, Jan Lee, whose number has been assigned as 34, but who has not yet been
assigned any clients.
Search JabSto ::




Custom Search