SQL Microsoft Access Tutorials

How to Remove the Primary Key
Remove the primary key only if you're sure you won't need relationships between the tables in your database. Remember, you can only run queries on tables that have been joined in a relationship. These instructions are for Access 97.

Using SQL to Generate SQL Statements
Learn the benefits of generating SQL statements from a query, how to make the output from a query appear in the form of another SQL statement and how to use the data dictionary, database tables, or both to form SQL statements.

How to Use BETWEEN
BETWEEN is useful when selecting data that falls within a specific range. Learn how to use this powerful Microsoft Access SQL keyword.

Set or Change the Primary Key
The Access application uses the primary key to identify each item in a database table. When you set or change the key, you modify the ID number that the program uses to match records from one table to another. Here's how to set or change the key.

Introduction to SQL
The Structured Query Language (SQL) is the most popular language used in computers to create and manage databases. SQL is a language with its own syntax and grammar. SQL is a universal language that doesn't belong to a particular company. This makes it easy for different companies or programming environments to adopt it. In this site, we will study techniques of creating databases and we will use the SQL.

Return data from one column into textbox
I am quite new to SQL and am having a problem displaying data from a column into a textbox. What I need to do is: On a form I have a combobox and a text box. In the combobox I have names. When I pick a name out of the combobox I need it to display the Job Title of that person in the textbox. I can either do this using SQL or just a query in Access whichever is best or easiest.

Dynamic Uses of SQL
Learn how various commercial products--Personal Oracle7, open database connectivity (ODBC), InterBase ISQL, Microsoft's Visual C++, and Borland's Delphi--relate to SQL, How to set up your environment for SQL, How to create a database using Oracle7, Microsoft Query, and InterBase ISQL, How to use SQL inside applications written in Visual C++ and Delphi. After reading this material, you will know where to start applying your new SQL skills.

Explain a DB2 SQL Command for a single table
When an SQL is executed against or bound to a DB2 database DB2 Optimizer tool defines the access path used to access the data. This access path is defined according to tables statistics generated by DB2 Runstats tool.The Explain command details the access path defined by DB2 and allows you to analyze how the data will be accessed and how you can improve the command's performance .

How to Create an Inner Join Using SQL
Sometimes, you need to look at values from more than one table. That's when you need to create an inner join.

How to Use NULL in Microsoft Access SQL
NULL is the most useful value in Microsoft Access SQL because NULL represents the absence of a specific value. Often, you want to see columns that have missing data in them. This is the perfect time to use NULL in your SQL code. Learn how.

Use the IN Keyword
The IN keyword in Microsoft Access SQL is useful when selecting data that matches more than one value. Use IN to create powerful SQL code.

View SQL for a query
In Access 2003/XP/2000/97, I've created a query and I want to view the SQL for this query. How do I do this?

How to Copy a Table Using SQL
Copying a table is simple and quick using Microsoft Access SQL. Here's how it's done.

Basic queries using SQL
Query-By-Example (QBE) and Structured Query Language (SQL) are both well-known, industry standard languages for extracting information from relational database systems. The advantage of QBE that it is graphical and relatively easy to use. The advantage of SQL is that it has achieved nearly universal adoption within the relational database world. Learning objectives: understand the difference between QBE and SQL; create an SQL query; use SQL as a data definition language. (pdf file install Acrobat Reader to read this tutorial)

Set ANSI SQL query mode (MDB)
Set the ANSI SQL query mode for the current database, Set the ANSI SQL query mode default for new databases.

How to Write SQL Statements
You don’t have to use the Select Query window in Microsoft Access to extract information from your database. Using Structured Query Language (SQL) is often quicker and easier. Here are the basics.

How to Update Values in a Table
If information in your Access database needs to be updated, you can do it quickly using SQL. Here's how it's done.

Controlling Transactions
This tutorial will teaches you the basics of transaction control, how to finalize and or cancel a transaction and some of the differences between Sybase and Oracle transactions.

Delete a Table Using SQL
Deleting a table in Microsoft Access is surprising easy using SQL, maybe a little too easy.

Common SQL Mistakes/Errors and Resolutions
In this discussion learn several typical errors and their resolutions, common logical shortcomings of SQL users and ways to prevent daily setbacks caused by errors.