Question: - Prepare a userform where the input fields are o Book Name ( text ) o Book Author ( text ) o ISBN No (

- Prepare a userform where the input fields are
o Book Name (text)
o Book Author (text)
o ISBN No (unique number)
o Selling Price (Currency between $5.00 and $100.00)
o Last Months Sales Quantity (integer between 100 and 1500)
- In the form there should be Save Data, Close Form buttons. Each record should be added to a new line.
- Prepare a second form (reachable from the first form) where
o there are summarizing fields where you calculate the total monthly revenue / total quantity sold / best selling books title / revenue % of best selling book to total sales
o You can display the details of a book when you enter the ISBN no (so there will be a field where you enter ISBN no. and when you click it, it should display all the details about that book)
- Fill with at least 10 book data (you can randomly give numbers and names...) PLS WRITE A VBA CODE. other cods in chegg does not work. so please be careful thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!