access wizard

[Guest]

How effective are the Forms generated by Access for doing the things you want
in interactive applications? ie, if you were building an end user application
with Access, would the Forms generated by Access using the wizards allow you
produce some or all the functionality you wanted and, if so, how much?

Thanks

 

[John Spencer]

They work and can be a good starting point for building more complex forms.

The wizard forms are very generic and do what they are designed to do, but
in my opinion they are also limited.

Are they good enough? It depends on
-- how much you want to rely on the skills of the people using the database
-- the complexity of the tasks to be accomplished on the form

I frequently use a wizard as a starting point, but then do extensive
modifications to the forms. Adding complex data validation, calculated
default values (default value is dependent on other data entered in record),
etc.