Creating Queries

Visual Database Tools

Visual Database Tools

Creating Queries

The Query Designer features an easy-to-use interface for working with your queries. The topics in this section describe the fundamentals of working with any query, including how to choose a table or table-structured object to work with, how to add or remove data columns from the query, and how to execute the query.

To See
Add or remove tables or table-structured objects from a query Adding Tables Removing Tables
Add or remove columns from a query or from the query output Adding Columns
Removing Columns from Query Output
Removing Columns from the Query
Change how query results are displayed Reordering Output Columns
Ordering Query Results
Clear or print the query results Clearing Query Results
Printing Query Results
Create aliases for tables or columns Creating Table Aliases
Creating Column Aliases
Check the syntax of a query Verifying a Query
To run or stop a query Executing a Query
Stopping a Query