What are the characteristics of Access?

Microsoft Office Access is a relational database management system published by Microsoft. It combines? MicrosoftJet database engine and? Graphical user interface (GUI) is one of the system programs of Microsoft Office.

MS ACCESS stores data in its own format in the database engine based on Access Jet. 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 applications, and "advanced users" can use it to build software applications.

Like other office applications, ACCESS supports Visual Basic macro language, which is an object-oriented programming language that can refer to various objects, including DAO (Data Access Object), ActiveX data objects and many other ActiveX components. Visual objects are used to display tables and reports. Their method and characteristic are that VBA code module can declare and call Windows operating system functions in VBA programming environment.

Extended data

Microsoft Access is widely used in many places, such as small businesses and departments of large companies.

Access can be used in two ways:

1. Used for data analysis: access has strong data processing and statistical analysis capabilities. Using the query function of access, you can easily carry out various statistics such as summary and average. And can flexibly set statistical conditions.

For example, in the statistical analysis of tens of thousands of records, hundreds of thousands of records or even more, Excel can't compare with it. This is reflected in: access can be used to improve work efficiency and work ability.

2. Used for developing software: access is used for developing software, such as enterprise management software such as production management, sales management and inventory management. Its greatest advantage is that it is easy to learn, and non-computer professionals can also learn. It meets the management needs of people engaged in enterprise management at low cost, regulates the behaviors of colleagues and subordinates through software, and promotes their management ideas.

This is reflected in the realization of the "dream" of managers (non-computer graduates) to develop software, thus transforming into a compound talent who knows management and can program.