In this video, I show you how to create an MS Access form and subform based on two MS Access tables that are related. You will learn how to create the MS Access form, format the layout of input fields, a small amount of Visual Basic for Applications (VBA), and add two command buttons to the form to add new records or delete records.

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 2 – Create Tables

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.