i'm not a big fan, but sometimes ms access makes for a decent tool. however, syntax for various sql operations are different. access can still perform a left outer join, here's how...
simple select query using an inner join :
(brackets are mostly optional, but you can't use table aliases, so you have to write them out!)
SELECT *
FROM table1
INNER JOIN table2 ON ([tabla1].[id]=[table2].[id])
AND ([table1].[col1]=[table2].[column1])
here's a left outer join ~ the syntax is just "LEFT JOIN"
SELECT *
FROM table1
LEFT JOIN table2 ON ([tabla1].[id]=[table2].[id])
AND ([table1].[col1]=[table2].[column1])
update query... again, can't use table aliases, so you have to write them out.
UPDATE table1 INNER JOIN table2
ON ([tabla1].[id]=[table2].[id])
AND ([table1].[col1]=[table2].[column1])
SET
[table1].[col1]=table2.column1
help docs aren't helpful. if you need to convert columns to numeric, or to text use: CInt, CLng, CStr et al.
SELECT *, CLng(table1.col1), CStr(table1.id)
FROM table1
where CLng(table1.col1) = 1