microsoft Access file making

Download and open the Access test file below:

SloAnimals.accdbDownload SloAnimals.accdb

STEPS

• Open the Animals table and change the field length of the AnimalBreed to thirty characters. Change the caption to “Breed”.
• Relate the two tables by the common field, and enforce referential integrity.
• Examine the data in the tables. Become familiar with the field names and data in each field.
• Create and save the following queries, using the names provided (Q1, Q2, etc.):
  • Q1: Create a query to list all the dogs’ names and birthdates for all dogs born after 1/1/2015. Why? This will be used to send out advertisements for puppy training classes.
  • Q2: Create a query to list the animal type, animal name and offsite for all appointments for cattle that had an off-site visit. Why? We need special vets for farm cattle if we have the demand.
  • Q3: Create a query to show all the animals that are beagles or all that are bulldogs. Display the Owner Id and the Dog’s name but not the breed field. Why? We need to give them special shots due to a specific virus going around.
  • Q4: Create a query to sum up all the visit costs grouped by Owner. Show the list in order by Cost, high to low. Instead of displaying the label “Cost” in the result, display “Amount Spent”. Why? We want to see who spends the most with us so we can send them an office calendar.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.