MIS303 Access Assignment II 40 Pts Fall 2022

Mis303 Access Assignment Ii 40 Pts Fall 2022in This Assignment S

This assignment requires students to use the ABCPublish-II database provided on Blackboard to create specific queries in Microsoft Access that answer designated business questions. Students must work individually, without collaboration or external assistance, and produce final, saved query files for submission. The assignment involves downloading and saving the database with a specified naming convention, enabling contents, and creating various query types such as select, update, and crosstab queries to extract information related to textbooks, authors, profits, and compensation calculations. Specific instructions include adding new fields to tables, calculating expected profits and compensations, and organizing data summaries. All queries should be named according to the provided labels and must directly address each question's requirements. Completed queries are to be saved, and the database file uploaded to Blackboard for assessment.

Paper For Above instruction

The use of databases in business operations is fundamental for managing large volumes of information efficiently. In academic settings, particularly in courses such as MIS303, students learn to develop and manipulate databases to extract meaningful insights that support business decision-making. This assignment centers on practical skills in designing and executing queries within Microsoft Access, focusing on a hypothetical publishing company's data concerning textbooks, authors, and sales metrics. Through this exercise, students demonstrate their capacity to handle real-world data tasks, including data retrieval, updates, calculations, and summaries, aligning with business analytical practices.

The first task involves extracting all textbooks authored by Baltzan, identified by their last name. Students must compose a select query that filters textbooks where the author’s last name is Baltzan, displaying key details such as book title, ISBN, edition, and publication year. Precise naming conventions for the query, "1 Baltzans Books," ensure organized retrieval. This step tests skills in simple data filtering and field selection.

Next, students are tasked with identifying the first authors of each textbook to facilitate reprint discussions. This involves querying the "AuthorshipLog" table, where authorship order is recorded numerically. The query must extract the book title, and the last name, email, and phone number of the first author (authored with Auth_Order=1). Named "2 First Author Contacts," this step emphasizes understanding of relationship joins and filtering based on specific criteria.

The third query expands on the previous by focusing on authors contributing to textbooks whose titles start with "Business Driven." The objective is to retrieve the book titles, author last names, and emails for all authors involved in these specific texts. Named "3 Business Driven Books," this queries skills in pattern matching on text fields and multiple table joins to link books and authors accurately.

Furthermore, the assignment requires modifying tables by adding new fields. In the "Textbooks" table, an "Expected_Profit" currency field with two decimal places must be added. Then, a query calculates this profit as the product of the print quantity and the difference between list price and unit cost, saving the results as "4 Expected Profits."

Building upon this, students will create a summary query that calculates total expected profits grouped by subject areas, labeled "5 Subject Profits." This involves aggregating data across the "Textbooks" table, showcasing proficiency in grouping and summing data.

The sixth task mirrors the earlier modification by adding an "Expected_Compensation" field to the "AuthorshipLog" table, also as a currency with two decimal places. Subsequently, a query computes expected compensation for each authorship record based on the product of a compensation percentage and the expected profit, inserting the results into the new field. Named "6 Expected Compensations," this demonstrates the ability to perform calculations, field updates, and integrate data across tables.

Finally, the seventh query synthesizes compensation data by listing total expected compensations for each author across textbooks. The query's layout presents author last names as columns and textbook titles as rows, effectively summarizing individual author earnings per book, and is saved under "7 Compensations by Authors and Books."

Throughout the assignment, students are expected to carefully create, save, and organize multiple queries, ensuring they directly answer the specified business questions. Attention to detail in naming, accurate calculations, and correct use of query types are essential for successful completion. After finalizing all queries, students should ensure they are saved correctly, close the database, and upload the file to Blackboard. The exercise not only reinforces technical skills in database management but also develops analytical competencies integral to business data analysis.

References

• Harrington, J. L. (2016). Relational Database Design and Implementation. Morgan Kaufmann Publishers.
• Sanchez, R. (2019). Data-Driven Decision Making in Business. Routledge.