Reference no: EM132163293
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)
|
How does empathy relate to emotional intelligence
: How does empathy relate to Emotional Intelligence (EI) and how can this characteristic increase a manager's effectiveness?
|
|
Identify list of opportunities and threat for the deere
: What driving forces do you see at work in this industry? Identify a list of Opportunities and Threat for the Deere.
|
|
Researchers use projective techniques to explore consumers
: Researchers use "Projective Techniques" to explore consumers’ motivations, beliefs, attitudes and values.
|
|
Create rental query and named qryrental
: Create an Rental query, named QryRental, which includes Order ID, Days Rented, SubTotal, Order Month and Order Year.
|
|
Technician travels to customer home to exterminate pests
: ABC Exterminator serves customers in Queens. The technician travels to a customer’s home to exterminate pests, such as termites, ants and rats.
|
|
The customers are charged only for the chemical used
: The technician inspects the home, and then decides which chemical to use. The customers are charged only for the chemical used.
|
|
Brands emulate virgin brand-building programs
: Why don't more brands emulate Virgin's brand-building programs?
|
|
What is the company cost of equity capital
: Ortiz's CFO has calculated the company's WACC as 8.97%. What is the company's cost of equity capital?
|
|
What is clinical transformation
: How can healthcare information systems minimize or reduce the number of errors in healthcare? What is “Clinical Transformation” and how does it impact quality?
|