Design Queries and Views How-to Topics (Visual Database Tools)

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

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

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

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

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

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

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

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

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

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