/text/shared/01/05340400.xhp

data source browser tables in databases;browsing and editing databases; editing tables editing; database tables and queries queries; editing in data source view mw deleted "database tables," and changed "tables in databases;" Data Sources This section contains information on browsing and editing database tables.

You cannot use the data source browser on a database table that is open in Design view. Data source browser The commands for the data source browser are found on the Table Data bar and in context menus. Selecting records To select a record in a database table, click the row header, or click a row header, and then use the Up or Down arrow keys. Select database records. Drag-and-drop rows or cells to the document to insert contents. Drag-and-drop column headers to insert fields. The following table describes how to select individual elements in the data source browser: Selection Action Record Click the row header Several records or removing a selection Hold down CommandCtrl and click the row header Column Click the column header Data field Click in the data field Entire table Click the row header of the column headings Table Data toolbar (editing table data) Icon Allows you to edit, add, or delete records from the database table.removed 3 ancient paras Cutting, copying and pasting data You can cut, copy, and paste records in Data Source view. The Data Source browser also supports the dragging and dropping of records, or text and numbers from other $[officename] files. You cannot drag and drop to Yes/No, binary, image, or counting table fields. Drag and drop only works in Edit mode. Navigating in the Data Source Browser Use the Form Navigation bar at the bottom of the Data Source view to navigate between different records. First record Icon Go to the first record in the table. Previous record Icon Go to the previous record in the table. Record number Type the number of the record that you want to display, and then press Enter. Next record Icon Go to the next record in the table. Last record Icon Go to the last record in the table. New record Icon Inserts a new record into the current table. To create a record, click the asterisk (*) button at the bottom of the table view. An empty row is added at the end of the table. Number of records Displays the number of records. For example, "Record 7 of 9(2)" indicates that two records (2) are selected in a table containing 9 records, and that the cursor is in record number 7. Organizing tables To access the commands for formatting the table, right-click a column header, or a row header. Table Format Row Height Column Format Column Width