The access2003 database object types include tables, queries, forms, reports, macros, pages, and modules. Access is a relational database management system released by Microsoft, which combines the two features of Microsoft Jet Database Engine and graphical user interface.
The object types of the access2003 database include the following:
1. Table (Table) - The table is the basic object of the database. The basis for creating the other 5 types of 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.
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.
The module can realize the following functions:
Use custom formula
Use custom function
Operate other commands
Beautify the login interface
Related introduction:
Microsoft Office Access is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet 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 versions. On September 25, 2018, the latest Microsoft Office Access 2019 was released in Microsoft Office 2019.
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.
Related recommendations: access database tutorial
The above is the detailed content of What are the object types of access2003 database?. For more information, please follow other related articles on the PHP Chinese website!