Available Answers

1. 1.

   Fill in the blanks.

   1. A query is a request for ______________, for______________, or for both.
   2. Queries that add, change, or delete data are called ______________.
   3. Queries that you use to retrieve data from a table or to make calculations are called ______________.
   4. You can use queries to ______________ your data, to perform ______________ with your data, and to ______________ your data.
   5. These relationships exist on the basis of ______________ that the tables have in common.
2. 2.

   Write True or False.

   1. A query is a request for data entry.
   2. MS Access has four types of queries.
   3. Action queries are that which add, change, or delete data.
   4. An association that is established between common fields (columns) in two tables is called a relationship.
   5. Ctrl + S is used for saving a query.
3. 3.

   Multiple Choice Questions (MCQs).

   1. Queries that you use to retrieve data from a table or to make calculations are called ______________ queries.
      1. Action
      2. Select
      3. Retrieve
   2. Northwind 2007 is a ______________ template.
      1. database
      2. spreadsheet
      3. None of these
   3. A ______________ query prompts you for field values and then uses the values, that you supply to create criteria for your query.
      1. supply
      2. parameter
      3. select
   4. * and ? are ______________ cards.
      1. special
      2. symbols
      3. wild
   5. A totals query is a query, that allows you to ______________ and summerize data.
      1. Calculate
      2. aggregate
      3. group
4. 4.

   What is a query? What is the use of queries?
5. 5.

   What are the types of queries? Explain.
6. 6.

   How do you create a query?