Query with a sequence of "and not like"
The problem is most likely some NULL values. Unfortunately, NULL LIKE 'anypattern' will not result in FALSE but in UNKNOWN and NOT UNKNOWN is still UNKNOWN. So any row where one or more of the values is Null, will not be in the result list because WHERE filters all rows that the condition is anything but TRUE (FALSE and UKNOWN get rejected).

Try this change:

select * from VHS_Metadata_Aug52014 where 
(Title Not like '*' &amp; 'News' &amp; '*'           Or Title Is Null)
And
(Description Not like '*' &amp; 'News' &amp; '*'     Or Description Is Null)
And
(Tag Not like '*' &amp; 'News' &amp; '*'             Or Tag Is Null)
And
(Speaker Not like '*' &amp; 'News' &amp; '*'         Or Speaker Is Null)
And  
(VIP Not like '*' &amp; 'News' &amp; '*'             Or VIP Is Null)
And
(FilmingLocation Not like '*' &amp; 'News' &amp; '*' Or FilmingLocation Is Null)
And
(Notes Not like '*' &amp; 'News' &amp; '*'           Or Notes Is Null)
;