Title: Learning Objectives
Course: Introduction to Database (TEMPLATE) > Section: Competency Modules

After learning this competency, students will be able to:

1. Find, modify, and delete records in a table.

2. Create, run, and save queries.

3. Update data using a query datasheet.

4. Create a query based on multiple tables.

5. Sort and filter data in a query.

6. Specify an exact match condition in a query.

7. Use a comparison oeprator in a query to match a range of values.

8. Use the And and Or logical operatiors in queries.

9. Create and format a calculated field in a query.

10. Perform calculations in a query using aggregate functions and record group calculations.