MIS homework
MIS 3003 Chapter 5
Homework Instructions
Be careful! All instructions here are not for your homework questions, but just some very similar questions!!!
Question
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.
Download the Excel file Ch05Ex03_U7e.xlsx. Open the spreadsheet and review the data in the Employee and Computer worksheets.
Question.
Create a new Access database with the name Ch05Ex03_Solution. Close the table that Access automatically creates and delete it.
Instructions
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.
Remember to open the table to check if you need to clean the data.
Instructions
Import the Computer worksheet into a table named Computer. Check First Row Contains Column Headings, but let Access create the primary key.
Remember to open the table to check if you need to clean the data.
Instructions
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 actions mean.
Hints: Make sure you close two tables first, otherwise you may not be able to create the relationship.
Hints: Check the Data Type of EmployeeID in Computer table and the ID in Employee Table, make sure these two fields have the same Data Type (Both Integer/Double)
Hints: If you need to check the Data Type for each field, you need to right click the table, and choose Design View.
Instructions
You will find the EmployeeID is double (decimal numbers), which is not Integer, change it to Integer to match the Data Type of ID field in Employee Table.
If you change Data Type from Double to Integer, it will show you a warning window, just click OK to ignore it.
If EmployeeID in Computer table and ID in Employee table have the same data type, you may not need to change them, if you change one of them, make sure both in the same type.
Instructions
Close two open tables.
Go to Database Tools -> Relationships.
Add Computer table and Employee table in Show Table dialog. (Double Click or click Add button) Then click Close button.
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 actions mean.
Instructions
Now you can close the Relationship tab and open Employee table to check the relationship created just now.
If Access ask you to save the relationship, click save.
You will find you have create a ONE to MANY relationship.
Instructions
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.
Instructions
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.
Instructions
Delete the Lenovo computer for Stan Calbro.
Instructions
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.
Upload to d2l
I will need you to upload only the access database to dropbox.