USING MICROSOFT ACCESS

ABC Exterminator serves customers in Queens. The technician travels to a customer’s home to exterminate pests, such as termites, ants and rats. The technician inspects the home, and then decides which chemical to use. The customers are charged only for the chemical used.

ABC has three technicians. Each technician covers 2 ZIP code areas. Technician’s zip code areas do not overlap with the zip code areas of other technicians. The company serves only 6 Zip code areas in Queens. The company sends out bills once a month at end of month.

1. Create_ a database for the Company. Name the database Quiz5--(Your Last_Name)

2. Create five tables as follows:

Customer: CustomerID (text, Primary Key), CustomerName (text), Address (text), ZipCode (text)

Chemical: ChemicalID (text, Primary Key), UnitPrice (Currency)  

Technician: TechnicianID (text, primary key), TechnicianName (text), SSN (text)

AreaCoveredByTechnician: Zipcode(text, Primary Key), TechnicianID (text). ( Note this table shows which area is covered by which technician)

Orders: CustomerID, ChemicalID, Quantity, OrderDate (date),OrderID (Text, Primary Key)

PC.52 At the start of the semester Custom Kicks personnel were struggling to quickly customize their shoe inserts to their customers' feet. This hurt sales as customers became frustrated during the customization process and would hesitate to refer friends.

During week three of running the business, it took an average employee about 25 minutes to customize one pair of inserts. Recognizing this challenge, management and key employees analyzed the customization process and made some time-saving changes. Two weeks later, after training all employees on the new process, an average employee could customize a pair of inserts in about 18 minutes.

In this case, what is the output that should be used for productivity calculations?

After making the time-saving changes mentioned above, how many pair of inserts could an average employee complete in one hour? (Display your answer to two decimal places.)

After making the time-saving changes mentioned above, by what percentage did Custom Kicks' productivity increase? (Write your answer as a percentage, and display your answer to two decimal places.)
   %

The proprietor of a boutique in New York wanted to determine the average age of his customers. A random sample of 53 customers revealed an average age of 28 years with a standard deviation of 4 years. Determine a 98% confidence interval estimate for the average age of all his customers.

The proprietor of a boutique in New York wanted to determine the average age of his customers. A random sample of 53 customers revealed an average age of 28 years with a standard deviation of 4 years. Determine a 98% confidence interval estimate for the average age of all his customers.

Three identical blocks connected by ideal strings are being pulled along a horizontal frictionless surface by a horizontal force F⃗ . (Figure 1) The magnitude of the tension in the string between blocks B and C is T = 3.00 N . Assume that each block has mass m = 0.400 kg .

a) What is the magnitude F of the force?

b)What is the tension TAB in the string between block A and block B?

Please answer questions 1 - 5. Thank you.

1. What are the three types of financial assets? Please give one example or each asset category.

2. What is the difference between commercial papers and treasury bills?

3. List five money market instruments.

4. What are the benefits that are unique to municipal bonds?

5. What are the differences between common stock and preferred stock?

Address the following questions:1.Between journalizing and posting, which step changes the balance of an account? Explain.2.What are some key differences between each of three trial balances?

Analyzing & Recording Posting to the ledger (T-Accounts)Preparing a Unadjusted Trial Balance #1Adjustments for accruals and deferralsPreparing an Adjusted Trial Balance #2Prepare Financial StatementsClosing Temporary AccountPreparing a Post-Closing Trial Balance #3

This is all one question, but it is broken into several parts.

What is the difference between Raman scattering and IR absorption? Explain it using an energy diagram.

What is a difference between the Stokes Raman and the Anti-Stokes Raman scattering?

What does “Raman Shift” mean?

What is the major compound that comprises the top coating layer of an Excedrin tablet?

Draw the chemical structures of the three APIs contained in an Excedrin tablet.