What can be the data sources queried in access?

The data sources queried in Access can be: tables and queries. In Access, the data source of the query can be a table, a view, or another query, but it cannot be a report; the query can quickly find the required records by index, filter the records as required, and can connect fields from several tables to form a new table.

The operating environment of this tutorial: Windows 10 system, Dell G3 computer, Microsoft Office Access2019.

The data sources queried in Access can be: tables and queries.

Related recommendations: "Access Tutorial"

The ACCESS database is composed of seven types of objects, which are "table", "query" and "form" , "Reports", "Pages", "Macros" and "Modules".

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.

In Access, the data source of a query can be a table, a view, or another query, but it cannot be a report.

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.

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

The above is the detailed content of What can be the data sources queried in access?. For more information, please follow other related articles on the PHP Chinese website!