Office 2013 Class #48: Creating Queries In Access 2013 (15 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 2013. Topics Covered In Video: 1. Define Query: Anytime we ask a question of the raw data (00:34 min) 2. Define Data Analysis: Anytime we convert raw data into useful information used for decision making (00:34 min) 3. Question: "Show just Description and Sell Price, Sorted by Sell Price" (01:20 min) 4. Question: "Show the product records for Supplier SC", Single Criteria. (04:54 min) 5. Question: "Show the product records, where On Hand units are greater than or equal to 10". Single Criteria. (08:57 min) 6. Question: "Show records where Sell Price is less than $10 and On Hand units are greater than or equal to 10". AND Criteria (goes on same line or row). (10:15 min) 7. Question: "Show Products that have a Sell Price between $5 and $10". Between Criteria. (12:50 min) 8. Question: "Show records for the Suppliers SC or AP". OR Criteria (goes on different lines or rows). (14:34 min) 9. Question: "Calculate average Sell Price". (Aggregate function). (16:38 min) 10. Question: "Calculate average Sell Price for each Supplier". (Aggregate function with Group by Criteria). (18:11 min) 11. Question: "Calculate Inventory Value". Formula in Access Query. Calculated Field. (19:37 min) KEY DATABASE IDEA: Any change made in Form cascades throughout database Example (22:08 min) 12. Question: "Gross Profit per Product". Formula in Access Query: Calculated Field. (23:34 min) What happens if we misspell Field Name in Access Query Formula (Calculated Field) (24:24 min) 13. Question: "Show records that have a Description that contains RAIL". Contains Criteria. Asterisk wild card. (25:52 min) 14. Question: "Show phone and supplier contact for products that have On Hand less than 5". Query from two tables with a relationship. (28:01 min) 15. Question: "Parameter Query for Supplier Code". (06:28 min)