In this video, I show you how to create two MS Access tables using an MS Excel sheet with technician and work order data. You will learn how to create the MS Access tables, drop-down menus, import the data, create a relationship between the two tables, Primary and Foreign keys, and much more about MS Access tables.

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 3 – Create Forms

Part 4 – Create Queries

Part 5 – Create Reports

Download Sample MS Excel File

WorkOrders File

💽 Additional resources:
– 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

💵 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.