Learn MS Access - Part 4 - Create Queries

In this video, I show you how to create an MS Access Query in preparation for the next tutorial about MS Access reports. You will learn how to create a select query, view the Structure Query Language (SQL) code, create an append query, make-table query, and delete query. Queries come in handy when you need to combine more than one table of data together, make calculations or perform other functions that help create additional fields for your reports. NOTE: I'm using MS Access 2019, as long as you have MS Access 2007 or newer or even Office 365, you'll be able to follow along pretty easily. Also, make sure to view the video in HD, sometimes youtube shows it in SD format and you should enlarge the video to see more clearly. Part 1 (Introduction) - https://www.youtube.com/watch?v=DJkpP7fbCxI Part 2 (Create Tables) - https://www.youtube.com/watch?v=0N7Wtov61xM Part 3 (Create Forms) - https://www.youtube.com/watch?v=ZhRdLCaDQPc Part 4 (Create Queries) - https://www.youtube.com/watch?v=VO5GDIZY4rQ Part 5 (Create Reports) - https://www.youtube.com/watch?v=YOhdKF4wRhU Download Sample File: https://databases.biz/dlfiles/workorders.zip 💽 Additional resources: - Track your progress at: https://databases.biz - Subscribe: https://www.youtube.com/channel/UCDNd1W1xtZb43iJFnJPYKCQ?sub_confirmation=1 🎥 Watch All Learn MS Access Videos - https://www.youtube.com/watch?v=CNCJcPOVyQY&list=PLaUQUZ7uISD3OMKi0kvjxI_uV494f3vQ2 📲 Connect with me on social: - Facebook: https://www.facebook.com/databasesbiz 🔔 Subscribe to my YouTube channel https://www.youtube.com/channel/UCDNd1W1xtZb43iJFnJPYKCQ?sub_confirmation=1 🎬 Want to watch again? Navigate back to my YouTube channel quickly https://www.youtube.com/channel/UCDNd1W1xtZb43iJFnJPYKCQ 💵 Support me with your Amazon purchases: https://amzn.to/3mdidMv 💌 DISCLOSURE. Purchasing through these links gives me a small commission to support videos on this channel -- your price remains the same, just helps me out a little bit.