Question

Attached above are what is needed for Chapter 9 Case problem 1 Kellys boutique (a-e) done on access 2016

b. Establish the appropriate relationship between each table. Print the relationships at c. Create and print i query that lists deramment, book title, author, supervisor. publisher, and contact Suve this query as Books by Iurant d. Create a form that was all files from the book table in a columnar fonnt with Save Book Form, and print the first record e. Create and print a report that contains the hook title. ISBN, publisher, and phone number. The report should have no srouping. be sorted by book title incending onder and he formatted in a tal portrait layout and the title Book Report. All field information should be visible. f. Make sure you keep a copy of this file for use in the next chapter. Chapter 9 Case Problem 2: WINE DEPOT The Wine Depot is interested in more effectively managing their inventory. Bar baru would like you to put together a base of their current wine inventory Create a new database file using the following information and name the file ch9-01_student_name (replacing studentame with your name. a. Use the following information to create and print a wine products ta- ble, a buyer tahle, and a winery table. Ise the field Name in the Buyer and Winery tables even when you are wamed against using a reserved name. Table Structure: Table Field Name Buyer Dele Typ Sheet Text Wine Products Number Short Text Type Currency Vintage Quantity Number Number Number Location Short Test Number Bus and stay con n et, wenn Chapter 227 Table Structure: Held Nam Date Type Book Short Teat Short Text Number Shox Test Det Table Supervisor PubNum Short Teat Short Text Short Teat Number Short Test Short Test Short Text Cart Phone Book Table ISAN Dupl Burak TEH Adult Children Children Children AGLI Tavlake MrCherokey 684872153 60244151 670125910 27136701 140236276 60173289 $35.95 1699 Michard $12.95 $24.00 Angola's Ashes Reisy-Tary Hueteries for Sa Caddie Woodlani Deep End of the Ocean Divine Secret of the Yaya Gislahad Green Lags and Ham Harry Potter and the Cumber of Secrets Harry Potter and the Prsoner ul Ackaban Harry Potter and the Sorcerer's Stone J900168 439064064 Children Chldren $ 799 5 17.95 Rowing 411150 9 wling $17.95 590353403 Children 9 Rowing 5 17.95 Dept Table Dupt Survi Rexford Merlot Rata Manchester Phone 5559754 55.5-1974 Publisher Table Pub Nun Publish Phone Contact Smith Poc Carouge Harper Collins Purgin Simon Schuster sing Pres Gone 355975 555.433 5556974 555-0874 555 1651 555.974 55 DARS 555-1112 555-5118 Ouimet Schalke Tu Banks Arthur A. Levine Books Robinson 6 Part 2 Access for Accounting Product ID Buyer ID 101 603 603 102 103 104 602 601 602 603 105 106 107 108 109 602 110 603 602 602 111 112 113 601 603 c. Establish a one-to-many relationship between the Buyers table and the Product table using Buyer ID as the related field. Print the rela- tionships report. Create and print a query for What SCP that lists the product name, buyer name, and buyer phone number for every product. (Note: Be sure to use both the product and buyer tables to locate field names.) Save the query as Product Buyer Query Chapter 9 Case Problem 1: KELLY'S BOUTIQUE Recall from Chapter 2 that Kelly's Boutique sells books as well as women's shoes. Kelly's son Casey. a college accounting student who is home for the hol- iduys, is eager to help his mom incorporate computers in her business. In this chapter and in those that follow). Casey will try teaching Kelly the use of Access as it applies to her accounting and business needs. Casey suggests that Kelly use a database to keep a record of her book inven- tory. Kelly has a partial list of books she has purchased that she thinks should he part of the database. This list includes each book's ISBN, department name, related supervisor and phone number of the supervisor, hook title, publisher, publisher contact, publisher phone number, author, and list price. Create a new database file using the following information and name the file ch9-03_studenl_name (replacing student_name with your name). 3. Use the information below to create a book table, department table, and publisher table in Access. Then print each table. Cop2017 Congelamin Al v ed arbeids ordicate in whole of WCN 2200 200 b. Establish the appropriate relationship between each table. Print the relationships at c. Create and print i query that lists deramment, book title, author, supervisor. publisher, and contact Suve this query as Books by Iurant d. Create a form that was all files from the book table in a columnar fonnt with Save Book Form, and print the first record e. Create and print a report that contains the hook title. ISBN, publisher, and phone number. The report should have no srouping. be sorted by book title incending onder and he formatted in a tal portrait layout and the title Book Report. All field information should be visible. f. Make sure you keep a copy of this file for use in the next chapter. Chapter 9 Case Problem 2: WINE DEPOT The Wine Depot is interested in more effectively managing their inventory. Bar baru would like you to put together a base of their current wine inventory Create a new database file using the following information and name the file ch9-01_student_name (replacing studentame with your name. a. Use the following information to create and print a wine products ta- ble, a buyer tahle, and a winery table. Ise the field Name in the Buyer and Winery tables even when you are wamed against using a reserved name. Table Structure: Table Field Name Buyer Dele Typ Sheet Text Wine Products Number Short Text Type Currency Vintage Quantity Number Number Number Location Short Test Number Bus and stay con n et, wenn Chapter 227 Table Structure: Held Nam Date Type Book Short Teat Short Text Number Shox Test Det Table Supervisor PubNum Short Teat Short Text Short Teat Number Short Test Short Test Short Text Cart Phone Book Table ISAN Dupl Burak TEH Adult Children Children Children AGLI Tavlake MrCherokey 684872153 60244151 670125910 27136701 140236276 60173289 $35.95 1699 Michard $12.95 $24.00 Angola's Ashes Reisy-Tary Hueteries for Sa Caddie Woodlani Deep End of the Ocean Divine Secret of the Yaya Gislahad Green Lags and Ham Harry Potter and the Cumber of Secrets Harry Potter and the Prsoner ul Ackaban Harry Potter and the Sorcerer's Stone J900168 439064064 Children Chldren $ 799 5 17.95 Rowing 411150 9 wling $17.95 590353403 Children 9 Rowing 5 17.95 Dept Table Dupt Survi Rexford Merlot Rata Manchester Phone 5559754 55.5-1974 Publisher Table Pub Nun Publish Phone Contact Smith Poc Carouge Harper Collins Purgin Simon Schuster sing Pres Gone 355975 555.433 5556974 555-0874 555 1651 555.974 55 DARS 555-1112 555-5118 Ouimet Schalke Tu Banks Arthur A. Levine Books Robinson 6 Part 2 Access for Accounting Product ID Buyer ID 101 603 603 102 103 104 602 601 602 603 105 106 107 108 109 602 110 603 602 602 111 112 113 601 603 c. Establish a one-to-many relationship between the Buyers table and the Product table using Buyer ID as the related field. Print the rela- tionships report. Create and print a query for What SCP that lists the product name, buyer name, and buyer phone number for every product. (Note: Be sure to use both the product and buyer tables to locate field names.) Save the query as Product Buyer Query Chapter 9 Case Problem 1: KELLY'S BOUTIQUE Recall from Chapter 2 that Kelly's Boutique sells books as well as women's shoes. Kelly's son Casey. a college accounting student who is home for the hol- iduys, is eager to help his mom incorporate computers in her business. In this chapter and in those that follow). Casey will try teaching Kelly the use of Access as it applies to her accounting and business needs. Casey suggests that Kelly use a database to keep a record of her book inven- tory. Kelly has a partial list of books she has purchased that she thinks should he part of the database. This list includes each book's ISBN, department name, related supervisor and phone number of the supervisor, hook title, publisher, publisher contact, publisher phone number, author, and list price. Create a new database file using the following information and name the file ch9-03_studenl_name (replacing student_name with your name). 3. Use the information below to create a book table, department table, and publisher table in Access. Then print each table. Cop2017 Congelamin Al v ed arbeids ordicate in whole of WCN 2200 200