What types of objects does the access2010 database include?
The main objects of Access2010 include data tables, queries, reports, forms, macros, and modules.
Data table (Table) - Table is the core object of Access database. It is mainly used to store data and is the basis for creating other five objects. A data table displays data records in rows and columns, and is a collection of the same type of data.
Tables are composed of records, and records are composed of fields. It is where data is stored in the Access database, so it is also called a database. A database can contain one or more data tables.
Query - Retrieve qualified data from one or more data tables based on pre-set restrictions, and perform statistics and analysis. The 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.
Form - Form provides a convenient window for browsing, inputting and changing data. You can also create subforms to display the contents of associated tables. On the one hand, forms can make the entry process more interesting; on the other hand, they also protect the integrity, accuracy, and security of the data.
Report - Report is used to display the retrieved data or original data in a specific way. The report can not only group the data, but also support various statistics and calculations on the data.
Macro - is a collection of one or more commands, each of which can achieve a specific function. By combining these commands, certain frequently repeated or complex actions can be automatically completed. . Most of Access's functions can be accomplished through a combination of macros.
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 can realize the following functions:
1. Use custom formulas
2. Custom functions
3. Operate other commands
4 , Beautify the login interface
php Chinese website, a large number of freeaccess database tutorials, welcome to learn online!
The above is the detailed content of What types of objects are included in the access2010 database?. For more information, please follow other related articles on the PHP Chinese website!