Recommended tutorial: Access database tutorial
# #1. Table
The 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.
2. Query
Query can quickly find the required records according to the index and filter according to the requirements. Records and can connect fields from several tables to form a new table.
3. Form
Form provides a convenient way to browse, input and change Data window. 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
## Macros are equivalent to batch processing in DOS, used to automatically execute a Series operations. Access lists some commonly used operations for users to choose from, which is very convenient to use.
6. Module
The function of a module is similar to that of a macro, but the operations it defines are better than those of a macro. More sophisticated and complex, users can write programs according to their needs. The module is programmed using Visual Basic.
Microsoft Office Access It is a relational database management system released by Microsoft. It combines the two features of Microsoft Jet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.
Microsoft Office Access is a database management system that Microsoft combines the graphical user interface of the database engine with software development tools. It is a member of Microsoft Office and is sold separately in office versions including Professional and higher. On December 4, 2012, the latest Microsoft Office Access 2013 was released in Microsoft Office 2013. Microsoft Office Access 2010 is the previous version.
MS ACCESS stores data in its own format in an Access Jet-based database engine. It can also directly import or link data stored in other applications and databases.
The above is the detailed content of What are the database application development functional objects provided by access?. For more information, please follow other related articles on the PHP Chinese website!