Mastering Queries: A Guide to Searching in Microsoft Database Access 2007

Mastering Queries: A Guide to Searching in Microsoft Database Access 2007

Learning Objective

At the end of the lesson, you will be able to create and execute queries in Microsoft Database Access 2007.

Introduce the learning objective and make sure to reiterate it throughout the lesson.

What do you already know about using queries in Microsoft Database Access 2007?

What is a datasheet?

1. A form used to enter data into a table
2. A view of table data that displays in rows and columns
3. A tool for creating queries
4. A type of report

What is the purpose of a datasheet?

1. To create reports
2. To design forms
3. To sort and filter table data
4. To view, add, edit, and delete table data

Can you modify the layout of a datasheet?

1. Yes, you can add or remove fields and change their order
2. Yes, but only by using a form
3. No, the layout is fixed
4. Yes, you can change the width of columns

What is Form view in Microsoft Access?

1. A mode that only allows for data viewing
2. A mode that displays all records at once
3. A mode that allows for data entry and editing
4. A mode that displays one record at a time

What is the purpose of Form view?

1. To create new tables
2. To make data entry and editing easier
3. To display all records in a table
4. To display and edit individual records in a user-friendly way

How can you switch to Form view in Microsoft Access?

1. Double-click on the form object in the Navigation Pane
2. Click on the View button and select Form View
3. Click on the View button and select Table View
4. Click on the View button and select Design View

What is a database in Microsoft Database Access?

1. A collection of related data
2. A type of computer hardware
3. A tool for managing data
4. A type of computer program

What is the purpose of a database in Microsoft Database Access?

1. To create graphical user interfaces
2. To store, organize, and manage data
3. To write computer programs
4. To create tables for data entry

What is a table in Microsoft Database Access?

1. A type of computer program
2. A database object that stores data
3. A type of computer hardware
4. A collection of related data organized into rows and columns

What is a FormView in Microsoft Database Access?

1. A type of database table
2. A control to display, edit, and delete a single record
3. A widget to show a single record in detail
4. A tool to create queries

What is the purpose of a FormView in Microsoft Database Access?

1. To show a single record in detail
2. To display, edit, and delete a single record
3. To display multiple records
4. To create a database table

What are some features of a FormView in Microsoft Database Access?

1. Allows editing and deleting of a record
2. Displays a single record in detail
3. Creates a new database table
4. Displays multiple records

What is a query in Microsoft Database Access?

1. A request for data from a database.
2. A type of computer program.
3. A type of computer hardware.
4. A type of computer virus.

How do you create a query in Microsoft Database Access?

1. Using the Calculator program.
2. Using the Paint program.
3. Using the Query Design or Query Wizard.
4. Using the Word program.

How do you run a query in Microsoft Database Access?

1. Click the Cut button on the toolbar.
2. Click the Print button on the toolbar.
3. Click the Run button on the toolbar.
4. Click the Save button on the toolbar.

What is the purpose of saving a query in Microsoft Database Access?

1. To create a new database.
2. To modify the structure of the database.
3. To delete the query from the database.
4. To reuse the query at a later time.

What are Queries?

Queries are powerful tools in Microsoft Database Access 2007 that allow you to search for specific information in your database.

Explain what queries are and why they are useful. Use examples if possible.

Creating a Query

To create a query, go to the Create tab and click on Query Design. Then, select the tables you want to search and add the fields you want to include in your search criteria.

Demonstrate how to create a query step-by-step and provide screenshots as necessary.

Sorting and Filtering Data

Queries allow you to sort and filter your data based on specific criteria. You can sort by ascending or descending order and filter by specific values or ranges.

Show students how to sort and filter data in a query and provide practice exercises.

Running a Query

To run a query, simply click on the Run button in the Query Design tab. The results will be displayed in a table view.

Explain how to run a query and show students how to interpret the results.

Using Criteria in Queries

Criteria allow you to refine your search even further by adding specific conditions. You can use operators like =,<,>,<=,>= and wildcards like *,? to refine your criteria.

Teach students how to use criteria in queries and provide examples.

Using Calculated Fields

Calculated fields allow you to perform mathematical operations on your data and create new fields based on existing ones. You can use operators like +,-,*,/ and functions like SUM, COUNT, AVG, MAX, MIN to create calculated fields.

Show students how to use calculated fields and provide practice exercises.

Advanced Query Techniques

There are many advanced query techniques you can use in Microsoft Database Access 2007, including JOINs, UNIONs, and subqueries. These techniques allow you to combine data from multiple tables and perform complex searches.

Introduce students to advanced query techniques and provide resources for further study.

What is the purpose of filtering in Microsoft Database Access?

1. To create new tables
2. To display only specific records
3. To modify selected records
4. To delete selected records

Which operator is used to represent 'not equal to' in a query?

1. <>
2. <
3. >
4. =

What is the purpose of sorting in Microsoft Database Access?

1. To delete selected records
2. To modify selected records
3. To create new tables
4. To arrange data in a specific order

Which operator is used to represent 'greater than or equal to' in a query?

1. >
2. >=
3. =
4. <

What is search criteria in a query in Microsoft Database Access?

1. A tool used to design forms.
2. A function used to calculate totals.
3. A feature used to sort data.
4. Conditions used to find specific data.

What is the purpose of search criteria in a query?

1. To create new tables.
2. To filter and retrieve specific data.
3. To create relationships between tables.
4. To modify the structure of the database.

Where can search criteria be applied in a query?

1. In the header row of a datasheet view.
2. In the criteria row of a query design view.
3. In the field list of a query design view.
4. In the footer row of a datasheet view.

Write down 3 things you learned in this lesson.

Have students enter three things they learned in this lesson. With this they can indicate their own learning efficiency of this lesson.

Write down 2 things you want to know more about.

Here, students enter two things they would like to know more about. This not only increases involvement, but also gives them more ownership.

Ask 1 question about something you haven't quite understood yet.

The students indicate here (in question form) with which part of the material they still have difficulty. For the teacher, this not only provides insight into the extent to which the students understand/master the material, but also a good starting point for the next lesson.