INFO 321 Paden Case Study APU | Page 2

defined and depicted for full payment by the proprietor. Do not forget Primary keys assignment. ​( 25 %)
5) Finally, create an ​MS Access prototype( actual database) ​, including the data provided, with the newly designed tables. Upload the prototype to the assignment area as part of the deliverables ​( 5 %).
6) Create a ​Query​( In MS Access) that may include one or more tables, as needed, that provides the answer to the following request:
List the Invoice number, Customer Name, and Parts Description for purchases by Customers that have an Account Balance of $ 3,000 or higher. Short them with the highest balance being displayed first( Descending values) ​( 5 %)
7) Create one ​Form​: New Customer Input- this form should include any relevant fields that you think " Home Solutions Inc " might need( In MS Access) ​( 5 %)
8) Create One ​Report​: Items Price List- this report should include any relevant fields that you think " Home Solutions Inc " might need( In MS Access) ​( 5 %)