Homework 1 (15 points)
This introductory assignment is designed to give you a chance to become familiar with Microsoft Access and database tables.
Assignment
- Homework Tips
- Chapter 1 Guided Exercise (Pages 3-5)
- Chapter 2 Guided Exercise (Pages 12-15)
- Chapter 2 Applied Exercise (Pages 16-17)
Homework Submission Guidelines
- After the first week of class, you will receive an email from Professor Murray with the Microsoft Access textbook and the textbook data files.
- Complete the homework assignment using your personalized Access data files and then upload the completed files to UBLearns.
IMPORTANT NOTES ABOUT HOMEWORK SUBMISSIONS
- Make sure to close the Access database file before submitting to avoid the mistake of submitting a "locked" database file (.laccdb). The .laccdb file appears when the database is opened, and disappears when the database is closed. Submissions of locked files will receive a score of 0 unless the correct file (.accdb) has been uploaded prior to the due date/time.
- Assignment files may be submitted multiple times to UBLearns, but only the most recent, on-time file submissions will be graded.
- Submitting work or data files that are not your own is considered a violation of academic integrity. Students found in violation will be dealt with according to the procedures outlined in the official UB Academic Integrity Policy.
Assignment Deliverables
- Upload the completed StudentRoster.accdb and Employees.accdb database files to UBLearns prior to the due date and time. Late submissions automatically receive a score of 0.
- Upload the questions from page 18 in your textbook to UBLearns prior to the due date and time. No credit for Guided Exerises will be awarded if this is not submitted on time.
Hints
- Page 16 Step 5 - If you forget to uncheck the option for Hide Key Column, only the TitleName field will display in the dropdown and you can’t run the Lookup Wizard again without deleting the relationships between the two tables. Since we haven’t covered how to do that yet, here is a workaround to fix this problem. Open the Employees table in design view and go to the Lookup properties tab for the TitleCode field. Change the Column Widths property to 1”;1” and the List Width property to 2”. The Employees table should now show both the TitleCode and TitleName fields in the dropdown list for the TitleCode field.