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

In this issue, the editor will bring you about what the common terms in the database are. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Common terms in the database:

Field

Users who have used Excel (spreadsheet software) in Office may find that the table in the following figure looks a lot like a worksheet in Excel. Access database tables and Excel worksheets have the same point: they are organized by rows and columns, and the cells are separated by gridlines, and data can be added to the cells; the difference between Access data sheets and Excel worksheets is that in Access database tables, 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 of an item in the table. Each field in the Access table can hold only one type of data (text, number, currency, date, etc.).

Indexes

An index is a list of data in a certain order that contains a field in a table or a keyword in a set of fields. By using the index, the database can quickly locate the record to be found, thus shortening the time to find the record.

Record

The data worksheet is divided into rows and columns, with rows called records (Record) and columns called fields (Field). Each record is treated as a separate entity that can be accessed or arranged as needed. The same column of data in the table has similar information, such as product ID, product name, supplier, and category. The column entries for this data are fields. Each field is identified by a clear data type, the common data types are text type, number type, currency type or date type, the field has a specific length, and each field has a name indicating its specific information category in the top row. The intersection of the row (representing the record) and the column (representing the field) is the value-the stored data element.

These are the common terms in the database shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.