Microsoft Query: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
No edit summary
mNo edit summary
 
(23 intermediate revisions by 18 users not shown)
Line 1: Line 1:
{{short description|Method of creating database queries}}
{{Unreferenced stub|auto=yes|date=December 2009}}
{{Orphan|date=December 2009}}
{{Refimprove|date=December 2009}}


'''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''' 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>{{cite journal |last=Zloof |first=M.M. |doi= 10.1147/sj.164.0324 |title=Query-by-Example: A data base language |journal=IBM Systems Journal |volume=16 |issue=4 |date=1977 |pages=324–343 |citeseerx=10.1.1.86.3485}}</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>
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.<ref>{{cite web |url=https://support.office.com/en-us/article/Use-Microsoft-Query-to-retrieve-external-data-42a2ea18-44d9-40b3-9c38-4c62f252da2e |title=Use Microsoft Query to retrieve external data |work=Office Support: Excel for Microsoft 365 Excel 2021, 2019, 2016, 2013, 2010, 2007 |publisher=Microsoft |date=}}</ref>


==See also==
==See also==
[[Microsoft SQL Server]]
*[[Query by Example]]
*[[Microsoft Access]]
*[[Microsoft SQL Server]]


==References==
==References==
{{Reflist}}
{{Reflist}}


==External links==
{{wikibooks|Structured Query Language}}
{{wikibooks|SQL dialects reference}}
{{DEFAULTSORT:Microsoft Query By Example}}
{{DEFAULTSORT:Microsoft Query By Example}}
[[Category:Data management]]
[[Category:Data management]]
[[Category:Microsoft database software]]
[[Category:Microsoft database software]]


{{Microsoft development tools}}


{{Microsoft-software-stub}}
{{Microsoft-software-stub}}

Latest revision as of 18:42, 4 November 2022

Microsoft Query 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[edit]

References[edit]

  1. ^ Zloof, M.M. (1977). "Query-by-Example: A data base language". IBM Systems Journal. 16 (4): 324–343. CiteSeerX 10.1.1.86.3485. doi:10.1147/sj.164.0324.
  2. ^ "Use Microsoft Query to retrieve external data". Office Support: Excel for Microsoft 365 Excel 2021, 2019, 2016, 2013, 2010, 2007. Microsoft.

External links[edit]

Wikibooks has a book on the topic of: Structured Query Language
Wikibooks has a book on the topic of: SQL dialects reference
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=1120032446"