Access Database Programming Tutorial

Create Access query.

The Microsoft Access database engine allows you to make tables and stored procedures that manipulate and store data. Access provides you with a wizard to help guide you through the programming steps to create your stored procedures. These programmed blocks of code insert, retrieve, edit and delete data in your tables. Creating your first Access query helps you understand how to program in the Access SQL language.

Instructions

1. Click the "Queries" icon in your main Access window. This opens a list of programmed queries on the database. Double-click "New" and select "Design View" from the options. This opens a wizard that helps you program the queries for your Access database.

2. Double-click each table you want to include in your query. The tables move from the list of active tables to the query designer. This allows you to retrieve data from the moved tables. If a table is not added to the designer, you can't retrieve data from it. Click "Close" when you are finished selecting the tables.

3. Drag and drop each table field from the table view to the grid at the bottom. This activates the table column as part of the programmed query, and Access displays this column's data in the query results. You can also double-click the asterisk in the table. The asterisk represents "All" columns in the table.

4. Click the "Run" button at the top of your query designer window. This displays the query results data and tests your new Access code.

5. Click the "Save" button. Enter a name for your query in the dialog box. Access lists this new query in the database. Double-click this new query name to execute and view results.

References

• Computor Companion: Create an Access Query