Edit the tbSales table as follows: 5.1.1 Change the field size of the Make field to 70 - NSC Computer Application Technology - Question 5 - 2017 - Paper 1

In the design view of the tbSales table, find the Type field. Alter its properties to include 'SUV' as a new option in the drop-down list.

Select the SellDate field and set a validation rule that restricts entries to dates that are greater than or equal to today’s date. This can be done with a rule like >= Date(). An appropriate error message should also be defined for incorrect entries.

In the tbSales table, locate the Photo field and change its data type to OLE Object or Hyperlink, depending on what suits your needs for storing image links or binary data.

Set an input mask for the RegNumber field to enforce the desired format: Use a mask such as >LLL00<, where L represents letters and 0 represents digits. This ensures that all letters are uppercase, followed by two compulsory letters and at least one alphanumeric character.

Open the qry5_2 query, select the tbClients table, and include the Title field by dragging it into the query design grid.

Sort the qry5_2 query results by selecting the Surname field first for ascending order, followed by the Initials field.

In the qry5_3 query, create a calculated field named Balance with the formula: [SellingPrice] - ([Deposit] + [Paid]). This will subtract the total paid amount from the selling price.

Modify the properties of the SellingPrice field in qry5_3 to format it as currency and ensure it displays in rand.

In the qry5_4 query based on the tbCars table, set criteria for the Manufacturer field to include only 'Nissan' or 'Ford'. Additionally, apply a filter on the PurchasePrice field to limit results to values less than or equal to R100,000.

Open frm5_5 in design view and insert the image '50Id.jpg' into the form header section.

Drag the Colour field from the tbCars table onto the frm5_5 in the design view to display it on the form.

In the properties of the Popular checkbox on frm5_5, set the default value to No/False.

In the text box adjacent to the 'Function_Funksie' label on frm5_5, implement a calculation function to increase the PurchasePrice value by 10%. You can achieve this with the formula: =[PurchasePrice]*1.1.

Open rpt5_6 and adjust the page setup settings to change the report orientation from portrait to landscape.

In rpt5_6, add a second grouping layer based on the Year field to categorize your report data further.

In the report design view, create an aggregate function that sums the PurchasePrice for vehicles grouped by Manufacturer.