The second way to create queries in Microsoft Access is through Design View. As previously shared, there are five main groups of queries needed for the Menagerie-Kennel database at this time. They are:

• About the animals
• About the appointments based on payment
• Contact information for the pets
• Amount due for services
• Mailing labels for owners and veterinarians

The information needed to create queries in the bolded categories is found in this document: query building for design view. Follow the steps for creating queries in design view document to create the remaining Menagerie_Kennel queries.