To delete data from a database

To create a new database

To update the database schema

The purpose is to retrieve specific data from a database based on certain criteria or conditions.

Use logical operators like AND or OR to combine multiple conditions in a query.

Use the NOT operator to combine multiple conditions in a query.

Specify each condition separately in a separate query.

Use mathematical operators like + or - to combine multiple conditions in a query.

To store data in a database.

To create animations and graphics.

To perform calculations and analysis on data.

To present data in a structured and organized format.

Set the 'Sort Order' property to 'Ascending' in the Sort & Filter Group.

Click on the 'Sort Descending' button in the Sort & Filter Group.

Variables

Filter

Wildcard characters

• + (plus sign)

# (number sign)

? (question mark)

* (asterisk)

Select the specific word, then on the Home tab, in the Sort & Filter group, click the Selection button, and then

in the list, click Equals

Select the specific word, then on the home tab use the Filter by Selection feature

Select the specific word, then on the home tab use the Filter by Query feature

Select the specific word, then on the home tab use the Filter by Report feature