Sunday, March 2, 2008

Experts Advice on MS Access Query

MS Access Query helps database programming to be more comprehensive and make table data processing easier due to click and drag of existing tables and queries defined in your database.

Queries help filter the table data easily and execute commands having no difficulty due to visual selection of objects. You can filter from the existing tables or from the existing queries. It will improve your ability to manage and understand your data and simplify application development.

The type of queries that ms access is capable of are the following: Select Query, Cross Tab Query, Make-Table Query, Update Query, and Append Query and lastly is the Delete Query.

Based from experience, queries can help you create database in a short period of time and it can be easily understood by many database programmers, it can be easily debugged and traced. Below is the sample view on how to create a query.

No comments: