First select a table or Access query from the pulldown list. Click on the button Use Selected Table. If a list of tables does not appear, return to the Database property sheet and make sure the path to the database is defined correctly. Next, under Query Type , choose Insert, Select, or Update. Insert queries allow data to be added to the database.
Select queries allow searching of the database.
Update queries allow records to be updated. Check those fields to use in the connection for adding, searching, or updating. The values of the fields will be passed from the Web form. In the next two sections are shown examples of how values passed in a Web form are used in the Query Edit and Format property sheets. After selecting all the fields needed, click the Save Changes button.