Click the "Query" button to query the author information of three or more books published in the BOOKAUTH database. The inquiry information includes: the author's name and city; The query results are saved in the table NEWVIEW in ascending order of author's name. The solution is as follows:

1, build a database.

You can add free tables to a database in Project Manager or Database Designer. In Database Designer, you can select Add Table from the database menu or the right-click menu, and then select a free table to add to the current database in the open dialog box. You can also use the Add Table command to add a free table to the current database.

2. Open the database designer, right-click the table to be indexed in the database menu or database designer, and then select Modify in the pop-up menu.

3. Create an index on the index page in Table Designer.