Microsoft Access Query Basics

What is the purpose of a SELECT query in Microsoft Access?

• To update existing records in the database

• To retrieve data from one or more tables based on specified criteria.

• To delete data from the database

• To create a new table in the database

How can you filter data in a query using the WHERE clause?

• SELECT * FROM table_name HAVING column_name = 'desired_value';

• SELECT * FROM table_name WHERE column_name LIKE 'desired_value';

• SELECT * FROM table_name WHERE column_name != 'desired_value';

• SELECT * FROM table_name WHERE column_name = 'desired_value';

What keyword is used to sort results in a query in ascending order?

• DESC

• SORT

• ASC

• UP

In Microsoft Access, how do you sort results in descending order?

• SORT BY fieldName DESC

• DESCENDING fieldName

• SORT fieldName DESC

• ORDER BY fieldName DESC

• ORDER fieldName ASC

What is the syntax for selecting specific columns in a query?

• SELECT column1 column2 FROM table_name;

• SELECT column1, column2 WHERE table_name;

• SELECT column1, column2 FROM table_name;

• SELECT * FROM table_name;

How can you filter data based on multiple conditions using the WHERE clause?

• SELECT * FROM table_name WHERE condition1 NOT condition2;

• SELECT * FROM table_name WHERE condition1 XOR condition2;

• SELECT * FROM table_name WHERE condition1 OR condition2;

• SELECT * FROM table_name WHERE condition1 AND condition2;

What is the purpose of the LIKE operator in a query?

• To delete records from a table

• To sort the results in ascending order

• To perform mathematical calculations in a column

• To search for a specified pattern in a column.

Explain the difference between the WHERE and HAVING clauses in a query.

• The WHERE clause can only be used with aggregate functions, whereas the HAVING clause can only be used with regular functions.

• The WHERE clause filters rows based on a specified condition, whereas the HAVING clause filters groups based on a specified condition.

• The WHERE clause is used for numeric comparisons, whereas the HAVING clause is used for string comparisons.

• The WHERE clause filters columns based on a specified condition, whereas the HAVING clause filters rows based on a specified condition.

How can you combine multiple queries into one result set?

• Using the INTERSECT operator in SQL

• Using the JOIN operator in SQL

• Using the UNION operator in SQL

• Using the GROUP BY clause in SQL

What is the significance of the DISTINCT keyword in a SELECT query?

• It performs a join operation between tables

• It sorts the result set in ascending order

• It limits the number of rows returned in the result set

• It eliminates duplicate rows from the result set.