Table and field names are delimited using square brackets and/or backticks (depends on DB, I guess), not single or double quotes. Otherwise, it wouldn't know the different between a field name and a string literal in some places.

For example,
'Type Equipment'='Computer' compares two constant strings, whereas
[Type Equipment]='Computer' compares a field to a constant string.

Your queries are:

SELECT * FROM [MPCCA ALL INVENTORY] WHERE Campus='VT'
SELECT * FROM [MPCCA ALL INVENTORY] WHERE [Type Equipment]='Computer'
[download]