Practical Programming

Question 0

What are the requirements of forms used to capture data?

Answer 0

• The screen layout should have fields in a natural order
• The screen should not be cluttered
• Novice users should be able to see where to go next and what to enter
• There should no be too many options

Question 1

What are the 3 requirements of a good interface?

Answer 1

• The layout should be natural to use
• Screens should allow easy navigation
• Few colours should be used

Question 2

What does the Lcase function do?

Answer 2

This function changes all the letters in a string into lower case letter, making them easier to deal with. This is useful for string manipulation

-How it’s used: Lcase(string)

Question 3

What are the data validation techniques?

Answer 3

• Presence check. Checks if the data if present, has it been filled in
• Length check. Checks if the data is of a reasonable length, ensuring it has gone past a limit
• Format check. Checks if the data is in the correct format, e.g. Date format, DD/MM/YY
• Range check. Checks if the data is in the correct range, e.g. Age should be in the range 18 - 25