Homework – Input Mask
1 Add an input mask to the SecretCode field to ensure that the user must input two numbers
between 0 to 9, followed by a separator of a dash (-) and then two letters must be entered.
(3)
2 The Code field must follow a specific format. Use the example format given below, showing
letters, numbers and case. Ensure that data entered into the Code field follows this format
exactly. Example format: AB-025, NM-02, VW-023 5.3 (4)
3 Create an input mask for the user to enter data in the following format:
• Lowercase letters
• The first character is a full stop (.), followed by
• TWO compulsory letters, followed by
• ONE optional letter
NOTE: The full stop must display when a record is selected.(4)
4 The GPS1 field should indicate the first part of the GPS position (i.e. the latitude) of each
Wonder, e.g. 48.8566°N. An input mask for the GPS1 field has been created, but not
completed. Complete the input mask to accept data as follows:
• ONE optional digit or space, followed by
• ONE compulsory digit, followed by
• A full stop ('.'), already given in the data, followed by
• FOUR compulsory digits, followed by
• A degree symbol ('°') (ALT+0176), already given in the data, followed by
• ONE compulsory letter (4)
5 Create an input mask on the ID field to ensure that the user inserts a painting ID in the
following format:
• The letters 'IMP'
• Followed by any compulsory character or space
• Followed by a compulsory number in the range 0 to 9
• Followed by TWO optional numbers
Examples of a valid ID: IMP@4, IMP$34, IMP 78 or IMP#135 (4)