[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 542
  • Last Modified:

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.
0
rayluvs
Asked:
rayluvs
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now