MS Access can be one of the most intimidating software applications if you do not understand its basics. However, once you have learned the concepts of building a database, creating forms and reports, and using queries, it can be of great use.
With a user friendly interface, MS Access offers a query function that helps you to extract the exact information needed from your database. The following steps explore the process of creating a simple query, using MS Access 2000.
Following the procedure of creating a simple query in MS Access
Here an instance of creating a query is taken into consideration, and the below steps need to be followed for the purpose.
Step 1: Open your database by going to the File tab, and select ‘Open’ to locate the database on your computer.
Step 2: Select the ‘Queries’ tab to being up a list of the existing queries, which were included in the sample database along with options to create new queries.
Step 3: Double click on the option of ‘Create query by using Wizard’. The process of new queries creation is made simple by the query wizard.
Step 4: From the drop down menu, select the appropriate table and you will be presented with a list of all the tables and queries stored in the database, which are the valid data sources for the new query. For instance, you can choose the ‘Table: Products’ option containing the information of the products kept in the inventory.
Step 5: Now you can choose the fields, which you wish to see in the query results. It can be done by double clicking on them; or you can click once on the field name and then on ‘>’. This would move the fields to the Selected Fields listing.
Step 6: To add information from additional tables, as required, repeat the previous two steps. Information from multiple tables can be combined and relationships can be easily shown. Here all you need to do is select the fields and the Access application will line up the fields for you.
Step 7: Click on ‘Next’ and then select the type of results that you would want to produce. For instance, you can choose the ‘Detail’ option that reflects every field for every record.
Step 8: Click on ‘Next’ and now you need to give a title to your query. It is recommended to select a descriptive title that will make it easier for you to recognize the query later.
Step 9: Click on ‘Finish’ and you would be presented with two windows. The first window is the Query tab with one additional listing that was created. The second window shows the results; for example, the list of company products, inventory levels, the supplier information etc.
By following the above steps, you would successfully be able to create your query using the Access application, and you would have a powerful tool for applying to your database needs.