Access Assignment

  

files uploaded one for the instructions and requirements and the other for data please follow the instructions step by step
access_assignment_3.docx

access_assignment_3___database.mdb

Unformatted Attachment Preview

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