Seek to use excel functions and formulas to create a student records query system is mainly a query picture description

1. in excel, the establishment of the storage of pictures worksheet;

2. in the "picture" worksheet insert the corresponding picture, set the picture format, the picture attributes set to "size, position with the cell and change", the picture and name correspond to each other;

3. insert the "name", the query system is mainly to query the description of the picture. and the name of a one-to-one correspondence;

3. Insert the "name", the name of the query system will need to query the location of the cell and the picture of the establishment of a link (you can use the offset and match function to define the name, assuming that the definition of "picture

4. In the data query interface to display the location of the picture, insert the "Command Button" control, set the format of the button, so that the size of its size and the size of the picture to match;

5. Click on the Command Button, in the Edit column will be the original content ("=EMBED"). "=EMBED("FORMS.COMMANDBUTTEN.1","")") to the defined name, "=Picture";

6. Enter the name of the query picture, the picture can be displayed according to the entered name is displayed.