What is the most basic object of Access database?

The most basic object of access database is "table". Table is the basic object of the database, which is composed of records. Records are composed of fields. Tables are used to store database data, so they are also called data tables. A data table displays data records in rows and columns, and is a collection of the same type of data; a database can contain one or more data tables, and a table can only be contained by one database.

The operating environment of this tutorial: windows7 system, Dell G3 computer, Microsoft Office Access2021.

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.

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) - The table is the basic object of the databaseand is 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.

Data table in Access

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.

A data table displays data records in rows and columns, and is a collection of the same type of data. A database can contain one or more data tables, and a table can only be contained by one database.

For more related knowledge, please visit theFAQcolumn!

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