Microsoft Query

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Modernponderer (talk | contribs) at 00:37, 7 June 2015 (Mdrnpndr moved page Microsoft Query by Example to Microsoft Query: official name). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Wikibooks has a book on the topic of: Structured Query Language
Wikibooks has a book on the topic of: SQL dialects reference

Microsoft Query by Example (QBE) is a visual method of creating database queries using examples based on a text string, the name of a document or a list of documents. The QBE system converts the user input into a formal database query using Structured Query Language (SQL) on the backend, allowing the user to perform powerful searches without having to explicitly compose them in SQL, and without even needing to know SQL. It is derived from Moshé M. Zloof's original Query by Example (QBE) implemented in the mid-1970s at IBM's Research Centre in Yorktown, New York.[1]

In the context of Microsoft Access, QBE is used for introducing students to database querying, and as a user-friendly database management system for small businesses.

Microsoft Excel allows results of QBE queries to be embedded in spreadsheets.[2]

See also

References

  1. ^ Zloof, M. M., Query-by-Example: A data base language
  2. ^ Use Microsoft Query to retrieve external data


Stub icon

This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it.

Stub icon

This database software-related article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Microsoft_Query&oldid=665825610"