Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50. 5.1.2 Change the format of the GalleryName field to always display the data in uppercase. 5.1.3 The PostCode field should always contain four digits, e.g. 0001, 0235, 1245. Change the PostCode field properties so that it will always accept and display ONLY four digits. 5.1.4 The stock in the gallery should be insured for 25% more than the total value of the stock (TotalValue). Insert a new field named 'Insure' with a calculated data type to determine the insured value of the stock. NOTE: Ignore the format of the new field. Save and close the tblExhibit table.

NSC Computer Application Technology Information management: Open the tblExhibit table in Des

Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50 - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

Question 5

Open-the-tblExhibit-table-in-Design-View-and-do-the-following:--5.1.1-Change-the-City-field-size-to-50-NSC Computer Application Technology-Question 5-2019-Paper 1.png

Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50. 5.1.2 Change the format of the GalleryName field to always d... show full transcript

Worked Solution & Example Answer:Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50 - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

Step 1

5.1.1 Change the City field size to 50.

96%

114 rated

Answer

In Design View, select the City field and change its Size property to 50. This ensures the field can accommodate longer city names.

Step 2

5.1.2 Change the format of the GalleryName field to always display the data in uppercase.

99%

104 rated

Answer

Select the GalleryName field and set the Format property to 'Uppercase'. This will ensure that any inputted data is displayed in uppercase letters.

Step 3

5.1.3 The PostCode field should always contain four digits.

96%

101 rated

Answer

Change the data type of the PostCode field to 'Short Text' and set the Input Mask to '0000' to enforce four-digit entries. Ensure that the validation rules are added to restrict the input to exactly four characters.

Step 4

5.1.4 The stock in the gallery should be insured for 25% more than the total value.

98%

120 rated

Answer

Add a new field called 'Insure' and set its data type to 'Calculated'. Use the formula:

$Insure = TotalValue * 1.25$

This calculation ensures the insured value reflects 25% more than TotalValue.

Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50 - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

Worked Solution & Example Answer:Open the tblExhibit table in Design View and do the following: 5.1.1 Change the City field size to 50 - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

5.1.1 Change the City field size to 50.

5.1.2 Change the format of the GalleryName field to always display the data in uppercase.

5.1.3 The PostCode field should always contain four digits.

5.1.4 The stock in the gallery should be insured for 25% more than the total value.

Join the NSC students using SimpleStudy...