Introduction

Microsoft Office Access is a relational Database management system released by Microsoft. It combines the characteristics of the Microsoft Jet 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 combines the graphical user interface of the database engine with Programming tool. It is a member of Microsoft Office and is sold separately in both professional and higher versions of Office. 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 (which is stored in other applications and databases).

Software developers and data architects can use Microsoft Access to develop application software, and "advanced users" can use it to build software applications. Like other office applications, ACCESS supports the Visual Basic macro language. It is an object-oriented programming language that can reference various objects, including DAO (Data access object), ActiveX data objects, and many other ActiveX components. Visual objects are used to display tables and reports, and their methods and properties are in the VBA programming environment. VBA code modules can declare and call Windows operating system functions.

use to

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. With its query function, it can conveniently perform various types of summary, average, and other statistics. And the statistical conditions can be flexibly set. For example, when analyzing data with tens of thousands of records, hundreds of thousands of records, and more, Excel is faster and more convenient to operate, which is incomparable to Excel. This is reflected in the ability to use access, which improves work efficiency and ability.

2、 Used to develop software: Access is used to develop software, such as various enterprise management software such as production management, sales management, inventory management, etc. Its biggest advantage is that it is easy to learn! Non computer professionals can also learn. Low cost meets the management needs of those engaged in enterprise management work, using software to regulate the behavior of colleagues and subordinates and promote their management ideas. Development tools such as VB,. net, and C are too difficult for non computer professionals, while access is easy. This is reflected in the realization of the "dream" of management personnel (non computer major graduates) to develop software, thus transforming into a compound talent who "understands management+can program".

In addition, when developing some small website WEB applications, it is used to store data. For example, ASP+Access. These applications all utilize ASP technology to run on Internet Information Services. More complex web applications use PHP/MySQL or ASP/Microsoft SQL Server

ACCESS has more uses, reflected in many aspects:

Table template. Simply type in the content that needs to be tracked, and Access will use the form template to provide an application that can complete related tasks. Access can handle complex calculations of fields, relationships, and rules, allowing you to focus on projects. You will have a brand new application that includes a natural UI that can immediately start and run.

Create and run old databases. Enjoy the support for your existing desktop database (ACCDB/MDB) to the fullest.

Function

One of the significant improvements of Access 2007 is to eliminate traditional menu operations and replace them with functional areas, where users can perform the vast majority of database management related operations. By default, Access 2007 has the following four functional areas, each divided into multiple groups based on the function of the command.

Start

The "Start" ribbon includes 8 groups: view, clipboard, font, formatted text, record, sorting and filtering, search, and Chinese simplified and traditional conversion. Users can operate on Access2007 in the "Start" ribbon, such as copying and pasting data, modifying font and size, sorting data, etc.

Create

The "Create" ribbon includes five groups: tables, forms, reports, others, and special symbols. The commands contained in the "Create" ribbon are mainly used to create various elements of Access 2007.

External Data

The "External Data" ribbon includes four groups: import, export, collect data, and SharePoint list. In the "External Data" ribbon, it mainly processes data outside of Access2007.

Database tools

The "Database Tools" ribbon includes five groups: macros, show/hide, analyze, move data, and database tools, mainly for advanced operations on the Access 2007 database.

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