Accessing database tables from the program allows you to create, modify, and search records.
Add a New Database Record
- In the Data View window, right-click a record header (the empty square at the left of the row). Click Add New Record.
A new record with blank field values is added to the end of the current record set.
- Select a cell in the new record and enter a value.
- Repeat step 2 for any additional fields.
Edit a Database Record
- Select a cell to edit in the Data View window.
- Enter a new value in the cell.
- Repeat as necessary for any additional cells that you want to edit.
Tip: Use the keyboard arrow keys to move from cell to cell.
Delete a Database Record
- In the Data View window, right-click a record header (the empty square at the left of the row) of the record that you want to delete. Click Delete Record.
Search the Data View Window
- Right-click a cell in the column that you want to search. Click Find.
Click Replace, to replace found text.
- Enter a value to search for in Find What.
- Select a direction to search the Data View window:
- Up. Searches the column records from the selected cell through the first record.
- Down. Searches the column records from the selected cell through the last record.
- Click Find Next.
If replacing text, click Replace or Replace All.
- Repeat step 4 as needed.
Commit Data View Edits
Commit your edits to update the current database table and close the Data View window.
- In the Data View window, right-click the empty, top-left square of the database table. Click Commit.
Restore Data View Values
Restore the previous values to undo changes to the current database table and close the Data View window without updating the database.
- In the Data View window, right-click the empty, top-left square of the database table. Click Restore.
Note: Closing the Data View window, exiting the program, or opening a new database table automatically commits all changes you've made during an editing session.