How to create View tables in MS Access 2007 like in MS SQL

We are working in MS Access 2007 and would like to know how to create View tables just like in we do in MS SQL.  We're not fluent in Access but we are working with it.
rayluvsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

joy_mCommented:
Hi,

Use this:

create view your_view_name
field1,
field2,
........
as
your_select_statement

Please remember:

1. Do NOT use any parameter in your select statement.
2. The select statement should not include any select..into statement.

Hope this answers your query ;-)

Thanks
0
abkmaCommented:
There is no concept of a View in Access.  Essentially you would create and save a your query as a 'Select Query' and you can then use it in other queries as if it were a table in your database.  In access you create complex layers of queries based on other queries.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

rayluvsAuthor Commented:
Still couldn't create the View table.  Again, we're kind of new to MS Access.

lsavidge,

               your links seems to relate to another version

joy_m,

               I get error message "Syntax error CREATE TABLE statement"

abkma,

               How do I create and save a my query as a 'Select Query'
0
abkmaCommented:
Ramante,

I'm not sure of your version.  I have Access 2007 so I click on the "Create" tab on the ribbon and then far off to the right hand side is a button labeled as "Query Design."  I believe in older versions you would click on the Queries button in the main panel and there would then be an item in the list similar to "Create a new query."  

From there you can build you query either in design view using point and click or you can switch to SQL view and write the SQL code directly.  After you are done save this query and you should see it in your list.  Whenever you create a new query you will see that the box that lists the table names has three tabs "Tables, Queries, Both."  If you click on the "Queries tab you will be able to select any existing queries for use in your new query as if it were a view.  

You'll see that there really is no direct concept of a view only tables or queries.  However you can in essence "stack" queries one inside another.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rayluvsAuthor Commented:
Ok, got it and worked excellent.

So in conclusion, the query I just created and saved, its like a VIEW table ?  Would that be a correct assumption?
0
abkmaCommented:
Essentially yes.  You can use any query in another query just like it was a table.
0
rayluvsAuthor Commented:
Thanx!
0
abkmaCommented:
No Problem.  I'm glad it worked out for you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.