5.1 Open the tbl5_1 table in Design View. 5.1.1 Change the field size for the Name field to 20. 5.1.2 Insert an appropriate validation rule for the StartDate field that matches the validation text. 5.1.3 Create an input mask for the AccessCode in the following format: - TWO compulsory letters, followed by - The @ sign, followed by - At least THREE, but possibly FOUR digits 5.1.4 Create a combo box for the Position field with the following options: - Manager - Administrator - Accountant 5.1.5 Insert a new field called IDPhoto and set an appropriate data type for the field. Save and close the tbl5_1 table.

NSC Computer Application Technology Information management: 5.1 Open the tbl5

5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2022 - Paper 1

Question 5

5.1 Open the tbl5_1 table in Design View. 5.1.1 Change the field size for the Name field to 20. 5.1.2 Insert an appropriate validation rule for the StartDate field... show full transcript

Worked Solution & Example Answer:5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2022 - Paper 1

Step 1

5.1.1 Change the field size for the Name field to 20.

96%

114 rated

Answer

In the design view of the tbl5_1 table, locate the Name field. Modify its field size property to 20 characters to ensure it accommodates the expected input.

Step 2

5.1.2 Insert an appropriate validation rule for the StartDate field that matches the validation text.

99%

104 rated

Answer

For the StartDate field, set the validation rule to ensure it only accepts dates on or after 15/03/2012. The validation rule can be expressed as:

>= #15/03/2012#

This ensures that invalid dates are rejected.

Step 3

5.1.3 Create an input mask for the AccessCode in the following format:

96%

101 rated

Answer

To create the input mask for the AccessCode, set it to require two letters followed by the '@' sign and then three to four digits. The input mask can be defined as:

LLL0000;0;_

This will enforce the desired structure of the AccessCode.

Step 4

5.1.4 Create a combo box for the Position field with the following options:

98%

120 rated

Answer

For the Position field, create a combo box that presents users with three options: Manager, Administrator, and Accountant. Set the Row Source Type to 'Value List' and list the options in the Row Source property appropriately.

Step 5

5.1.5 Insert a new field called IDPhoto and set an appropriate data type for the field.

97%

117 rated

Answer

In the tbl5_1 table, add a new field titled IDPhoto. Set its data type to 'OLE Object' or 'Attachment' to accommodate potential file uploads, such as images.

5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2022 - Paper 1

Worked Solution & Example Answer:5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2022 - Paper 1

5.1.1 Change the field size for the Name field to 20.

5.1.2 Insert an appropriate validation rule for the StartDate field that matches the validation text.

5.1.3 Create an input mask for the AccessCode in the following format:

5.1.4 Create a combo box for the Position field with the following options:

5.1.5 Insert a new field called IDPhoto and set an appropriate data type for the field.

Join the NSC students using SimpleStudy...