Dan Wilson wrote:
Does Access allow a more
convenient "data form" setup?
Convenient? Yes.
Intuitive, meaning anything like userforms or using cells on a
worksheet for data input? No.
Will my programming
knowledge of formulas in Excel be usable in Access?
Not directly. If you enjoy writing worksheet formulas then the chances
are you will enjoy writing SQL; array formulas are a natural
progression towards SQL's set-based mental model. However, the majority
of MS Access users let a GUI tool write SQL for them :(
Jamie.
--
|