Shulou(Shulou.com)06/03 Report--

What are the actions that can be done in Datasheet view? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

The operations that can be done in Datasheet view are field editing, addition, deletion, record deletion, data lookup, etc., but the table structure established by Datasheet view only describes the field name in the table. however, it does not specify the data type and attribute value of each field, and cannot be modified.

In Datasheet view, you can do: 1, delete a record; 2, delete a field; 3, modify the name of the field.

What cannot be done in Datasheet view is to modify the type of the field.

You can edit, add, delete, delete records and find data in the Datasheet view, but the table structure established by the Datasheet view only describes the field name in the table. however, it does not specify the data type and attribute value of each field, and cannot be modified.

Related introduction:

A view is a virtual table derived from one or more basic tables (or views). Only the definition of the view is stored in the data dictionary of the system, and the corresponding data of the view is not stored.

A view is a transformation of the original database data and another way to view the data in a table. You can think of the view as a moving window through which you can see the data of interest. Views are obtained from one or more actual tables whose data is stored in the database. The tables used to generate the view are called the base tables for that view. One view can also be generated from another view.

The definition of the view is stored in the database, and the data related to this definition is not stored in the database. The data seen through the view is stored in the base table.

The view looks very much like the physical table of the database and operates on it just like any other table. When you modify data through a view, you are actually changing the data in the base table; conversely, changes in the base table data are automatically reflected in the view generated by the base table. For logical reasons, some views can modify the corresponding base table, while others cannot (only query).

This is the answer to the question about what can be done in the Datasheet view. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.