Microsoft Query: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Unreferenced stub|auto=yes|date=December 2009}} |
{{Unreferenced stub|auto=yes|date=December 2009}} |
||
{{Orphan|date=December 2009}} |
{{Orphan|date=December 2009}} |
||
{{wikibooks|Structured Query Language}} |
|||
{{wikibooks|SQL dialects reference}} |
|||
'''Microsoft Query by Example''' (QBE) is a method of creating [[database]] [[query|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. This approach allows the user to perform powerful searches without the need of having to learn a more formalized query mechanism such as [[SQL|Structured Query Language]] (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]]. |
'''Microsoft Query by Example''' (QBE) is a method of creating [[database]] [[query|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. This approach allows the user to perform powerful searches without the need of having to learn a more formalized query mechanism such as [[SQL|Structured Query Language]] (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]]. |
||
Revision as of 05:39, 27 August 2010
 |
Microsoft Query by Example (QBE) is a 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. This approach allows the user to perform powerful searches without the need of having to learn a more formalized query mechanism such as Structured Query Language (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. Microsoft Access is an example of Microsoft QBE. Microsoft Excel allows results of QBE queries to be embedded in spreadsheets.[1]
See also
References
 | This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it. |
 | This database software-related article is a stub. You can help Wikipedia by expanding it. |