1
MICROSOFT ACCESS PROJECT
Background Information: The Board of Directors has accepted your recommendations for the new
desktop and laptop computers to install, and you have been given the authorization to proceed. To
keep track of the installations you have performed, you will use an Access database. The database will
keep track of each employee, and identify the computer that is assigned to them. Your company has
2,000 employees, but for this assignment you only will create a database to track the employees in the
Human Resources department.
Requirements:
Create a new, blank database and save it as AccessProject-LastName-FirstName.accdb (where
LastName-FirstName should be replaced with your last and first name). Pay attention to the
location where you are saving the file so that you can locate it later.
Switch to Design View so that you can begin adding fields to a table. When you are prompted to
save the table, use HR_COMPUTERS as the table name.
Delete the default ID field from the table.
Add the following fields to the table. Information about what each field will store is listed in
italics, and should not be part of the field name:
o Employee ID (A random letter, followed by a 6-digit number uniquely identifying each
employee)
o First Name (Employee’s first name)
o Last Name (Employee’s last name)
o Office Location (Employee’s office location – identified by a 3- or 4-digit room number)
o Phone (Employee’s office telephone number)
o Email Address (Employee’s business e-mail address)
o Computer Type (Type of computer – either desktop or laptop)
o Computer Serial Number (11-character alphanumeric unique serial number found on
computer)
Set an appropriate data type for each field.
Add an appropriate description for each field.
Set the Employee ID field as the primary key.
Set appropriate field sizes for each field. For example, the Office Location field might have a field
size of 3 or 4, because office locations are identified by a 3- or 4-digit room number.
Use the information above to help determine the correct field sizes. For fields such as First
Name, Last Name, and Email address, you should decide on an appropriate field size that is not
too large, but will adequately store your employees’ information.
Make the necessary changes so that each field is required, and does not allow any zero length
strings (if appropriate).
2
Switch to Datasheet view and add fictitious records for 10 employees.
Create a form for the HR_COMPUTERS table that shows all fields (hint: use the Form button on
the CREATE tab).
Switch to Form View and add 5 more fictitious records to the table (so you will have a total of 15
records).
After entering the additional records, close the form and save the form as
HR_COMPUTERS _FORM
Create a report that displays a listing of all fields and records in the HR_COMPUTERS table. Save
the report as HR_COMPUTERS_REPORT
Create a query that displays the first name, last name, office location, and phone number and
computer type.
o Do not show the computer type, and set the criteria as “Desktop” to display only
employees with a desktop computer (hint: open the design view). Save the query as
HR_DESKTOP
Create a second query that displays the first name, last name, office location, e-mail address and
computer type.
3
o Do not show the computer type, and set the criteria as “Laptop” to display only
employees with a laptop computer (hint: open the design view). Save the query as
HR_LAPTOP
In the Properties for this database, make sure your full name appears in the Author property (if
it does not, change it).
Submission Guidelines
It is important for students to pay close attention to the submission guidelines in order to
receive full credit for this assignment.
Save the file as AccessProject-LastName-FirstName.accdb (where LastName-FirstName should
be replaced with your last and first name)
Close the file after saving it. Otherwise the file will not attach properly to the email message.
Submit the file to Blackboard.
Important Notes
Start the assignment well in advance of the due date. Last minute problems on your end will not
be an excuse for missing a deadline
Do not use anyone else’s work. After we receive all assignments, we will run them through an
automated process to check for plagiarism. Any violations or any plagiarism will result in a zero
on this assignment and possible further disciplinary action by the College. It is better to miss
turning in an assignment (or to turn in an incomplete assignment) and receive a lower grade
than to risk going through a Student Conduct review process
Using a Mac version of Microsoft Office is entirely at your own risk. If the Mac version does not
allow you to perform certain steps outlined in this document, you will lose points for those steps
Please e-mail your instructors with any questions
4
Rubric
Criteria Available Points
Table Named HR_COMPUTERS 8
Contains all 8 fieldnames 16
Have a total of 15 records 15
Query HR_DESKTOP: First name, last name, office #, phone (criteria comp type) 12
Query HR_LAPTOP: First/ last name, office #, e-mail address (criteria comp type) 12
Create a form called HR_COMPUTERS_FORM 12
Create a report called HR_COMPUTERS_REPORT 12
Employee Id is the primary key 8
Saving the document with the correct filename 5
Assignment not covering the instructed topic -100
Total Points 100