16用sql语句进行以下查询查询外汇账户表中的日元信息（16 use the SQL statement for the following query query the yen information in the foreign exchange account table）.docVIP

16用sql语句进行以下查询查询外汇账户表中的日元信息（16 use the SQL statement for the following query query the yen information in the foreign exchange account table） Sixteenth sets I. Basic operation Complete the following operations in the candidate folder: 1., open the database foreign exchange, through the foreign exchange code field for foreign exchange code and foreign exchange account to establish permanent links; 2., build a project document called forex management, and add the database foreign exchange to the foreign exchange management project; 3. modify the MyMenu menu file for the submenu entry under the file, locate the access key F (show the way to find F), and generate a new menu program; 4. modify the SQL statement in one.prg to make it correct (the statements function is to delete the currency 1 from the rate table, the code is 14, and the currency 2 is a record of $27). Answer： First class 1., left click on the file, left click, open, file type, left click the database, left click foreign currency, and left click ok. 2. in database designer foreign exchange, right-click on the foreign exchange code table, and then click modify. In Table Designer - exchange code.Dbf, left click the index tab, index name input code type for the main index of foreign exchange, foreign exchange code left click OK expression input, click . 3. right click on the foreign currency account table, and then click modify. In the table designer foreign currency account.Dbf, right-click the foreign currency code field, modify the ascending order at the index at the back, click OK, and left click yes. 4. left click on the foreign currency code in the foreign exchange code table, and hold it down, then drag the mouse to the general index of foreign exchange account foreign exchange code, and then release the mouse. Second a. 1., left click on the file, left click new, file type, left click project, and left click New file. In the create dialog box, at project file, enter foreign exchange management, and c