Microsoft Office Tutorials and References
In Depth Information
Project — Database Creation
JSP Recruiters is a recruiting ﬁ rm that specializes in job placement for health care
professionals. Because the recruiters at JSP have previous experience in the health care
industry, the ﬁ rm is able to provide quality candidates for employment in hospitals, clinics,
medical laboratories, doctors’ ofﬁ ces, and other health care facilities.
JSP Recruiters works with clients in need of health care professionals. It assigns
each client to a speciﬁ c recruiter. The recruiter works with the client to determine the
necessary qualiﬁ cations for each job candidate. The recruiter then contacts and does a
preliminary review of the qualiﬁ cations for each candidate before setting up a job
interview between the client and the candidate. If the candidate is hired, the client pays a
percentage of the new employee’s annual salary to the recruiting ﬁ rm, which then distributes
a percentage of that client fee to the recruiter.
To ensure that operations run smoothly, JSP Recruiters organizes data on its clients
and recruiters in a database, managed by Access. In this way, JSP keeps its data current
and accurate while the ﬁ rm’s management can analyze the data for trends and produce a
variety of useful reports.
In Access, a database consists of a collection of tables, each of which contains
information on a speciﬁ c subject. Figure 1–1 shows the database for JSP Recruiters. It consists
of two tables. The Client table (Figure 1–1a) contains information about the clients to
whom JSP provides services. The Recruiter table (Figure 1–1b) contains information
about the recruiters to whom these clients are assigned.
(a) Client Table
(b) Recruiter Table