Advantages of Access: (1) The storage mode is simple and easy to maintain and manage. Objects accessed include tables, queries, forms, reports, pages, macros and modules, all of which are stored in suffixes (.mdb or. Accdb), which is convenient for users to operate and manage. (2) Object-oriented Access is an object-oriented development tool, which makes it easier to develop applications. (3) Friendly interface and easy operation. Access is a visualization tool, but the style is exactly the same as Windows. Users want to generate objects and apply them, just drag and drop them with the mouse, which is very intuitive and convenient. The system also provides table generator, query generator, report designer, database wizard, table wizard, query wizard, form wizard, report wizard and other tools, which are simple to operate and easy to use and master. (4) Integrated environment, processing all kinds of data and information. Based on the integrated development environment under Windows operating system, Access integrates various wizards and generator tools, which greatly improves the working efficiency of developers and makes it convenient and orderly to establish databases, create tables, design user interfaces, design data queries and print reports. (5)Access supports ODBC (OpenDataBaseConnectivity). Using the powerful functions of DDE (Dynamic Data Exchange) and OLE (Connection and Embedding of Objects) of Access, you can embed bitmaps, sounds, Excel tables and Word documents in a data table, and you can also build dynamic database reports and forms. Access can also apply programs to the network and connect with dynamic data on the network. Using database to access page objects to generate HTML files makes it easy to build Internet/Intranet applications. (6) Wide support, easy expansion and greater flexibility. EXCEL files and formatted text files can be opened through linked tables, so that the data in the database can be queried and processed by using the high efficiency of the database. You can also use Access as the foreground client and SQLServer as the background database to develop large-scale database application systems (such as ADP). In a word, Access is a database, which can only be used to store data, and can also be used as a client development tool to develop database application systems. That is, it can be used to develop small software that is convenient and easy to use, and it can also be used to develop large-scale application systems. Disadvantages of ACCESS: Access is a small database, and since it is small, it has its limitations (the following performance disadvantages only refer to the use of Access as a database, excluding the use of Access as a client foreground and SQLServer as a background database): 1. The database is too large, generally exceeding 100 m (pure data, excluding client objects such as forms and reports), and the performance will deteriorate. 2. Although it supports 255 concurrent users in theory, it can't support that many in practice. If access is read-only, it is about 100 users, and if editing concurrently, it is about 10-20 users. 3. If the number of records is too large, the performance of a single table with more than one million records will become poor, and if you add bad design, this limit will be reduced. 4. It cannot be compiled into an executable file (. To use it, you must install the Access runtime environment. To sum up, access is generally used for small websites to do database and small companies to do database or application software development.