OLD [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
• OLD [Part 1] Import a CSV as a table in Ac...
Setting up Access and starting first import
• OLD [Part 1] Import a CSV as a table in Ac...
Setting up the Fields and data types
• OLD [Part 1] Import a CSV as a table in Ac...
Table created check data types and modify in design view
• OLD [Part 1] Import a CSV as a table in Ac...
Import second CSV file with appropriate data types
• OLD [Part 1] Import a CSV as a table in Ac...
How to exclude fields from being imported from teh CSV file
• OLD [Part 1] Import a CSV as a table in Ac...
Import of third CSV file, examine the data first
• OLD [Part 1] Import a CSV as a table in Ac...
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...