The first one is the same Microsoft Access database you were given in Assignment 5, last week. The second one is an Excel file that that contains information about a new batch of books that was recently purchased by the bookstore that handles the first database. It also contains a client list from the old bookstore that was also acquired by the new bookstore. Your job is to integrate the information provided in the Excel file onto the current database file. To do that you must do the following:

1. All new books in the Excel file should be added to the Book table. If there are books that were already in the table, only the quantity should be updated. All purchased books are new.
2. Categories for the new books in the Excel file should match existing categories in the current database. Only Accounting, Criminal Justice, Computers, and Finance should be added as new categories that were not previously found in the database.
3. Book prices in Euros in the Excel file should be converted to prices in USD in the current database. The exchange rate on the purchase date was $1.00 USD per 0.8484EUR.
4. Author names in the Excel file should be incorporated in the Author table and appropriate references should be included in the Wrote file.
5. Customers from the Excel file who have all required information by the new database should be incorporated in the Customer table. New customers who were added in the current database and of whom there are purchase records should also be referenced in the Order and OrderLine files. Since no order numbers exist in the Excel File, new order numbers will be created that begin their Order number with the letter Z: Z001, Z002 etc. OrderDate and OrderDeliveryDate should be 12/31/2016 for all added OrderLine records.

5 Purchased Books - Excel For Assignment 7 - Excel File Home Insert Page Layout Formulas Data Review View Add-ins Tell me what you want to do... - L- A Store II O + PivotTable Recommended Table Pictures Online Shapes SmartArt Screenshot PivotTables Pictures Tables Illustrations My Add-ins - Recommended Charts PivotChart Slicer Timeline Hyperlink 3D Tours Line Column Win/ Loss Sparklines Text . Box & Fc Add-ins Charts Filters Links B2 f Criminal law B D F H | J K L 1 ISBN Authors A Title 1 Criminal law 2 E Type Criminal Justice 2 39089 Thomas J. Gardner & Terry M. Anderson 3 Financial Markets and Institutions 213683 Frederick S. Mishkin & Stanley G. Eakins Finance 3 4 Pablo Picasso 1252 Warncke, Carsten Painting 4 G Title 2 Criminal law 3 Financial Markets and Institutio ns 4 Pablo 4 Picasso 5 Discrete Mathema tics 6 Ethical Obligatio ns and Decision Making in Accounti ng Title John Dossey, Albert Otto, Lawrence Spence, Charles Vanden Eynden 5 30515 Math Discrete Mathematics 5 6 7 Ethical Obligations and Decision Making in Accounting 802528 Title ISBN Steven M. Mintz and Roselyn E. Morris Authors Accounting Type H e Copy ABC Q FER + Table Tools Database for Assignment 7: Database File Home Create External Data Database Tools Fields Table Tell me what you want to do... % Cut 21 Ascending Selection New Totals abc Rep! Al Descending Advanced Save Spelling Gol View Paste Filter Refresh Find Format Painter 2. Remove Sort Toggle Filter All- X Delete More A Sele Views Clipboard Sort & Filter Records Find E Query1 Query2 Query3 EE! Author All Access Obje... Authorld - FirstName Initials LastName - Click to Add Search... 10100 Susan J Colley Tables 10101 Jeffrey Hoffer Author 10102 Venkataraman Ramesh Book 10103 Heikki Topi Customer 10104 Russell JT Dyer Inventory 10105 Murray R Spiegel Order 10106 Seymour Lipschutz 10107 John J Schiller Orderline 10108 Joseph G Monks VIP Clients 10109 Richard Bronson Wrote 10110 Dominick Salvatore 10111 George E Mase 10112 Richard Bronson 10113 Minor Hawk 10114 Frank Ayres Jr. 10115 Fred S Kleiner 10116 Christin J Mamiya 10117 Richard G Tansey 10118 Carsten Warncke 10119 David A Lauer 10120 Stephen Pentak 10121 Robert Gordon 10122 Andrew Forge 10123 Philip J Pratt 10124 Joseph J Adamski 10125 Damon Climacri Record: 1 of 30 No Filter Search Datasheet View + + + + + + + 5 Purchased Books - Excel For Assignment 7 - Excel File Home Insert Page Layout Formulas Data Review View Add-ins Tell me what you want to do... - L- A Store II O + PivotTable Recommended Table Pictures Online Shapes SmartArt Screenshot PivotTables Pictures Tables Illustrations My Add-ins - Recommended Charts PivotChart Slicer Timeline Hyperlink 3D Tours Line Column Win/ Loss Sparklines Text . Box & Fc Add-ins Charts Filters Links B2 f Criminal law B D F H | J K L 1 ISBN Authors A Title 1 Criminal law 2 E Type Criminal Justice 2 39089 Thomas J. Gardner & Terry M. Anderson 3 Financial Markets and Institutions 213683 Frederick S. Mishkin & Stanley G. Eakins Finance 3 4 Pablo Picasso 1252 Warncke, Carsten Painting 4 G Title 2 Criminal law 3 Financial Markets and Institutio ns 4 Pablo 4 Picasso 5 Discrete Mathema tics 6 Ethical Obligatio ns and Decision Making in Accounti ng Title John Dossey, Albert Otto, Lawrence Spence, Charles Vanden Eynden 5 30515 Math Discrete Mathematics 5 6 7 Ethical Obligations and Decision Making in Accounting 802528 Title ISBN Steven M. Mintz and Roselyn E. Morris Authors Accounting Type H e Copy ABC Q FER + Table Tools Database for Assignment 7: Database File Home Create External Data Database Tools Fields Table Tell me what you want to do... % Cut 21 Ascending Selection New Totals abc Rep! Al Descending Advanced Save Spelling Gol View Paste Filter Refresh Find Format Painter 2. Remove Sort Toggle Filter All- X Delete More A Sele Views Clipboard Sort & Filter Records Find E Query1 Query2 Query3 EE! Author All Access Obje... Authorld - FirstName Initials LastName - Click to Add Search... 10100 Susan J Colley Tables 10101 Jeffrey Hoffer Author 10102 Venkataraman Ramesh Book 10103 Heikki Topi Customer 10104 Russell JT Dyer Inventory 10105 Murray R Spiegel Order 10106 Seymour Lipschutz 10107 John J Schiller Orderline 10108 Joseph G Monks VIP Clients 10109 Richard Bronson Wrote 10110 Dominick Salvatore 10111 George E Mase 10112 Richard Bronson 10113 Minor Hawk 10114 Frank Ayres Jr. 10115 Fred S Kleiner 10116 Christin J Mamiya 10117 Richard G Tansey 10118 Carsten Warncke 10119 David A Lauer 10120 Stephen Pentak 10121 Robert Gordon 10122 Andrew Forge 10123 Philip J Pratt 10124 Joseph J Adamski 10125 Damon Climacri Record: 1 of 30 No Filter Search Datasheet View + + + + + + +