As updating an ms access db
You can add records to a table by using the datasheet view of the table or by inputting them from a form view.Before you can add records to the table, you need to open it.No additional driver installation is needed with this variant.However, should you prefer to use the 64-bit Flow Heater variant without an Office/Access installation, or you need to process Access .When you are in the datasheet view, you just need to go to the end of the table and click in any of the fields to begin the record.Top of the Page There will be times that you need to find records based on specific values in a field. When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.You can select multiple tables by holding down the Update Query from the popup menu.
Actually I am trying to update the Bot table MFG with the Big table MFG when Big. In this example, we've selected the Big and Bot tables.The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation.You will save yourself time, and eliminate the possibility of manual errors.Make sure that your cursor is in the field that you want to search on and then click the Find button.
The Find and Replace dialog box will appear as shown in Figure 3-07 in your book and you will be able to type in the value that you want to locate.
I also wanted it so I could make a new record by filling out the form, and hitting the new button.