MIS 3003 Homework 5.docx - MIS 3003 Chapter 5 Homework 5-3 In this exercise you will create a two-table database define relationships create a form and

MIS 3003 Homework 5.docx - MIS 3003 Chapter 5 Homework 5-3...

This preview shows page 1 - 2 out of 2 pages.

MIS 3003 Chapter 5 Homework 5-3. In this exercise, you will create a two-table database, define relationships, create a form and a report, and use them to enter data and view results. a. Download the Excel file Ch05Ex03_U7e.xlsx . Open the spreadsheet and review the data in the Employee and Computer worksheets. b. Create a new Access database with the name Ch05Ex03_Solution . Close the table that Access automatically creates and delete it. c. Import the data from the Excel spreadsheet into your database. Import the Employee worksheet into a table named Employee. Be sure to check First Row Contains Column Headings . Select Choose my own primary key and use the ID field as that key. (1pt.) d. Import the Computer worksheet into a table named Computer . Check First Row Contains Column Headings , but let Access create the primary key. (1pt.) e. Open the relationships window and add both Employee and Computer to the design space. Drag ID from Employee and drop it on EmployeeID in Computer . Check Enforce Referential Integrity and the two checkmarks below. Ensure you know what these
Image of page 1

Subscribe to view the full document.

Image of page 2

Unformatted text preview: actions mean. (3pt.) f. Open the Form Wizard dialog box (under Create, More Forms ) and add all of the columns for each of your tables to your form. Select View your data by Employee. Title our form Employee and your subform Computer . (1pt.) g. Open the Computer subform and delete EmployeeID and ComputerID . These values are maintained by Access, and it is just a distraction to keep them. Your form should appear like the one shown in Figure AE-5. (1pt.) Figure AE-5 h. Use your form to add two new computers to Andrea Ashley . Both computers are Dells, and both use Vista; one costs $ 750, and the other costs $ 1,400. (1pt.) i. Delete the Lenovo computer for Stan Calbro. (1pt.) j. Use the Report Wizard (under Create) to create a report having all data from both the Employee and Computer tables. Adjust the report design until your find a design you like. Correct the label alignment if you need to. (1pt.)...
View Full Document

  • Summer '17

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes