Microsoft Query: Difference between revisions
Content deleted Content added
m Reverted edits by 119.111.124.130 (talk) to last revision by 99.23.163.104 (HG) |
Fixed link to disambiguation page |
||
Line 5: | Line 5: | ||
{{wikibooks|SQL dialects reference}} |
{{wikibooks|SQL dialects reference}} |
||
'''Microsoft Query by Example''' (QBE) is a method of creating [[database |
'''Microsoft Query by Example''' (QBE) is a method of creating [[database query|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 [[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]].<ref>Zloof, M. M., [http://dx.doi.org/10.1147/sj.164.0324 Query-by-Example: A data base language]</ref> |
||
[[Microsoft Access]] is an example of Microsoft QBE. [[Microsoft Excel]] allows results of QBE queries to be embedded in spreadsheets.<ref>[http://office.microsoft.com/en-us/excel/HA100996641033.aspx Use Microsoft Query to retrieve external data]</ref> |
[[Microsoft Access]] is an example of Microsoft QBE. [[Microsoft Excel]] allows results of QBE queries to be embedded in spreadsheets.<ref>[http://office.microsoft.com/en-us/excel/HA100996641033.aspx Use Microsoft Query to retrieve external data]</ref> |
||
Revision as of 22:09, 8 November 2010
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 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.[1] Microsoft Access is an example of Microsoft QBE. Microsoft Excel allows results of QBE queries to be embedded in spreadsheets.[2]
See also
References