Business Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the serenio:
I own an Auto Service store. In my service records database, I have Customer
Table (customer number, name, address, phone, age, etc). I have Vehicle Table
(vehilceID, Customer number, make, midel, color, etc). I have a Service
Record Table (Service Number, Customer Number, VehicleID, date of service,
work performed, etc.). What are some business queries I can perform against
this database>
 
Here is the serenio:
I own an Auto Service store. In my service records database, I have Customer
Table (customer number, name, address, phone, age, etc). I have Vehicle Table
(vehilceID, Customer number, make, midel, color, etc). I have a Service
Record Table (Service Number, Customer Number, VehicleID, date of service,
work performed, etc.). What are some business queries I can perform against
this database>
Click to expand...

They are limited mainly by your imagination. Number of vehicles serviced per
month, or year to date, or any other date range; number of times a given
customer has received service; most recent service date of each silver taupe
1992 Toyota Camry serviced; total income from services (assuming that your
etc. includes the cost of service; ...

Not sure what you're asking! ANY field in your table can be used to construct
a query; any numeric field can be averaged, or summed, or searched for minimum
or maximum value... it's just up to you.


John W. Vinson [MVP]
 
Back
Top