How To append records to a table in the current database
- On the External Data tab, click the command for the data source you want to import.
- 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.
- Click Browse to locate the file with the source data, and then click OK.
- Follow the steps in the import wizard (if Access provides one) to import and append the data.
- 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
- In the Navigation pane, double-click the table to open it in Datasheet view.
- On the Home tab, click Find.
- In the Find and Replace dialog box, enter the text you want to find in the Find What box.
- In the Look In list, select Current field or Current document(which refers to the entire table).
- In the Match list, select Whole Field, Any Part of Field, or Start of Field.
- In the Search list, select All, Up, or Down.
- Select Match Case to perform a case-sensitive search.
- Select Search Fields As Formatted if you want to search the data as it is formatted in the datasheet.
- Click Find Next.
No comments:
Post a Comment