Access Assigment

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