Wednesday, November 2, 2016

Microsoft Access : Find and append records to a table in the current database



How to append records to a table in the current database :
  1. On the External Data tab, click the command for the data source you want to import.
  2. In the Get External Data dialog box, click Append a copy of the records to the table, and then select the table you want to append records to.
  3. Click Browse to locate the file with the source data, and then click OK.
  4. Follow the steps in the import wizard (if Access provides one) to import and append the data.
  5. In the Get External Data dialog box, select Save import steps if you want to save the steps in this operation.

How to find records :
  1. In the Navigation pane, double-click the table to open it in Datasheet view.
  2. On the Home tab, click Find.
  3. In the Find and Replace dialog box, enter the text you want to find in the Find What box.
  4. In the Look In list, select Current field or Current document(which refers to the entire table).
  5. In the Match list, select Whole Field, Any Part of Field, or Start of Field.
  6. In the Search list, select All, Up, or Down.
  7. Select Match Case to perform a case-sensitive search.
  8. Select Search Fields As Formatted if you want to search the data as it is formatted in the datasheet.
  9. Click Find Next.

No comments:

Post a Comment