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.