MIS 301/303 Access Assignment 3 Student Name: Questions based on the database provided. 1. Create a Query titled “Book Information” to show the following information (10 points): • Publisher’s name • Author’s name • Book title • Year published • Book condition Copy and Paste your Table Below: 2. Create a Query titled “Count of Book Conditions” to identify the total number of books for each condition type. This only needs two columns: Condition and Count (use an expression) (10 points) Copy and Paste your Table Below: 3. Create a Query titled “Book Count by Publisher” that counts the number of books from each publisher (publisher name and count of books only). Sort by Publisher Name. (10 points) Copy and Paste your Table Below: 4. Create a Query called “Book Depreciation” that identifies the percentage of depreciation for each book. Tip: Depreciation is the Book Price – Book Value. List only the book name and its amount of depreciation (in %). Sort by Title. (10 points) Copy and Paste your Table Below: 5. Create a Query called “Greatest Depreciation by Publisher” to solve the following problem: List the Publishers that have more than 25% of depreciation for all books in their collection. Only show the Publishers’ Names and Total % of Depreciation for each. Sort by Depreciation (greatest to least). (10 points) Copy and Paste your Table Below: 6. Modify the properties of the “FK Cond ID” attribute in the BOOK table to provide a drop-down menu of available condition names. Hint: Change the “FK Cond ID” properties to make it a list box using the CONDITION table as the source. (5 Points) 7. Create a Form called “Book Condition Form” to allow modification of Book Condition. Show the following information (10 Points): • Book Title • FK Cond ID - with a selectable list of options (created automatically if you answered #6 correctly) • Condition Explanation Capture a Screen Shot of your form and paste the image below: Tip: In Windows, use the Snipping Tool (this tool is part of Windows 8 and above). On a MAC, Press Shift-Command-4 and select the form. 8. Create a report (based on the Book Information Query from #1) called “Book Information Report” that shows all fields from the Query grouped by the Publisher and in a Block layout. Export the Report to a Word File. Upload the report with this assignment. (10 Points) Submit this answer sheet, the export of the report in #8, and your database file to Blackboard for grading.
Purchase answer to see full attachment