136. Enter Data in List View
135 Create a Database 139 Enter Data Using a Form After creating a table in Base, you can enter data into it in one of two ways. For a table that contains simple data, you can enter information in List view. List view looks remarkably like a Calc sheet, as described in 38 About Sheets and Spreadsheets . In List view, the fields in your table are displayed in individual columns; as you add records to the table, each record is displayed in its own row. The other method you can use to enter data into a table is to use a form, as described in 139 Enter Data Using a Form .
| 1. | Click Tables To add data to a table, you must first open the table. Click the Tables icon in the Database pane. A list of tables in the current database appears on the right side of the Base window. |
| 2. | Double-Click Table In the Tables list, double-click the table you want to add data to. The table is opened in List view, ready for you to add data. On the Navigation toolbar at the bottom of the screen, the current record number is displayed, along with a total of the records in the table. |
| 3. | Enter Data in Record The first empty row in the table is marked with a yellow asterisk on the left. The current row is marked with a green pencil icon on the left. If needed, click in the first field (column) of the first empty row (record). [View full size image] ![]() A field in a table that's automatically filled in a value that increases with each new record. Typically, the primary key is set up as an auto value. |
| 4. | Press Tab to Begin New Record To begin a new record, press Tab . The cursor moves down one row to the first field in the next row. Repeat step 3 to enter data into each field in the record and to add all the records you want into the table. |
| 5. | Close and Save the Table When you're done entering and editing table data, choose File, Close from the menu. A table is saved each time a record is completed (each time you press Tab to move to a new record/row), so most likely when you close your table, you won't have to save it. If you're prompted to save, click Yes. The table is saved and you're returned to the Base main window. |

