The Ms Access application makes database accessible to people without the knowledge of Structured Query Language (SQL). You can easily create queries using the Wizard in Ms Access or develop them in Design view. Yet both these options have limitations and the knowledge of SQL helps in creating modules that are effective in gleaning out relevant information in an effective manner. In this article we would look at using SQL queries in Ms Access.
Ms Access Supports SQL with minor variances as compared to other databases like SQL Server
The best part about Ms Access is that it supports SQL to the fullest possible extent and both DML and DDL parts of SQL are supported. If you compare the Ms Access application to other databases such as Ms SQL Server and Oracle, you would find that Ms Access allows you to run nearly every query that can be processed on the other fancier RDBMS applications. However SQL in Ms Access has certain minor variances and in some cases it considered to be less robust.
Entering SQL queries in Ms Access
If you are looking execute SQL queries in Ms Access, just perform the steps listed below
- Launch the Ms Access application and head to the database you wish to work on
- Open the database and then move to the Queries option that appears on the left pane
- When click on Queries you will get choice to either opt for Design View or use a Wizard to create queries. Go for Create Query in Design View
- Now in the next option where you get to select a table, avoid choosing a table and close the said dialog box
- Head to the View option in the top menu bar and then from the drop down list choose SQL View
- A Query window would show up where you can execute the SQL commands
- Once you have written down your query use the Run option which comes under the Query tab in the top menu to execute the SQL code
Note: You should save the query with a distinct name to access it in future. Also once you have saved a query, you can always access it and append the same using the design view or change its parameters.
The susceptibility of Ms Access MDB file to incidents of hardware failure is rather high
The Ms Access MDB file is known to get affected by hardware issues ranging from petty device conflicts to overheating. Now if the MDB file is compromised you need to immediately get hold of an access recovery application like DataNumen Access Repair. It can recover all Access relationships, tables and even indexes without much ado. Moreover it works with nearly all versions of Ms Access currently in vogue and supports data extraction from nearly all media types. Further the tool serves as an e-discovery application in case you experience difficulty in locating Access data files.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit www.datanumen.com