Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Designing Queries and Views 

The Query and View Designer can help you create and maintain the data retrieval and data manipulation portions of your application.

In This Section

How to: Open the Query and View Designer

Provides steps for opening a new or existing query or view in the Query and View Designer.

Comparison of Queries and Views

Points out the similarity and differences between queries and views.

Navigating in the Query and View Designer

Provides a list of key combinations and mouse operations you can use in the Qeury and View Designer.

Query and View Designer Tools

Provides links to topics describing the various components of the Query and View Designer.

Types of Queries

Lists procedural topics on how to create various types of queries, such as UPDATE, DELETE, and MAKE TABLE queries.

Working with Views

Defines "view" and describes the operations you can perform on views.

Working with Data in the Results Pane

Describes what you can do with the results returned by a query or view and provides links to procedural topics.

Performing Basic Operations with Queries

Lists topics on creating, modifying, running, and copying queries as well as basic topics on sorting, ordering, and printing query results.

Specifying Search Criteria

Lists rules and conventions for creating queries, as well as procedures on how to use criteria to get specific results.

Expressions in Queries

Provides links to topics such as how to use expressions in queries, what logical operators, and how to include user-defined functions in queries.

Querying with Joins

Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.

Querying with Parameters

Lists topics for creating queries with parameters, which allow a different value to be used each time you run the query.

Related Sections

Overview of Visual Database Tools

What is new in Visual Database Tools and how the tools interact with your database.

Understanding Visual Database Tools

Overview of the tools included and how to manage large database projects.

Designing Tables

Detailed steps for designing and maintaining database structure through tables, columns, keys, indexes, stored procedures, and more.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft