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!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Dreamweaver Mac version
Visual web development tools

SublimeText3 English version
Recommended: Win version, supports code prompts!

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Atom editor mac version download
The most popular open source editor

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
