How can I create view table in MS access 2oo3? I tried this bu t it dont work.
Any help please. Thanks.

Create View test1 AS SELECT *
FROM Job_Request_Record, Requester_Record
WHERE Job_Request_Record.Job_Requester_ID=Requester_Reco rd.Requester_ID;