FormReportsInterfaceGuidelines for Sample DesignSlide 6Slide 7Slide 8Properties of TextBoxesSlide 10TextBox PropertiesExercisesDesigning Reports, Forms and the User InterfaceForm•A business document that contains some predefined data and may include some areas where additional data are to be filled in–An instance of a form is typically based on one database recordReports•A business document that contains only predefined data•A passive document used solely for reading or reviewing•Typically contains data from many unrelated records or transactionsInterface•A method by which users interact with information systems–Menus •List of options is provided and one option is selected by the user–Drop down menu–Function Key (or other key) selection–HELP•On-line documentation•Hard-copy documentationGuidelines for Sample Design•Types of Control on Forms–Textboxes •used for data entry–Picture boxes•used to present data that the user cannot re-access–Label boxes•Used for “captions”•Used to present data that the user can re-access –Remember the drop class example? –Need to re-access the course id/section if the user checks the drop box\–If the course id/section was printed in a picture box, user could not re-access it.Guidelines for Sample Design•Types of Control on Forms–List Boxes•Generally used for “one item” such as course id or name•Not recommend as an alternative to printing in a picture box•Advantages: –Data can be re-accessed by user»User highlights an item in the list–Scroll bars allows user to see all items in the list»Not true with picture box. If you print more in a picture box that the size and font permits, user will not be able to view it.Guidelines for Sample Design•Types of Control on Forms–Check boxes versus Option (radio) buttons•Check boxes – multiple boxes can be checked•Option (radio) buttons – only one can be checked–If you check a second one, the first one turns “off”Guidelines for Sample Design•Forms–Consistency•Labels such as QUIT/END•Location of command buttons•Error Processing–Label Control vs msgbox•Justification•Column/Row headings•Highlighting–Font Size–Intensity–Boxing–ColorProperties of TextBoxes•Validation of Input–Generally done through VB code–Can use some properties•MaxLength•DataFormat–Number of decimal places–Format of numbers–Dates•Tabs–Use the Tab Index property to determine the order of the fields to be keyedGuidelines for Sample Design•Report Issues–Sorting sequence–Page number–Date of report versus date of dataTextBox PropertiesExercises Critiquing Forms and
View Full Document