Creating a user interface to connect to database (MSAccess or Visu

[pavski]

I am trying to decide how to go about developing an application for a small
investment advisory business.

I anticipate needing a user interface that is reasonably slick e.g being
able to click on results from searches to take user to more detailed data.

Would anyone be able to tell me what limits there are in MSAccess 2007 to
the kind of interfaces you can develop.

Appreciate your help.

Best regards,

P

 

[Allen Browne]

I am trying to decide how to go about developing an application for a small
investment advisory business.

I anticipate needing a user interface that is reasonably slick e.g being
able to click on results from searches to take user to more detailed data.

Would anyone be able to tell me what limits there are in MSAccess 2007 to
the kind of interfaces you can develop.

The limits are probably defined by your imagination, your understanding of
SQL, and your ability to write VBA code.

Here's an example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The article includes a free downloadable sample database that illustrates
how to create the search/filter string for various data types, discrete
values, partial matches, and ranges.

Beyond that, is is also possible to include a subquery in the filter string,
so as to include or exclude those records that have a match in a related
table. There's a screenshot of a powerful (though not pretty) multi-tab
search form at the end of this article of subqueries:
http://allenbrowne.com/subquery-01.html#Other