MS Access Queries - The Dog House Database

Which of the following is NOT a field in the given dog database?

• Breed

• Lifespan

• Colour

• Temperament

If you want to find all dogs that are good with children, which field should you use in your query criteria?

• Grooming Needed

• Good with Children

• Exercise Required

• Location

What is the first step to create a simple query in MS Access using Query Design?

• Click on 'Run'

• Select the table you want to query

• Enter the criteria

• Print the results

Which field would you use to search for all dogs that are originally from France?

• Country of Origin

• Location

• Breed

• Size

If you want to find all dogs that need a lot of exercise, What would you enter as the criteria in the Exercise Required field?

• None

• YES

• High

• Lots

What button do you click in MS Access to see the results of your query after entering your criteria?

• 
• 
• 
• 

What would be the criteria you would enter in the Size field to find all the small dogs?

• Wee

• Small Sized

• Small

• Little

If you want to search for dogs that live longer than 12 years, which field should you use in your query criteria?

• Age

• Lifespan

• Breed

• Location

What is the purpose of using criteria in a query in MS Access?

• To delete records

• To filter records based on specific conditions

• To print the database

• To change the field names

Which of the following is the correct order of steps to create and run a simple query in MS Access?

• Enter criteria, select table, click Run

• Select table, enter criteria, click Run

• Click Run, select table, enter criteria

• Select table, click Run, enter criteria