The Query and View Designer provides built-in features for some query types--Select, Insert Results, Insert Values, Update, Delete, and Make Table--and also supports UNION, Full-text search, and CASE expression queries.
- Supported Query Types (Visual Database Tools)
Describes the query types you can use with the Query and View Designer.
- How to: Create Full-Text Search Queries
Describes how to create a query that searches a full-text indexed column.
- How to: Create Insert Results Queries
Describes how to create a query that inserts the results of a SELECT statement into a table.
- How to: Create Insert Values Queries
Describes how to create a query that inserts values into a table.
- How to: Create Make Table Queries
Describes how to create a query that creates a new table.
- How to: Create Delete Queries
Describes how to create a query that deletes data.
- How to: Create UNION Queries
Describes how to create a query that merges the results of two or more SELECT statements into one result set.
- How to: Create Update Queries
Describes how to create a query that updates a table.
- Query Properties
Describes the properties available to you when designing queries.
- Reference (Visual Database Tools)
Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.
- Designing Queries and Views
Describes how to design and manipulate queries and views.