Intiminated+by+Access+a+break+down+how+to+use+Queries

Access is definitely the most intimidating application to learn of the Microsoft suite, for me at lease, mostly because I never actually used it before. However, like most Microsoft applications once you get a feel for it, it goes smoother. Access allows you to link a lot of information together so it’s easier to use, read, and sort there, all in one place. For example: Spreadsheet of information, and report to summarize that information, forms to fill in or review, right there is you have your processor speed working because you would have to open 2-3 word files and 1-2 spreadsheets depending on the information, this is why Access helps. You have the ability to take one spreadsheet and break it into smaller tables specific to the information you want to look at without have to retype everything, these are called __ Queries __ v The Create Tab is the golden ticket when adding different ways to see your data. Ø Under the create tab use the query design command Ø When the new screen appears select the table in which you would like information from and if you only have one table select it. Ø From here you see the screen is split in into two panels: o The upper panel holds the names of the fields specific to the selected table o Lower panel is where you will tell Access to split your table so you can few the information in that table different ways § Field: choose a field name from the upper panel- the table row will fill in automatically § Sort: with the pull down button choose if you would like the information to be sorted § Show: leave the check mark in the box if you want that information to be shown when looking at the query in spreadsheet format- uncheck the box if you need/want the information sorted or related to the field that you choose but don’t necessarily need to view it §  Criteria: is like working in excel but not exactly, you create a equation with slightly different operators; o  < less than o  >greater than o  = equals o  <=less than or equals o >= greater than or equals ·  you should also be very aware of the order of operators <span style="font-family: 'Courier New'; mso-fareast-font-family: 'Courier New'; msofareastfontfamily: 'Courier New'; msolist: Ignore;">o It will multiply <span style="font-family: 'Courier New'; mso-fareast-font-family: 'Courier New'; msofareastfontfamily: 'Courier New'; msolist: Ignore;">o  divide <span style="font-family: 'Courier New'; mso-fareast-font-family: 'Courier New'; msofareastfontfamily: 'Courier New'; msolist: Ignore;">o Add <span style="font-family: 'Courier New'; mso-fareast-font-family: 'Courier New'; msofareastfontfamily: 'Courier New'; msolist: Ignore;">o Subtract last : so as a hint put everything in separate parentheses or be really good at algebra <span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings; msobidifontfamily: Wingdings; msofareastfontfamily: Wingdings; msolist: Ignore;">§ OR: allows you to enter more than specification to the field of information Under the create tab there is also a report wizard and a form wizard, these two functions will walk you through step by step and allows you to view the reports and forms in a way that fits you most.