Ultra N00b Question sorry. Require a list of example data types

[Mark Lucas]

Hi,

I'm so sorry for the ultra simple question, but I've looked for an hour on Google and YouTube and I can't find an answer.

I've recently started an apprenticeship and we've been given a task of creating a simple table and inserting data.

I can create a table ok but I run into errors when I try and insert data into it, I don't know what format it has to go in, is there any reference point anyone can direct me to please.

For example I've created a CD collection list, showing primary key, CD name, artist, number of tracks, duration, release date.

I don't how to insert values into this, eg what format does date need to be, or duration.

Any help would be great. Thanks