Microsoft Office Tutorials and References
In Depth Information
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 ﬁ 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 ﬁ 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.