Microsoft Access

1. Microsoft Access How to create a query By Shaday Collie

2. This presentation will take you through the step by step instructions on how to create a simple query. You must first open the file you would like to create a query on. Your next step will be to click the query wizard button located in the create tab on your toolbar. This would then redirect you here, where you would click on the option ‘Simple Query Wizard’

3. Choose the fields you'd like to be presented in the results of your query. To choose 1 field at a time, select it and click the ">" arrow. To choose all fields click the ">>" arrows. Then move on to next. After which you will proceed by giving your query a suitable title and clicking finish.

4. Next you’ll need to move to your queries design view by either right clicking your query on the left hand side toolbar or clicking ‘View’ on the far left of your ‘Home’ tab. After this you can proceed by adhere to the specified criteria using different functions such as wild cards, ‘greater than’, ‘lesser than’, ‘and’, ‘between’ and ‘or’.

5. Wild Cards • Wild cards are used to display data that contain a required detail. For example if I wanted to display the records of everyone with the last name ‘Smith’ I would type in the name as it appears in the query under employees last name. • Or you if you wanted to look up all names ending with G you would type G followed by an asterisk ‘G*’. Similarly for names beginning with G you’d type *G. Lastly for a word with G found somewhere in between we would type asterisk on both sides ‘*G*’.

6. Query functions • ‘>’ or ‘<’ are used in number fields if you desired to display records with numbers greater than or less than certain numbers. For example if I had a query based on a holiday database and I wanted to show records of payments for 2 or more individuals I would type ‘>1’. • Another example is the in between function. This shows data that only have numbers between you specified range. For example if I wanted to show number of individuals more than one but less than 10 than I’d arrange it like this (‘between’ 1 ‘and’ 9) under the ‘number of persons’ or appropriate field. • Lastly, the ‘or’ function allows us to display records with a specific criteria only. For example if I wanted to show the data for tourist travelling to the Maldives, Croatia and Dubai I would arrange it like this (Maldives ‘or’ Croatia ‘or’ Dubai) under the ‘destination’ or appropriate field This are the steps and functions used to create queries.