Forum Discussion
How to create SQL query against Access database?
Simple question from a n00b here. I've connected the Access application to a local copy of a database and can see the tables; now I need to make an SQL query against one of the tables.
When I click on "View" in the ribbon, there's two choices: Datasheet View and Design View.
I'm expecting a third choice, SQL View, but I don't see that option.
2 Replies
Access is designed for the citizen developer or whatever the current fad name is for "ordinary people who want to create a database application". That means defaults are often geared towards the more GUI interface options. And that leads us to "Design View". It's a grid in which you are guided in the first steps of selecting tables, adding joins using a line drawn in the designer and so on.
Good news, for those who are more comfortable with SQL, though. From the query grid in Design View, you can switch to SQL view, either immediately or after selecting a table or two.
