How can I see how many records there are for each field in our FIMS database?

For each field, go into FIMS Database and File Viewer, load a table, right-click on a field and choose View Value Counts. Note, you can then right-click on right screen to copy results to the clipboard.

For each table for moving off of FIMS. There is no utility we have that gives that information however a way to do that is to use Extract Data for RE and/or FE Conversion to dump the data then open up the files and see what the last record is.