(MICROSOFT ACCESS PROJECT)

(MICROSOFT ACCESS PROJECT)

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

Is this the question you were looking for? If so, place your order here to get started!