Office 2010 Class #45: Creating Queries In Access (16 Examples)

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2010.
Topics Covered In Video:
1. Create Queries in Access: Simple Query to show sell price
2. Create Queries in Access: Word Criteria
3. Create Queries in Access: Parameter Query
4. Create Queries in Access: Simple query to show cost
5. Create Queries in Access: Contains Criteria
6. Create Queries in Access: Less Than Criteria
7. Create Queries in Access: Greater Than Or Equal To Criteria
8. Create Queries in Access: AND Criteria
9. Create Queries in Access: OR Criteria
10. Create Queries in Access: Formula For Inventory Value
11. Create Queries in Access: Formula For Gross Profit
12. Create Queries in Access: Formula For Average
13. Create Queries in Access: Formula For Average "Group by"
14. Create Queries in Access: Parameter Query for Average
15. Create Queries in Access: Reorder Phone List
16. Create Queries in Access: Between Criteria

Category:

Science & Technology

Tags:

• Office
• 2010
• Access
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Ron
• Davidson
• Computer
• Information
• Systems
• Busn
• 216
• Applications
• Class
• Create
• Queries
• in
• Simple
• Query
• Word
• Criteria
• Parameter
• Contains
• Less
• Than
• Greater
• Or
• Equal
• To
• AND
• OR
• Formula
• For
• Inventory
• Value
• Gross
• Profit
• Average
• Group
• by
• Reorder
• Phone
• List
• Between

[JediMindMFDoom]

Thank you brother!!!!

[ExcelIsFun]

@JediMindMFDoom , you are welcome!

[Kinderocks]

ok ok.

you're THE God.

Thanks for all your vids. Highly appreciate them! =)

[ExcelIsFun]

@Kinderocks , you are welcome!!!

[Gbengz7]

@ExcelIsFun do you know how to do days elasped years elasped and so on

[ExcelIsFun]

@Gbengz7 , I am not that good with Access, but maybe formulas like this:

Days: [DateOut]-[DateIn]

Years: Year([DateOut])-Year([DateIn])

[sluicetwo]

i wish my professor were this clear...

[sluicetwo]

thank you so much!

[ExcelIsFun]

@Xiteg , you are welcome!

[ExcelIsFun]

@JeSsThaBBW , I am not sure. But if the Query answer is not right, either the query is incorrect or the data is incorrect. Meaning, that the logic of the analysis is not wrong, it is either the query creator or the data that is wrong.

[JeSsThaBBW]

im making a query from a customer table that contains; Customer Number, Customer Name, and Amount Paid for all Customers located in VA (virginia) with a paid amount greater than $1,000.00. BUT VA is no to be shown in the data sheet view.. In the figure of how mine should come out, it has 2 entries but when i go to the data sheet view mine has 5. What am i doing wrong!??! oh yeah this is for Microsoft Access 2010 Chapter 2 project.. CAN ANYONE HELP ME?

[Kinderocks]

You're a God.

Seriously.

[ExcelIsFun]

@devin3627 , it does matter: you must use >=

[devin3627]

does it matter if you put >= or => in ant order>

[Xiteg]

you just saved me on my project tonight. Thanks a lot!!

[ExcelIsFun]

You are welcome!!!

[tf2tactics]

thanks for all your videos! they are so in depth but at the same time you present it so clearly and you make it look simple.

[ExcelIsFun]

You are welcome!

[Phoerocks]

Wow this tutorial is amazing, srsly THANK YOU SO MUCH!!

[ExcelIsFun]

I am glad that you liked it!

[dmr450]

Fantastic!