[Part 1] Import a CSV as a table in Access IGCSE ICT (0417)

This tutorial is on importing CSV files as tables in Microsoft Access. Primarily it is for students taking the Cambridge ICT IGCSE but also a great resource for teachers. It covers everything you need to know about this part of the assessment by working on an actual Past paper.
The playlist with all the Access tutorials can be found here:
   • Databases (Access) IGCSE 0417 ICT  
Timestamp links below:
Assessing the question paper
   • [Part 1] Import a CSV as a table in A...  

Setting up Access and starting first import
   • [Part 1] Import a CSV as a table in A...  

Setting up the Fields and data types
   • [Part 1] Import a CSV as a table in A...  

Table created check data types and modify in design view
   • [Part 1] Import a CSV as a table in A...  

Import second CSV file with appropriate data types
   • [Part 1] Import a CSV as a table in A...  

How to exclude fields from being imported from teh CSV file
   • [Part 1] Import a CSV as a table in A...  

Import of third CSV file, examine the data first
   • [Part 1] Import a CSV as a table in A...  

Here is a link to download 7 CSV files and a Question paper for you to practice importing CSV files to tables:
https://www.dropbox.com/scl/fo/ryifli...