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 %)