Microsoft Query is a visual method of creating database queries using examples based on a text string, the name of a

document A document is a writing, written, drawing, drawn, presented, or memorialized representation of thought, often the manifestation of nonfiction, non-fictional, as well as fictional, content. The word originates from the Latin ', which denotes ...

or a list of documents. The QBE system converts the user input into a formal database query using

Structured Query Language Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

(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 Query by Example (QBE) is a database query language for relational databases. History Query by Example was devised by Moshé M. Zloof at IBM Research during the mid-1970s, in parallel to the development of SQL, and influenced by the work on rela ...

(QBE) implemented in the mid-1970s at

IBM International Business Machines Corporation (using the trademark IBM), nicknamed Big Blue, is an American Multinational corporation, multinational technology company headquartered in Armonk, New York, and present in over 175 countries. It is ...

's Research Centre in

Yorktown, New York Yorktown is a town on the northern border of Westchester County, New York, United States. A suburb of the New York City metropolitan area, it is approximately north of midtown Manhattan. The population was 36,569 at the 2020 U.S. Census. Hist ...

. In the context of

Microsoft Access Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational database, relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsof ...

, QBE is used for introducing students to database querying, and as a user-friendly

database management system In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and an ...

for small businesses.

Microsoft Excel Microsoft Excel is a spreadsheet editor developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a ...

allows results of QBE queries to be embedded in spreadsheets.

References

External links

Data management Microsoft database software {{database-software-stub

See also

References

External links