What is the database type of access?

The database type of access is: relational database. Access is a relational database management system published by Microsoft; it handles complex calculations of fields, relationships, and rules so you can focus on your project.

Relational database

Relational database is based on the relational database model A database uses concepts and methods such as set algebra to process data in the database. It is also organized into a set of formally descriptive tables. The essence of this form of table is to load a special collection of data items. These tables The data in the database can be accessed or recalled in many different ways without the need to reorganize the database tables.

The definition of a relational database results in a table of metadata or a formal description of tables, columns, ranges, and constraints. Each table (sometimes called a relationship) contains one or more data types represented by columns. Each row contains a unique data entity of the type defined by the column.

When creating a relational database, you can define the range of possible values for a data column and further constraints that may apply to that data value. The SQL language is a standard user and application interface to a relational database. The advantage is that it is easy to expand, and after the initial database creation, a new data type can be added without modifying all existing applications.

Relational database is the mainstream of database applications. The data models of many database management systems are developed based on the relational data model.

1) Relational database: In a given application field, the collection of all entities and the relationships between entities constitutes a relational database.

2) Type and value of relational database: The type of relational database is called relational database schema, which is a description of the relational database, the definition of several fields, and several relational schemas defined on these fields; A value is a collection of relationships corresponding to these relational schemas at a certain moment, often referred to as a relational database.

Relational databases are divided into two categories:

One is a desktop database, such as Access, FoxPro and dBase, etc.; the other is a client/server database, such as SQL Server, Oracle and Sybase, etc.

Generally speaking, desktop databases are used for small, stand-alone applications. They do not require a network or server and are more convenient to implement, but they only provide data access functions.

Client/server database is mainly suitable for large-scale, multi-user database management systems. The application program consists of two parts: one part resides on the client computer and is used to display information to users and interact with users; the other part Part of it resides in the server and is mainly used to implement operations on the database and calculation and processing of data.

Access

Microsoft Office Access is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet 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 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 versions. 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.

Related recommendations: "Access Tutorial"

The above is the detailed content of What is the database type of access?. For more information, please follow other related articles on the PHP Chinese website!