• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Microsoft Forms > When to Use Forms Instead of Standard Screen Compo...

When to Use Forms Instead of Standard Screen Components

Even though forms are available to any core Office product, they are best used with Word or Excel. The reason: these two products have no alternative form creation component. (Excel does have a limited form feature for simple repetitive entry.) Access has a great form designer, and therefore gains little by using the Microsoft Forms library. Outlook, too, has form designer capabilities, although Outlook forms have a limited programming model. Outlook can make use of user forms in the situations where Outlook forms do not provide enough power. PowerPoint presentations are usually informational and therefore have little use for the interaction provided by forms.

Consider how Excel can benefit from forms. Unless specifically protected, Excel's open structure gives users the ability to enter text, numeric data, and graphics anywhere within a workbook. Even when limitations are set via workbook or worksheet protection, the means to validate data on the fly is not great.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint