Create Titles and Viewings records from RawInput table. Include Name field data in both tables.
For Titles table, run a SELECT DISTINCT INTO query. Add TitleID autonumber field to Titles table.
For Viewings, simplest is to just copy RawInput table, give copy appropriate name, delete unnecessary fields except [Name]. Add ViewingID autonumber whenever.
(Again, Name is a reserved word and should not use reserved words as names for objects.)
Create a query that joins Titles to Viewings on Name fields. Set TitleID (FK) field to update from TitleID (PK) field. Query like:
UPDATE Viewings INNER JOIN Titles ON Titles.[Name] = Viewings.[Name] SET Viewings.TitleID = Titles.TitleID;
Then can delete Viewings.[Name] field.
Access query designer can help build this.
This does assume each title does not have multiple genre and year released associated.
Also advise not to use spaces nor punctuation/special characters in naming convention.
Also best to avoid using exact same field name in multiple tables.