Access Assigment

Anonymous
timer Asked: Apr 27th, 2017

Question description

2 files uploaded one for the instructions and other for data please follow instructions step by step.

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.

Tutor Answer

(Top Tutor) Studypool Tutor
School: Rice University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors