Displaying lots of data

NB6.0, VWP
I have a derby table with 100 fields.  Likely to have hundreds of records.  Two issues:
1)  How can I limit the displayed table component to only a few records and allow scrolling through the rest of the records?   Currently, the all records rendered, which is good, except the table automatically expands vertically to accommodate them - no scroll bars!(?)
2)  Even a reasonable subset of fields, say 10 (+ 3 to uniquely identify the particular row), would fill the width of most of my users' screens.  But then I have the other 90 fields to display somewhere/how - what to do?  I don't want a single table component with 100 columns!  Users would go nuts scrolling right, right, right...  I suppose, if #1 above has an answer, I could add additional table components, each with its own subset of fields - as long as all the table components stay in synch with what is selected in the first table component.  Just stack them one atop the other.  But perhaps someone has a better way???  

I get the feeling that the InsertUpdateDelete tutorial, from which I've patterned my development, isn't the best approach for "real world" applications that can have a lot of data.  
TIA,
Dave