Access only has Stored Queries which are slightly different to views. JET allows views however you cannot utilise them through the standard Access interface. Check out this (part 3 of 3 interesting JET SQL articles) for more details.
You cannot create a Stored Query using SQL. You will need to create the object and append it to the Queries collection using ADOX or DAO.