Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions