scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 1,596
Examine the sample purchase order database for this session and be sure you understand each of the queried that have been developed and what they doAdd the following data to the dentist databaseFor each of the following queries there is no problem in adding records to tables if you feel it would help you to understand what is happening in the queryCreate a Select query that is based on the Appointment and Patient tables and that displays all the fields from the Appointment table and Amount owed from the Patient table Name it Appointments This query will be used in a later session to allow for the dentists to make bookings and to take payment following treatmentCreate a Select query that is based on the Appointment and Patient tables that allows the user to enter a dentists name and the output then displays the dentists name the patients full name in a single field and the patients address town post code and telephone number Name this query Dentists patientsUnder the View menu of a query in design mode there is an option called Totals Once selected this provides an additional row in the grid This provides a pull-down list that allows you to provide collated outputCreate a Select query that will display for each dentist how many of each of the treatments heshe has made and name it Dentists treatmentsA YesNo field returns a 0 if it is not selected and a -1 if it is To create a query that returns zeros and negative numbers is relatively easy However the output to this query should be a positive number Use the Help system Hint Expressions and the Abs functionIn this query you are going to create an archiving process What is required is that if a patient has not been for an appointment for over two years they are removed from the current records However there may be a good reason for their absence
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA