8.1 What does the key symbol to the left of the database field show in the screenshot below?
ID
The field is a primary key - NSC Computer Application Technology - Question 8 - 2018 - Paper 2
Question 8
8.1 What does the key symbol to the left of the database field show in the screenshot below?
ID
The field is a primary key.
8.2 After the Show/Hide featur... show full transcript
Worked Solution & Example Answer:8.1 What does the key symbol to the left of the database field show in the screenshot below?
ID
The field is a primary key - NSC Computer Application Technology - Question 8 - 2018 - Paper 2
Step 1
8.1 What does the key symbol to the left of the database field show in the screenshot below?
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The field is a primary key.
Step 2
8.2.1 How did the user try to align the numbers in the screenshot above?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The user tried to align the numbers using spaces.
Step 3
8.2.2 Give TWO other word processing features that can be used to align the data above.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The user could also utilize Tabs and Tables.
Step 4
8.3 Explain the purpose of a hyperlink in a document or web page.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A hyperlink allows users to navigate to another point in the same document or to different web pages, providing a seamless experience.
Step 5
8.4 Describe how this can be done without re-typing each number.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
This can be accomplished by sorting the numbers horizontally or transposing them to a vertical list, sorting it, and then transposing it back.
Step 6
8.5 Name the combination of spreadsheet functions that were used in the cells in column B to extract the first word from the data in the cells in column A.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The functions used were LEFT/MID combined with FIND/SEARCH functions to locate the space and extract the first word.
