Need help transferring skills from FileMaker Pro to Access

[Hughie]

Have been an intermediate user of FMP for years. Want to learn to do the
same things in Access. I think I've got the basics of Access. Anyone out
there with knowledge of both Access and FMP? Would love to chat. Thanks in
advance.

 

[Ken Snell [MVP]]

I've done work with FMP Pro 7. I definitely prefer ACCESS for development
environment.

 

[John Vinson]

Have been an intermediate user of FMP for years. Want to learn to do the
same things in Access. I think I've got the basics of Access. Anyone out
there with knowledge of both Access and FMP? Would love to chat. Thanks in
advance.

I've done much more in Access than in FMP, but I'm acquainted with it.

One warning up front: they are very different programs, in structure
and in concept. Access is, IME, more fully relational than FMP; for
instance you'll make MUCH more use of SQL and multitable queries than
is typical in FMP. Your tables will *NOT* contain lookup fields or
calculated fields; these oprations are done in Queries instead. And
your approach to building forms and reports will have to be rethought
from scratch - they are utterly different, and "unlearning" the way
"things are always done" will perhaps be harder than learning the
Access approach!

Please don't hesitate to post back with specific examples.

John W. Vinson[MVP]

 

[Hughie]

Thanks John,
For my immediate project, I'd like to show a data access page that has these
things: multiple rows of fields and also multiple records showing at the same
time. This may be a "rethink the form" problem. Ideas are appreciated.
Thanks.

 

[John Vinson]

Thanks John,
For my immediate project, I'd like to show a data access page that has these
things: multiple rows of fields and also multiple records showing at the same
time. This may be a "rethink the form" problem. Ideas are appreciated.
Thanks.

I'm much less familiar with Data Access Pages than with Access forms,
so I may not be the right person to ask; but a continuous Form can do
exactly what you describe.

John W. Vinson[MVP]

 

[Ken Snell [MVP]]

I have worked with Data Access Pages... very limited in many respects and a
bit quirky. They do show "multiple records" with expandable/collapsible "+"
and "-" "buttons", and as such are "similar" to the normal "continuous
forms" view in ACCESS.

If you want to navigate from a record to another data access page to show
more info about that record, you have some limitations but it's doable.

--

Ken Snell
<MS ACCESS MVP>