Misplaced Pages

This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Microsoft Query" – news · newspapers · books · scholar · JSTOR (December 2009) (Learn how and when to remove this message)

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.

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.

See also

• Query by Example
• Microsoft Access
• Microsoft SQL Server
• Power Query

References

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

v t e Microsoft development tools
Development environments	Visual Studio Code Express Team System Profiler Tools for Applications Tools for Office Others Blend Expression Web FxCop GW-BASIC MACRO-80 Macro Assembler MSBuild Pascal QuickBASIC QBasic QuickC Robotics Developer Studio Roslyn SharePoint Designer FrontPage Small Basic WebMatrix Windows App SDK Windows App Studio Windows SDK CLR Profiler ILAsm Native Image Generator WinDiff XAMLPad
Languages	Dynamics AX BASIC Visual Basic legacy VB.NET VBA VBScript Bosque Visual C++ C++/CX C++/CLI Managed C++ C++/WinRT C# C/AL Dafny Dexterity F# F* Visual FoxPro Java J++ J# JavaScript TypeScript JScript IronPython IronRuby Lean P Power Fx PowerShell Project Verona Q# Small Basic VPL XAML
APIs and frameworks	Native Windows API Silverlight XNA DirectX Managed DirectX UWP Xbox Development Kit Windows Installer WinUI .NET ASP.NET Core AJAX Dynamic Data MVC Razor Web Forms ADO.NET Entity Framework MAUI CardSpace Communication Foundation Identity Foundation LINQ Presentation Foundation Workflow Foundation Device drivers WDK WDF KMDF UMDF Windows HLK WDM
Database	SQL Server Express Compact Management Studio Business Intelligence Development Studio MSDE SQL services Analysis Reporting Integration Notification Other Visual FoxPro Microsoft Access Access Database Engine Extensible Storage Engine
Source control	Visual SourceSafe Team Foundation Version Control
Testing and debugging	CodeView OneFuzz Playwright Script Debugger WinDbg xUnit.net
Delivery	Active Setup ClickOnce npm NuGet vcpkg Web Platform Installer Windows Installer WiX Windows Package Manager Microsoft Store
Category

This article about software created, produced or developed by Microsoft is a stub. You can help Misplaced Pages by expanding it.

• v
• t
• e

This database software-related article is a stub. You can help Misplaced Pages by expanding it.

• v
• t
• e

• Data management
• Microsoft database software
• Microsoft software stubs
• Database software stubs