You are required to complete the Access relational database, by providing the following database functionality:
a) A query of all orders that were cancelled by the customer, ordered by order date (customers can have more than one entry in the table). The query should show customer name, number of items ordered and order date.
b) A query showing all the instances of late payment, together with the number of days late (customers can have more than one entry in the table), ordered by days late. Your query should show customer name and number of days late.
c) A query of customers, ordered by the total number of items ordered (not the number of orders). Your query should show customer name and number of items ordered (only one entry for each customer).
d) A query, ordered by value (one entry for each customer), showing the total value (purchase price) of all orders placed by that customer. The query should show, for each customer, the total value of the goods ordered, and the customer name.
Hello,
I am very much interested to do this as i have strong knowledge in writing sql queries in ms access. I understand your requirements, just i need to see the database. Looking forward to have a positive response from you.
Thanks
i am a lead software engineer and responsible for creating web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
Contact me. I can help you.
I also have experience in working on a similar application.
I can get it done before deadline.
Let me know if you need any help?
Hello,
It would be my pleasure to help you in this task. Please contact me by chat and then we could discuss better your project.
Looking forward to hear from you soon!
Kind regards,
Luis Romero
Sounds like just fetching data from database using filters.
It can easily be done. Just need to be specific for queries.
I can do it easily.
I've vast experience in MS Access database. You can checkout my profile!