Datasheets

There are many things that you can do with Datasheets in SchoolPRO:

imgDatasheet

TIP: Right clicking on the Datasheet will popup the Context Menu seen above

Change column widths by clicking on the vertical line in the header between 2 columns and dragging it left or right.
TIP: If you double click the vertical line the column will expand to the size of the widest field
Select all the records by clicking the empty square in the top right hand corner
Select a column by clicking the relevant header

Context Menu

Select a column and click Sort Ascending on the Context Menu will sort that column in alphabetical or numerical order
Select a column and click Sort Descending on the Context Menu will sort that column in reverse alphabetical or numerical order
Select record(s) and click Filter by Selection to view only that record(s)
Select Records(s) and click Filter Excluding Selection to view all the unselected records
Select a field and type in text in Filter For and press Enter to view all those records that text in the field
To remove a filter or un-sort a column click Remove Filter/Sort
To go to the first record click
To go to the last record click
To add a New Record click on a non-read only datasheet
To delete a Record click on a non-read only datasheet
To hide or unhide a column click unhide columns... and then tick and untick the columns you would like to hide or make visible
To Freeze Columns select the column you want to freeze and click Freeze Columns
NOTE: you would freeze columns to keep column labels visible as you scroll left and right
To unfreeze columns click Unfreeze All Columns
To change the way the grid is shown on the datasheet move your mouse over the to the right of Grid and choose the way you would like the grid to appear
To go to a specific field click the Go To Field: drop down button and select the field you want to go to from the drop down list.

Your browser does not support inline frames or is currently configured not to display inline frames.