Access has two main methods to create queries. One is to create a query through a wizard, and the other is to create a query through a design view. The simplest and most common method is to select a query.

No matter what you do, you must have basic materials, that is, basic data.

Create query comments:

Import LSTEUTRANINTRAFREQNCELL.csv into the newly created Access database file, and pay attention to the types of some fields, such as mobile network code.

The setting of the primary key, although the primary key is a very important setting, is not set for the time being because the general primary key is composed of multiple fields, and only one can be selected here, so as to avoid misleading and adding trouble.

Import table name definitions. For the convenience of querying the table name reference at design time, the table name imported into the table interface is changed to EUTRANINTRAFREQNCELL.

Import of existing cells in the grid. . There are fewer existing cells in the xlsx file grid. Copy the title and content directly, and then open the Access file in the same frequency neighborhood and paste it directly.

Extended data:

Please note when importing Access design view:

During the import process, the imported file cannot be opened.

If an access file is imported into two adjacent areas, the access file will exceed the size limit of 2G and an error will occur. Therefore, it is suggested to import oversized data into different Access library files, and then link tables in other libraries in one of them to avoid frequent errors caused by file overrun.

If the Access file is too large or even too large after frequently adding or deleting data, how to compress the Access file? Press the Office button-Manage-Compress to repair the database.

References:

Baidu Encyclopedia-Design View