What is an Access database

Microsoft Access is a relational database that consists of a series of tables that consist of a series of rows and columns, each row being a record, each column being a field, each field having a field name, and the field name cannot be duplicated in a table.

A relationship (or an association, a connection) can be established between a table and a table so that the information associated with the query is queried. The Access database is saved as a file, and the file's extension MDB.

An Access database consists of six objects, which are tables, queries, forms, reports, macros, and modules.

Table--Tables are the basic objects of a database and are the basis for creating other 5 objects. The table is composed of records, the records are composed of fields, the table is used to store data of database, it is also called data table.

Query--A query can quickly find the records that you want by index, and you can make a new table of fields that filter records and connect several tables as required.

Form--The form provides a convenient window for browsing, entering, and changing data. You can also create a subform to display the contents of the associated table. Forms are also called forms.

Report--The function of a report is to categorize the data in a database and then print it for analysis.

Macros (MACRO)-a macro is equivalent to a batch in DOS to automate a series of actions. Access lists a number of commonly used operations that are convenient for users to choose from.

Module--The function of a module is similar to a macro, but it defines operations that are finer and more complex than macros, and users can write programs according to their needs. Modules are programmed using Visual Basic.