You must import data into the provided Access Database, run a provided query, export the query results to Excel, and then perform the requested analysis/graphing in Excel. Two starting files are provided: 1. HW4.Customer. Sales – starting Access DB. 2. HW4.product. import – Excel file containing information to be imported into Access. The database is being used to track customers, orders, and products. The database has 4 tables – Customer, Product, Order, and Orderline. A customer can have multiple orders, but an order can only have one customer. An order can have multiple order lines, but only one customer. An orderline has only one product and belongs to one order, but a product can be on multiple orderliness. The relationships are already established in the starting database (HW4.Customer. Sales)

For a typical middle-income family, what is the estimated cost of raising a child to the age of 18? $145,500 $245,340 $304,340 $455,500

If you embed a word table into powerpoint, what happens when you make edits to the embedded data? a. edits made to embedded data change the data in the source file; however, edits made to the source file will not be reflected in the embedded data. b. edits made to embedded data will change the data in the source file, and edits made to the source file will be reflected in the embedded data. c. edits made to embedded data don't change the data in the source file, nor will edits made to the source file be reflected in the embedded data. d. edits made to embedded data don't change the data in the source file; however, edits made to the source file will be reflected in the embedded data.

File account.java (see previous exercise) contains a definition for a simple bank account class with methods to withdraw, deposit, get the balance and account number, and return a string representation. note that the constructor for this class creates a random account number. save this class to your directory and study it to see how it works. then write the following additional code: 1. suppose the bank wants to keep track of how many accounts exist. a. declare a private static integer variable numaccounts to hold this value. like all instance and static variables, it will be initialized (to 0, since it’s an int) automatically. b. add code to the constructor to increment this variable every time an account is created. c. add a static method getnumaccounts that returns the total number of accounts. think about why this method should be static - its information is not related to any particular account. d. file testaccounts1.java contains a simple program that creates the specified number of bank accounts then uses the getnumaccounts method to find how many accounts were created. save it to your directory, then use it to test your modified account class.