INSERT

INSERT INTO   table_name 
              (column1, column2) 
VALUES        (value1, value2) 

this works in both SQL Server and Access

INSERT INTO zCUSTOMERS 
([CustomerID] 
,[Company Name] 
,ContactName 
,ContactTitle 
,Address 
,City 
,Region 
,PostalCode 
,Country 
,Phone 
,Fax 
) 
VALUES 
('AsdKI'  
,'Alfreds Futterkiste' 
,'Maria Anders' 
,'Sales Representative' 
,'Obere Str. 57' 
,'Berlin'  
,NULL                         
,'34234'  
,'Germany'  
,'030-0074321'  
,'030-0076545'  
)