Mastering IGCSE ICT Database with MS Access | Paper 2 Oct/Nov 2024

#igcseict #0417 #4lT1#edexcel #edexcelict #edexcelpapers This video will show the solution to the October/November Information and Communication Technology IGCSE ICT Paper 02, 2024 (paper 0417/02, UCLES 2024, 0417/02/O/N/24). Mr Ike ICT guides you on how to solve this Cambridge IGCSE ICT examination. This video focuses on the Database aspect, using Microsoft Access for this examination. The time given for the whole paper 02 examination is 2 hours 15 mins. I have also included candidate source files, a worked folder, and the question paper in the link below. This examination is organized by Cambridge Assessment International Education, based in the UK. Do well to check other videos and leave a comment if you find this video useful. Thanks for watching. Download QPaper & Worked Folder: https://drive.google.com/drive/folder... TIME STAMP 0:00 - Intro 0:16 - Question 14 0:16 - Import CSV files into database software. Set primary key. 3:33 - Set date field to medium 4:28 - Take screenshots of field names and data datatypes. Paste in evidence document. 7:31 - Set fixed decimal places. 8:15 - Make Boolean/Logical fields to display Yes/No. 9:28 - Question 15 9:28 - Create a one-to-many relationship with screenshot. 11:30 - Question 16 11:30 - Produce and edit tabular report. 20:40 - Sort by field in report(ascending and descending order). 23:18 - Insert title to database report. 25:50 - Difference between page footer and report footer. 28:13 - Display and screenshot the database report formula. 29:37 - Question 17 29:37 - Create columnar form 37:28 - Use a combo box to create a dropdown list. 37:28 - Sort drop-down list in alphabetical order. 42:12 - Display unique values in a dropdown list and limit values to list. 51:51 - Question 19 51:51 - Add a record to data-entry form. 54:00 - Outro Subscribe for more videos like this:    / @mrikeict   We offer one-on-one tutorials for the following subjects: ICT Physics Chemistry Biology Mathematics English Language All are taken by seasoned teachers with proven experience and track records. Kindly send an email for more inquiries. Email: i.anolefo@gmail.com