Microsoft Office Access refers to the relational database management system released by Microsoft. It is a database management system that Microsoft combines the graphical user interface of the database engine and software development tools; it can be used for data analysis and development software.
The operating environment of this tutorial: Windows 10 system, Microsoft Office Access 2019 version, Dell G3 computer.
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. 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.
Microsoft Access is widely used in many places, such as small businesses and departments of large companies.
The purpose of Access is reflected in two aspects:
1. Used for data analysis: Access has powerful data processing and statistical analysis capabilities. Using the query function of Access, you can easily perform Various summary, average and other statistics. And the statistical conditions can be flexibly set. For example, it is fast and easy to operate when statistically analyzing tens of thousands of records, hundreds of thousands of records or more, which Excel cannot compare with. This is reflected in: knowing how to use access, [3] improves work efficiency and work ability.
2. Used to develop software: access is used to develop software, such as production management, sales management, inventory management and other types of enterprise management software. Its biggest advantage is: easy to learn! Non-computer majors can also learn it. It meets the management needs of those engaged in enterprise management at a low cost, and uses software to regulate the behavior of colleagues and subordinates and promote their management ideas. (VB, .net, C language and other development tools are too difficult for non-computer professionals, while access is very easy). This is reflected in the realization of the "dream" of managers (non-computer major graduates) to develop software, thus transforming into compound talents who "understand management and can program".
For more programming-related knowledge, please visit: Programming Teaching! !
The above is the detailed content of what does microsoft office access mean. For more information, please follow other related articles on the PHP Chinese website!