The query types supported by Access include selection query, crosstab query, parameter query, SQL query and operation query. access is a relational database management system released by Microsoft, which combines the two features of Microsoft Jet Database Engine and graphical user interface.
(Learning video sharing: Programming video)
Detailed introduction:
Microsoft Office Access It is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.
Microsoft Office Access is a database management system that Microsoft combines the graphical user interface of the database engine with software development tools. It is a member of Microsoft Office and is sold separately in office versions including Professional and higher versions. On September 25, 2018, the latest Microsoft Office Access 2019 was released in Microsoft Office 2019.
MS ACCESS stores data in its own format in an Access Jet-based database engine. It can also directly import or link data stored in other applications and databases.
Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build software applications. Like other office applications, ACCESS supports the Visual Basic macro language, which is an object-oriented programming language that can reference a variety of objects, including DAO (Data Access Objects), ActiveX data objects, and many other ActiveX components. Visual objects are used to display tables and reports. Their methods and properties are in the VBA programming environment. VBA code modules can declare and call Windows operating system functions.
Related recommendations: access database tutorial
The above is the detailed content of What are the query types supported by access?. For more information, please follow other related articles on the PHP Chinese website!