Using Microsoft Access database queries

Entering data in a database is done through tables or forms, but when we want to get our data out we should use Microsoft Access database queries.

A Microsoft Access database query can produce a complete or a subset of data. You can also choose to restrict the data returned based on criteria you feed in. For instance you could tell the Microsoft Access database query to return all sales figures in Australia for the final quarter.

A Microsoft Access database query can return data quickly depending on the volume of data it has to crawl through. When you just want to return information you would use what is known as a select query.

Besides a select query there are also action queries. Examples of action queries are update, delete, append and make table queries.

A Microsoft Access database query can include calculation columns. You can create a temporary column that holds a calculation as part of the results set. You may have a column with a quantity and another that holds a unit price. Your temporary column could contain a calculation to multiply unit price by the quantity.

Another great thing about a Microsoft Access database query is that it can be used to clean up data. Say for instance you have thousands of records and you wish to update all or certain records to start with a capital letter. You could do this instantly with a query.

Microsoft Access database queries are an important part of any good database system. Look at how you can put them to good use in your system.

Tags: , , , ,