Photo AI
Open the 5ArtWorld database, which contains details of artists and paintings - NSC Computer Application Technology - Question 5 - 2018 - Paper 1
Question 5
Open the 5ArtWorld database, which contains details of artists and paintings. Open the tblPaintings table in Design View. 5.1.1 Change the format of the Painting f... show full transcript
Worked Solution & Example Answer:Open the 5ArtWorld database, which contains details of artists and paintings - NSC Computer Application Technology - Question 5 - 2018 - Paper 1
Step 1
5.1.1 Change the format of the Painting field
Answer
To change the format of the Painting field to display in capital letters, access the field properties of the tblPaintings table in Design View. Locate the Painting field and set its format property to 'Uppercase' or ensure the input mask enforces capital letter display.
Step 2
5.1.2 Change the field properties of the YearPainted field
Answer
For the YearPainted field, navigate to the field properties and set the validation rule to the following:
>=1494 AND <=1970
OR >1494 AND <1971
OR BETWEEN 1494 AND 1970
OR (YearPainted>=1494 AND (YearPainted<=1970))
The validation text should indicate that the year must be between 1494 and 1970.
Step 3
5.1.3 Create an input mask on the ID field
Answer
To create an input mask on the ID field, set the input mask to 'IMP*09' which allows:
- 'IMP'
- any compulsory character or space
- a compulsory number from 0 to 9
- followed by up to two optional numbers. Ensure you validate proper examples like IMP 3 or IMP#12.
Step 4
Step 5