There are several different objects in the access database

The access database has 7 different objects: "table", "query", "form", "report", "page", "macro" and "module"; among them, the table is the core object , mainly used to store data. These objects are each responsible for certain functions in the database and cooperate with each other to build a database.

The operating environment of this article: windows10 system, Dell G3 computer, Microsoft Office Access2021.

In Access, the so-called building materials are the main objects in the database, which include "table", "query", "form", "report", "page", "macro" and " module". These objects are each responsible for certain functions in the database and cooperate with each other to build a database.

1. Table - Table is the basic object of the database and the basis for creating the other five objects. Tables are composed of records, and records are composed of fields. Tables are used to store database data, so they are also called data tables.

Table is the core object of Access database, mainly used to store data. It is the basis for creating several other objects.

2. Query - Query can quickly find the required records according to the index, filter the records according to the requirements, and can connect the fields of several tables to form a new table.

3. Form (Form) - Form provides a convenient window for browsing, inputting and changing data. You can also create subforms to display the contents of associated tables. A form is also called a form.

4. Report - The function of the report is to classify and summarize the data in the database and then print it out for analysis.

5. Macro - Macro is equivalent to batch processing in DOS, used to automatically perform a series of operations. Access lists some commonly used operations for users to choose from, which is very convenient to use.

6. Page - is a special kind of WEB page that is directly connected to the data in the database. The data is published to the Internet or Intranet through the data access page, and the browser can be used to maintain and operate the data.

7. Module - The function of a module is similar to that of a macro, but the operations it defines are more detailed and complex than macros. Users can write programs according to their own needs. The module is programmed using Visual Basic.

In the database, "table" is used to store data; "query" is used to find data; people obtain data through "form", "report" and "page"; and "macro" and "module" ” is used to realize automatic operation of data. In fact, for a database, the most important function is to obtain data in the database, so the flow of data between various objects in the database has become what we are most concerned about. In order to be able to clearly arrange various structures when building a database in the future, you should first understand the functions and connections between objects in the Access database.

As a database, the most basic thing is to have a table and data stored in the table. For example, in the "address book" database, you must first create a table, and then enter someone's contact address, phone number and other information into the data table, so that there is a data source in the database.

After having these data, they can be displayed on the form. This process is to establish a connection between the data in the table and the controls on the form. This process is called "binding" in Access.

In this way, the data actually stored in the table can be obtained through various form interfaces on the screen. Moreover, reasonably placing controls and patterns on the form can make it easier for us to operate and understand the meaning of the data in the database.

In this way, the flow of data from the table to the form is completed, and the data in the database is communicated between the computer and the human. For example, in the "Address Book" database, use an automatic form to display a record in the database on the form, and control the record operation button on the form to move back and forth in the table, and you can see information corresponding to other records.

For more programming-related knowledge, please visit: Introduction to Programming! !

Related recommendations: "Access Tutorial"

The above is the detailed content of There are several different objects in the access database. For more information, please follow other related articles on the PHP Chinese website!