Access is a relational database management system, its main features are as follows:
(1) Single storage method:
The objects managed by Access include tables, queries, forms, reports, pages, macros and modules. The above objects are stored in database files with the suffix (.mdb) to facilitate user operation and management.
(2) Object-oriented:
Access is an object-oriented development tool that uses an object-oriented approach to objectify various functions in the database system and encapsulate various functions of database management in various class object. It regards an application system as consisting of a series of objects. For each object, it defines a set of methods and attributes to define the behavior and foreign language of the object. Users can also extend methods and attributes to the object as needed. The operation and management of the database are completed through object methods and attributes, which greatly simplifies the user's development work. At the same time, this object-oriented development method makes it easier to develop applications.
(3) Friendly interface and easy to operate:
Access is a visual tool with the same style as Windows. If users want to generate objects and apply them, they only need to drag and drop with the mouse, which is very intuitive. convenient. The system also provides table generator, query generator, report designer, database wizard, table wizard, query wizard, form wizard, report wizard and other tools, making it easy to operate, easy to use and master.
(4) Integrated environment and processing of various data information:
Access is based on the integrated development environment under the Windows operating system. This environment integrates various wizards and generator tools, which greatly improves the efficiency of developers. The work efficiency makes establishing databases, creating tables, designing user interfaces, designing data queries, printing reports, etc. convenient and orderly.
(5) Access supports ODBC (Open Data Base Connectivity)
Using the powerful DDE (Dynamic Data Exchange) and OLE (Object Connection and Embedding) features of Access, you can Bitmaps, sounds, Excel tables, and Word documents can be embedded in data tables, and dynamic database reports and forms can also be created. Access can also apply programs to the network and connect with dynamic data on the network. Use database access page objects to generate HTML files to easily build Internet/Intranet applications.
The above is the detailed content of What kind of database management system is Access?. For more information, please follow other related articles on the PHP Chinese website!