Office 2007 Professional Plus WYSIWYG Form Authori

[sangma43]

Last week we checked out the WYSIWYG report authoring resources, this week we'll get a look and feel with the identical sorts designer. Since types generally don't repeat like reports do this designer looks more like the old form authoring instruments than the report designer did, but it is still noticeably quicker and easier to use. Authoring
Like the report designer, the core of the new varieties authoring resources is the ability to see live data at design time. This makes it easier to tell what the user's experience of the form will be. In addition, there are some new concepts, also shared with reports, that make control layout easier. We'll go into this below. To get started with the new sorts tools, though, the easiest way is to use Quick Create, just like for reports. The user simply selects the data source in the nav pane, then goes to the Create tab and selects "Form": creates a basic form and displays it in the design using "Layout View" or the new WYSIWYG design view. Like reports, the new form shows all of the fields in the underlying data. image to enlarge) just like with reports, it is simple for the user to select and delete unwanted fields from the form. In this case the user deletes the control showing the ID column, since this is created by Access's AutoNumber functionality. image to enlarge) much like in reports, fields can be easily moved by drag and drop. Here the user selects a field and drags it up in the form. She sees an I-bar showing where it will land when she drops it. image to enlarge) she drops the field,Microsoft Office Enterprise 2007 Activation Key, the other controls are moved down and it is inserted into the new space. created types have a header area in the top, and it is easy for the user to customize this. She can simply edit the title by clicking and typing,Windows 7 Enterprise Activation Key, may replace the image, or can easily add a date / time stamp. In this case,Office 2010 Home And Business Serial, she adds the date by clicking on the ribbon. displays a dialog allowing the user to select a format for the date. the date is inserted in the form's header (note that I shrunk the header horizontally so it would display - it will be right aligned on the form). with Layouts
Access 12 has introduced a new control-grouping concept called "layouts" that provide the control flow shown above. When you move controls around then can snap into position and the other controls can reflow because the controls are all aware of their relationship to one another, and that is done through Layouts. In the image above, you can see the selector widget to the upper left of the word Title - this allows you to select the layout and to see which controls are included in that layout. Layouts make common functionality like more and resize much easier, but since they govern where controls may be moved, they may prevent you from creating certain kinds. To make sure that you get the benefits of layout but don't lose flexibility, we've made it easy to edit or remove layouts as needed. To get a specific control and make it float, all that you need to do is select it and choose "Remove" from the "Layouts" chunk on the "Layout" ribbon. image to enlarge) leaves the control on the form, but simply removes it from the layout. It can then be dragged around and formatted as desired. In this case, the user drags it next to the current column of controls: image to enlarge) grows it so that it fills the whole length of the form. image to enlarge) of controls can be moved to a new layout in one step as well. This makes it easy to consider a long one-column form for example and make it into a wider two-column form. To do this, all that you needs to do is select the controls from the first layout and select "Stacked" from the Layouts ribbon. to enlarge) creates a new layout and moves the controls into it: layout can be easily dragged around by clicking on the selector in the upper left corner. In this case, it is being moved from the bottom of the long form to the empty space on the right-hand side. image to enlarge) the controls are in the new layout, they behave just like they did in the old one, and can easily be moved, resized, and so on. In the example below, the user is resizing the comments field to even up the column lengths. final form looks like this: image to enlarge) Sorts
Access 12 has added split types as a new form type. Split kinds combine a datasheet, for bulk data viewing & entry with a single-item form for ease data manipulation. Split types can be created from the Create ribbon in a single click, and start looking like this: image to enlarge) a split form is just like editing a regular form or datasheet, and it is simple to drag & drop controls around inside either the mail layout: image to enlarge) between the two layouts (in this case a second layout was automatically created to provide a two-column form and to prevent scrolling in the single-item form. image to enlarge) is the Comments field after being dropped into the righ-hand column. image to enlarge) Item Kinds
Multi-item kinds can be created in one click as well, and also use Layouts for control positioning. Building a multi-item form creates a datasheet that can be edited, and with a "new item" row at the bottom that can be used to add new records. image to enlarge) course it is simple to resize the columns in a multi-item form by dragging: is easy to move columns around,Microsoft Office 2010 Professional, again simply by selecting them and dragging: I-bar with the left shows where the column will be dropped: of course all the other columns are moved to the right to make space after the column is dropped in. Sorts
The "More" button in the "Forms" chunk on the Create ribbon provides the ability to create datasheets, modal dialogs, and to launch the Form Wizard that is familiar from earlier versions of Access. creates a simple grid form, similar in concept to the Multi Item form above, but closer in appearance to Excel. Again, there is a "new item" row with the bottom for adding data. image to enlarge) Text In Access Varieties
Access 12 now provides a rich text control, and allows users to both display and edit rich text at runtime. Rich text support can be turned on through the property sheet or rich text fields can be added to a form through the Add Field task pane. the user can format text, either using the "floaty" (I'm sure this has another name, but I don't know what it is!) or by using the font formatting controls in the Access ribbons. image to enlarge) Week
Next, we'll start a pass through the Sorting, Filtering,Office 2007 Professional Plus, and Grouping functionality in Access 12.