A 'fancy' form is so named because you can be as elaborate and fancy with its design as you wish. With the 'Simple Form', the variables must be in Column A and the data you wish to export to a data record must be in Column B. With 'fancy forms' the data, the captions, the validation and look-up tables can be anywhere.
The 'drawback' (if that is a proper term) is that the name for the Instant Database variable does not derive from a list of variables in Column A. Rather, variable names derive from the names that you have assigned to the various cells which contain the variables' values.
Its 'strength' is everything else. Because you are not limited in where you place any data-carrying cell, you have much more flexibility in the design of your forms. The user input can occur in any cell and the label that introduces a cell can be as descriptive as you want (both in terms of text, of layout, of indenting, or spacing). There are simply no design constraints.
If you are likely to use Excel for generating your Instant Database records, you will likely adopt this second method.
The remainder of this section of the manual will be focused on the creation and design of 'fancy' forms.