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 Ex24 from www.pearsonhighered.com/kroenke. Open the spreadsheet and review the data in the Employee and Computer worksheets.

b. Create a new Access database with the name Ch05Ex24_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.

d. Import the Computer worksheet into a table named Computer. Check First Row Contains Column Headings, but let Access create the primary key.

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 actions mean.

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 Customer. Title your form Employee and your subform Computer.

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-3.

h. Use your form to add two new computers to Jane Ashley. Both computers are Dells, and both use Vista; one costs $750, and the second costs $1,400.

i. Delete the Lenovo computer for Rex Scott.

j. Use the Report Wizard (under Create) to create a report having all data from both the Employee and Computer tables. Play with the report design until you find a design you like.

Correct the label alignment if you need to.