Microsoft Query: Difference between revisions

Content deleted Content added

Inline

Revision as of 00:55, 26 March 2013

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]

Microsoft Access is probably the most commonly used system that incorporates Microsoft QBE. In the context of Access, QBE is commonly used for to introduce 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]

References

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

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.

[1] Zloof, M. M., Query-by-Example: A data base language

[2] Use Microsoft Query to retrieve external data

[1]

[2]

@@ Line 4: / Line 4: @@
 {{wikibooks|SQL dialects reference}}
-'''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 Query by Example''' (QBE) is a visual 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 using [[SQL|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]].<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 probably the most commonly used system that incorporates Microsoft QBE. In the context of Access, QBE is commonly used for to introduce 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.<ref>[http://office.microsoft.com/en-us/excel/HA100996641033.aspx Use Microsoft Query to retrieve external data]</ref>
 ==See also==
+*[[Microsoft Access]]
 *[[Microsoft SQL Server]]