Create Empty ``Shell'' Rows

First, we need to create empty shell rows in the MySQL ``pollutants'' table. This can be done with an ``append query''. Create a new query in design view. Add the table ``Combdata'' and close the table view. Specify ``Append Query'' under the ``Query'' menu. Select ``pollutants'' as the table to append to. Then click the sigma button so the query is also grouped. See the following screen for a general idea:

``Expr1'' has a definition that is identical to the one listed in subsection 2.1.

Close the query, give it a name and save it. Open this query to let it create the shell rows. This step may take a few minutes, depending on the speed of your machine.

During this process, you can safely switch MySQL Control Center and double click the ``pollutants'' table. It will display the current contents.

At the end of the process, click ``Yes'' to confirm that you want to append the rows.

Switch back to the ``Tables'' tab of Access. If you open the ``pollutants'' table, you should see the empty shell rows.