The relationship between tables and databases in access is: a database can contain multiple tables. In the Access relational database, there are 7 types of database objects, and table is one of them, used to store data; a database can contain multiple tables, and a table can only be contained by one database.
The relationship between tables and databases in access is: a database can contain multiple tables.
Access database consists of seven types of objects, which are tables, queries, forms, reports, macros, pages and modules.
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.
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.
Query - Query can quickly find the required records by index, filter records as required, and can connect fields from several tables to form a new table.
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.
Report (Report) - The function of the report is to classify and summarize the data in the database and then print it out for analysis.
Macro (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.
Module (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.
Page - is a special kind of WEB page that is directly connected to the data in the database. Publish data to the Internet or Intranet through the data access page, and use a browser to maintain and operate the data.
For more programming-related knowledge, please visit: Programming Learning! !
The above is the detailed content of What is the relationship between tables and databases in access. For more information, please follow other related articles on the PHP Chinese website!