Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the common terms in the database are, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

There are some common terms in the Access database. Here is a brief introduction to the common terms summarized by the editor:

1. Field

Users who have used Excel in Office may find that the tables in the Access database are very similar to the worksheets in Excel. The tables in the Access database are similar to the Excel worksheets: they are organized by rows and columns, the cells are separated by gridlines, and data can be added to the cells. The difference is that in the Access database table, each column in the table represents a field, that is, a category of information, and each row in the table is a record, which stores all the information about an item in the table. Each field in the Access table can hold only one type of data (text, number, currency, date, etc.).

two。 Indexes

An index is a list of data that contains a field in a table or a keyword in a set of fields in a certain order. The database can quickly locate the records to be queried by using the index, thus shortening the time of finding records.

3. Record

The data worksheet is divided into rows and columns, with rows called records (Record) and columns as fields (Field). Each record is treated as a separate entity that can be accessed or arranged as needed.

About the common terms in the database which are shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.