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