CPE222_Quiz5

It is a request for data results, and for action on data.

• Query

• Query Criteria

• Action Query

• Parameter Query

It helps you to retrieve specific items from an Access database

• Query

• Query Criteria

• Action Query

• Parameter Query

It is a query that can add, change, or delete multiple records at one time.

• Query

• Query Criteria

• Action Query

• Parameter Query

It retrieves information in an interactive manner prompting the end user to supply criteria before the query is run.

• Query

• Query Criteria

• Action Query

• Parameter Query

It is an expression that Access compares to query field values to determine whether to include the record that contains each value.

• Query

• Query Criteria

• Action Query

• Parameter Query

You can use this database object to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.

• Query

• Query Criteria

• Action Query

• Parameter Query

You can use this query to retrieve data from one or more tables and add that data to another table.

• Append Query

• Update Query

• Delete Query

• Make Table Query

You can use this query to delete data from your tables, and you can use a this query to enter criteria to specify which rows should be deleted.

• Append Query

• Update Query

• Delete Query

• Make Table Query

You can use an this query to change the data in your tables, and you can use this query to enter criteria to specify which rows should be updated.

• Append Query

• Update Query

• Delete Query

• Make Table Query

You can use this query to create a new table from data that is stored in other tables.

• Append Query

• Update Query

• Delete Query

• Make Table Query