28 Timothy would like to set up a table in Access of the d…
28 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 including VAT. Right Click the button below and select “Open in a new Tab to view the database. 28.1 How many fields would the table require? (1) 28.3 How many records does the table contain? Assume this is all the data. (1) 28.4 The code field is a primary key. What is a primary key? (2) 28.5 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. a) What is another name for a filter in a database i.e. something can be executed to get specific information? (1) b) Enter the criteria to list all medicines where the stock is below 50. Give the fieldname as well. (2)