Need to change user interface so navigation of tables is easier

[Guest]

I am currently maintaining a database which is being reviewed and updated by
many users. Due to the number and length of the fields in the database,
navigation of the table involves scrolling over almost 3 screen-lenghts to
move from the first field to the last. Is there a way to change the
interface of the table so that the interface is more streamlined?
(collapsable columns, etc) I've searched through the documentation and tried
the different views/formats but nothing seems to give me the results I'm
looking for.

Any suggestions on how I can get this working better would be very much
appreicated.

- Andrew

 

[Guest]

One way is to build a form with only those fields needed for a given operation.

 

[Guest]

A form looks like it should work well for what I'm doing as it streamlines
the presentation of a single record. However, it appears that the form is
best suited for adding new records whereas I need to be able to find specific
records as well as filter and sort them based on field criteria. Would a
form work well for performing these operations as well?

 

[Guest]

I worked with the form for a bit and found it to do everything I need. Thanks
for the suggestion!

 

[Larry Linson]

Yes, most database application developers never give users direct access to
Tables or Queries because there are so many things the user can, advertently
or inadvertently, do wrong. Forms and Reports can do everything necessary to
present data to users, and to allow data entry and update.

Larry Linson
Microsoft Access MVP