The length of a table is the number of records that the table retrieves from the database. You can check this length in two ways, by using Live Data mode or by using Preview.
To check the length of a table using Preview, follow these steps:
1. Select the table, and click 'Preview' in the toolbar. This opens the 'Preview' tab.
2. Click on the table preview. The information bar at the bottom of the page shows the number of records in the table.
To check the length of a table using Live Data, follow these steps:
1. Click the 'Show Live Data' button in the table title bar.
2. Open the 'Table Properties' dialog box.
3. Make sure the 'Max Rows' field is empty. (This ensures that there is no artificial limit on the number of records retrieved. However, limits can also be set by an administrator.)
4. Click 'OK' to close the 'Table Properties' dialog box.
5. Click the table title bar to select the table.
6. Consult the information bar at the bottom of the window (just above the tab).
The information bar displays the total number of records retrieved, as well as the record numbers currently being displayed. If the information display reads “maximum exceeded,” this means that Live Data mode is unable to display the full table. In this case, use the Preview method to assess the table length.
To rotate a table, right-click on the table's title row and select 'Rotate' from the context menu.
This creates a rotated copy of the table, which is linked back to the original table. In the rotated copy, each row of the original table becomes a column, and each column of the original table becomes a row. The first column of the original table is the column header row of the rotated table, and the column header row of the original table is the first column of the rotated table.