what software is microsoft access

Microsoft Access 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.

#The operating environment of this tutorial: Windows 10 system, Dell G3 computer.

What software is microsoft access?

Microsoft Office Access 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.

Function

Canceling the traditional menu operation method and replacing it with the ribbon is one of the obvious improvements of Access2007. Users can perform most database operations in the ribbon. Manage related operations. Access2007 has the following 4 functional areas by default. Each functional area is divided into multiple groups according to the function of the command.

• Start

The "Start" ribbon includes view, clipboard, fonts, formatted text, records, sorting and filtering, search, There are 8 groups for converting Simplified Chinese to Traditional Chinese. Users can perform operations on Access2007 in the "Start" functional area, such as copying and pasting data, modifying fonts and font sizes, sorting data, etc.

• Create

The "Create" ribbon includes 5 groups: table, form, report, other and special symbols, "Create" The commands contained in the ribbon are mainly used to create various elements of Access2007.

• External Data

The "External Data" functional area includes four groups: import, export, collected data, and SharePoint lists. Under "External Data" "The functional area mainly deals with data other than Access2007.

• Database Tools

The "Database Tools" functional area includes 5 groups: Macro, Show/Hide, Analysis, Mobile Data, and Database Tools. Mainly for more advanced operations on Access2007 database.

In addition to the above four functional areas, there are also some hidden functional areas that are not displayed by default. The relevant ribbon will only appear when performing a specific operation. For example, when performing a table creation operation, the "Data Table" ribbon will be automatically opened.

For more related knowledge, please visit the FAQ column!

The above is the detailed content of what software is microsoft access. For more information, please follow other related articles on the PHP Chinese website!