Brain Teasers

Section Section Name Answer

F Answer in Detail

1. There are two types of queries: one-table (or singletable) queries and multi-table queries. A one-table query is written to ask questions about and get data from a single table. A multi-table query is used to get data from multiple tables.

2. To create a one-table query, the following steps can be followed:

1) Go to the Create tab.

2) Select Query Design from the Queries Ribbon.

3) Select the table you want to run a query on. This will add the table to the query.

4) Double-click on the fields you want in the results of the query.

5) Once the fields are added to the query, set the criteria on the fields.

3. To create a multi-table query, the following steps can be followed:

1) Go to the Create tab.

2) Select Query Design from the Queries Ribbon.

3) Select the tables you want to query on. To select multiple tables, press Ctrl and select the table.

4) Once the tables are added, define relationships between the tables using common fields that are present in all of them.

1. The Query Design option can be found in the Queries Ribbon.

2. The results of a multi-table query can be seen by clicking on the Run button in the Results Ribbon in the Design Tab.

3. Criteria are used to set conditions based on which answers are filtered.

4. A query is a way of asking questions about a table so that we can get useful data.

5. Advantages of using a query:

1) Selected fields: Queries help us view data only from the fields we are interested in looking at.

2) Multiple-table data: A query can be used to combine data from different tables at once.

3) Filtered records: A query can help us filter records based on some conditions.