QUESTION 3 You have been asked to create a database for the Year 08 students of a school in Nigeria, using MS Access. There are 30 students in the year 08 class. The database must contain the following information: 1.     Students name and surname 2.     Their age, cell number and email address 3.      Their 5 main subjects   3.1   How many fields will the table require? (1)

3.4   Which field is suitable to be used as a Primary Key and why? (2)

2.5   Write the function used to get the answer in cell B13 (2)

3.6.2   name (1)

2.7.2   You now need to have the heading stretch across all the cells from A1:F1 as one cell. How will you do that? (2)

4.9 Using the Internet we must be able to determine which website is safe by looking at its address. Some techniques used by hackers to make users visit their web page are: Cybersquatting Typosquatting Thin content Content farms Spam page Briefly explain what Cybersquatting and Spam pages are.     (2)  

1.2 How many records will the table contain? (1)

5.4   How many kilobytes in 1 Megabyte?   (1)

3.14 Binary Code (1)

4.7.1 Is it better to provide a Wired, using Fibre Optics, or Wireless network for a large company?   (1)