QUESTION 4    Information Management Below is a screen s…

QUESTION 4    Information Management Below is a screen shot (Figure 2) of the pharmacy’s medicine stock done in an Excel spreadsheet. Refer to it when answering the questions below: Right-click on the button to open to the jpg file called Medical codes in a new tab

4.1 Timothy would like to set up a table in Access of the…

4.1 Timothy would like to set up a table in Access of the data seen in the spreadsheet. The table must contain information on the Medicine Code, Medicine Name, Available Stock and Medicine Price incl VAT.   4.1.1 How many fields would the table require? (1) 4.1.2 Write down the field names and the data type of each field. (6) 4.1.3 How many records does the table contain? Assume this is all the data. (1) 4.1.4 The data that Timothy requires for the database already exists in a spreadsheet. What feature can he use to input the data into the database without retyping all of the data? (1) 4.2 The ability to accurately extract specific information from a large amount of data is one of the most important functions of a database. A filter can be used to perform this task.   4.2.1 What is another name for a filter in a database i.e. something can be executed to get specific information? (1) 4.2.2 Enter the criteria to list all medicines where the stock is below 50. Give the fieldname as well. (2)     [12]

3.2 The chairman is concerned about the high cost of telep…

3.2 The chairman is concerned about the high cost of telephone calls to branches throughout the country. You tell him of an exciting development called VoIP (Voice over Internet Protocol).   3.2.1 Explain briefly what VoIP is. (2) 3.2.2 Give an example of when it is used and explain the advantages for that application. (3)

Question 2 – Hardware and Software The N&I (New and Impr…

Question 2 – Hardware and Software The N&I (New and Improved) Election Party opened its doors at 25 Democratic Street, Pietermaritzburg.  They urgently need to get their computer systems in order and have asked you to share some of your computer expertise in setting up various systems for their use. An old second-hand computer has been donated to them for their use.  Study the following specifications of their second-hand computer: Intel Pentium 1.6 GHz processor 128 MB RAM – upgrade to 1 GB 256 KB Level 2 cache memory 40 GB IDE HDD 3.5” 1.44 MB diskette drive PCI SVGA card – 1 MB 2D ISA slots 2 serial ports, 1 parallel port Plug-and-play Windows 98

2.1 You look at the specifications of the donated computer…

2.1 You look at the specifications of the donated computer and advise the chairman that the unit is not usable and that they will need to purchase an entry level new computer.   2.1.1 What is meant by the term “Entry level”? (2) 2.1.2 You explain that the hardware components listed above are so out of date that to maintain the computer would be impossible. What are the specifications of the hardware components that could be expected in a modern entry level PC? Deal with the memory and the storage. Supply the unit of measurement in both cases as well as the actual size/speed. (4) 2.1.3 Explain why the memory is so much smaller than the storage. (4) 2.1.4 A printer needs to be purchased. Name two types of printers. (2) 2.1.5 Select one of the above types for the chairman and motivate your choice (3)

1.1.1 You would like to start a computer centre at your sc…

1.1.1 You would like to start a computer centre at your school.  Which communication network would you most likely use?   a WAN   b LAN   c GAN   d MAN         1.1.2 A printer is usually connected to a computer by a….   a bus line   b internal clock   c usb port   d serial port         1.1.3 The built-in facility of Windows XP or later to automatically add new hardware:   a 32-bit data bus   b TCP/IP   c Windows Explorer   d Plug and Play         1.1.4 A technique used to prevent unauthorised use of sensitive information is…..   a blocking   b encryption   c decryption   d hashing         1.1.5 A storage device is classified as an …………… device   a input   b output   c input/output   d none of the above       (5)