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)

You are an IT company and want to get a travel agency's network design, hardware, software, and security. DMZ Architecture: What is your DMZ architecture? What devices and their function are included? How are DMZ devices connected? How are you planning to provide security to protect the DMZ and at the same time maintaining friendly access to customers?

The company officers have made a decision to develop partnerships with a group of distributors. These distributors will employ sales people to call on retailers who sell Body Glove products. What steps can Body Glove take to ensure that retailers and retail customers receive excellent service? Give reasons to justify your steps

Exercise 10-13

Presented below is information related to Kingbird Company.

1. On July 6, Kingbird Company acquired the plant assets of Doonesbury Company, which had discontinued operations. The appraised value of the property is:

Kingbird Company gave 12,500 shares of its $100 par value common stock in exchange. The stock had a market price of $202 per share on the date of the purchase of the property.

2. Kingbird Company expended the following amounts in cash between July 6 and December 15, the date when it first occupied the building. (Prepare consolidated entry for all transactions below.)

3. On December 20, the company paid cash for equipment, $272,300, subject to a 2% cash discount, and freight on equipment of $11,410.

Prepare entries on the books of Kingbird Company for these transactions. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places e.g. 58,971. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

list of accounts

Accounts Payable
Accumulated Depreciation-Building
Accumulated Depreciation-Equipment
Accumulated Depreciation-Machinery
Accumulated Depreciation-Trucks
Buildings
Cash
Common Stock
Contribution Revenue
Cost of Goods Sold
Depreciation Expense
Direct Labor
Discount on Notes Payable
Equipment
Factory Overhead
Gain on Disposal of Buildings
Gain on Disposal of Equipment
Gain on Disposal of Machinery
Gain on Disposal of Trucks
Insurance Expense
Interest Expense
Inventory
Land
Land Improvements
Loss on Disposal of Buildings
Loss on Disposal of Equipment
Loss on Disposal of Machinery
Loss on Disposal of Trucks
Machinery
Maintenance and Repairs Expense
Materials
No Entry
Notes Payable
Organization Expense
Paid-in Capital in Excess of Par - Common Stock
Prepaid Insurance
Retained Earnings
Salaries and Wages Expense
Sales Revenue
Trading Securities
Trucks

Exercise 10-13

Presented below is information related to Kingbird Company.

1. On July 6, Kingbird Company acquired the plant assets of Doonesbury Company, which had discontinued operations. The appraised value of the property is:

Kingbird Company gave 12,500 shares of its $100 par value common stock in exchange. The stock had a market price of $202 per share on the date of the purchase of the property.

2. Kingbird Company expended the following amounts in cash between July 6 and December 15, the date when it first occupied the building. (Prepare consolidated entry for all transactions below.)

3. On December 20, the company paid cash for equipment, $272,300, subject to a 2% cash discount, and freight on equipment of $11,410.

Prepare entries on the books of Kingbird Company for these transactions. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places e.g. 58,971. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

List of Accounts

Accounts Payable
Accumulated Depreciation-Building
Accumulated Depreciation-Equipment
Accumulated Depreciation-Machinery
Accumulated Depreciation-Trucks
Buildings
Cash
Common Stock
Contribution Revenue
Cost of Goods Sold
Depreciation Expense
Direct Labor
Discount on Notes Payable
Equipment
Factory Overhead
Gain on Disposal of Buildings
Gain on Disposal of Equipment
Gain on Disposal of Machinery
Gain on Disposal of Trucks
Insurance Expense
Interest Expense
Inventory
Land
Land Improvements
Loss on Disposal of Buildings
Loss on Disposal of Equipment
Loss on Disposal of Machinery
Loss on Disposal of Trucks
Machinery
Maintenance and Repairs Expense
Materials
No Entry
Notes Payable
Organization Expense
Paid-in Capital in Excess of Par - Common Stock
Prepaid Insurance
Retained Earnings
Salaries and Wages Expense
Sales Revenue
Trading Securities
Trucks

A school that opened with 1500 students in the year 2000 was expected to grow at a rate of p'(t)= 150/ √(1+.2t), where p(t) represents the total school population t years after 2000. What was the expected enrollment in 2005.

I got p(t) to be 1500√u and I can't find out how to get C. If someone could make sure I have the right p(t) and explain how to get C, that would be great.

f Nokia decided to embrace the change and move from the old slate (Nokia phones in 2005) to the future slate (smartphones similar to apple and Samsung smartphones in 2020), bearing in mind the lesson learned stated in the last page in the case, propose suitable levers throughout Lewin’s three phases of managing change which in your opinion could have saved Nokia from failure. The levers should cover the four organisational subsystems. (at least 2 levers in each subsystem).

Which of the following statements is false?

Group of answer choices

One disadvantage of the corporate form is the double taxation of profit.

A debenture is an unsecured debt with maturity longer than 10 years.

The primary goal of a publicly-owned for-profit corporation is to maximize the value of stock.

As interest rate increases significantly, companies are more likely to call the callable bonds they have issued.

Equity holders have a residual claim in the firm while creditors have voting power.

Problem 12-08A

Why is a company's cash burn rate significant for its survival?

A) It represents the speed with which the company is using up cash and how soon it will run out of cash in an adverse economic environment.

B) It is a signal of the ability of a startup company to raise cash from venture capitalists.

C) It indicates how quickly the company will run out of cash before it can pay all its debt obligations.

D) It measures the rate at which a company is investing in new products and how quickly it will generate additional revenue.