8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer. 8.2 Your friend generated a spreadsheet for stationery items sold to a customer. Study the screenshot below and give TWO reasons why the function returns zero. 8.3 Microsoft Access provides field property settings such as validation rules to improve the accuracy of data capturing. Name TWO other additional field properties that can be used. 8.4 Name a word processing feature which will force certain text to move to the beginning of the next column. 8.5 Briefly explain the criteria of the following validation rule: =5 8.6 The following criteria appears for the Username field in a database query: Like "??an?" Explain the output of this query. 8.7 Examine the piece of HTML code below, which is used to insert the image on the web page: What effect will the missing height attribute have on the image? 8.8 Give ONE reason why you would use the button in the image below in an Access database table.

NSC Computer Application Technology Information management: 8.1 Discuss TWO reasons why you

8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer - NSC Computer Application Technology - Question 8 - 2023 - Paper 2

Question 8

8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header... show full transcript

Worked Solution & Example Answer:8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer - NSC Computer Application Technology - Question 8 - 2023 - Paper 2

Step 1

Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer.

96%

114 rated

Answer

Repetition of Information: Page headers and footers are used to repeat information at the top and bottom of every page, making it easier for readers to navigate the document.
Document Description: They provide a description of the document content, which can be useful for identifying the title, author, or date.

Example of information included: The header could include the title of the document, while the footer could contain page numbers.

Step 2

Give TWO reasons why the function returns zero.

99%

104 rated

Answer

Incorrect Cell Range: The function could be trying to sum or count values from an incorrect range, such as using B7:B13 instead of C7:C13.
Column B Contains Text: If column B includes non-numeric text, functions like SUM or COUNT will return zero for that range.

Step 3

Name TWO other additional field properties that can be used.

96%

101 rated

Answer

Input Masks: This property helps to control how data is entered by users, ensuring it adheres to a specified format.
Default Values: This property allows for a predefined value to be automatically filled in the field unless changed by the user.

Step 4

Name a word processing feature which will force certain text to move to the beginning of the next column.

98%

120 rated

Answer

The feature is called a Column Break, which allows you to control the flow of text between columns.

Step 5

Briefly explain the criteria of the following validation rule: <0 or >=5

97%

117 rated

Answer

This validation rule restricts the input of numbers such that any number less than 0 (negative numbers) or any number equal to or greater than 5 is considered valid. Therefore, values ranging from 0 to 4 are not permitted.

Step 6

Explain the output of this query.

97%

121 rated

Answer

This query outputs a Username that is structured as follows:

Must start with 2 characters.
The third character must be 'a'.
The fourth character must be 'n'.
The fifth character can be anything (denoted by '?').
The length of the username must be either the exact length of 5 or 6 characters.

Step 7

What effect will the missing height attribute have on the image?

96%

114 rated

Answer

The missing height attribute will result in the image resizing proportionally to maintain the aspect ratio. This may cause distortion based on the inherent dimensions of the image.

Step 8

Give ONE reason why you would use the button in the image below in an Access database table.

99%

104 rated

Answer

The button can be used to show/hide column totals, allowing users to quickly view summary information of fields by using a total function like SUM, AVERAGE, COUNT, etc.

8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer - NSC Computer Application Technology - Question 8 - 2023 - Paper 2

Worked Solution & Example Answer:8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer - NSC Computer Application Technology - Question 8 - 2023 - Paper 2

Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer.

Give TWO reasons why the function returns zero.

Name TWO other additional field properties that can be used.

Name a word processing feature which will force certain text to move to the beginning of the next column.

Briefly explain the criteria of the following validation rule: <0 or >=5

Explain the output of this query.

What effect will the missing height attribute have on the image?

Give ONE reason why you would use the button in the image below in an Access database table.

Join the NSC students using SimpleStudy...