Access database form design tutorial (2/7)

Publié le: 22 mai 2020
sur la chaîne: Todd Brannon

457

This is video 2 of the Access database form design tutorial where we create a Vendor database with forms to select a vendor and view details, including multiple contacts, in a second form using a subform. We discuss the architecture of the two tables for this project and create a simple One-To-Many relationship between the vendor table and the contacts table to accomplish this.

In this installment the Access database form design tutorial series, I will create the Vendor to Vendor Contact query and test it based on VendorID criteria.

----------------------------------------------------------------

Over the course of the 7 videos in the tutorial, I will show you the basics of creating forms in access, including the use of subforms, comboboxes, textboxes, and other control elements.

If you are looking for some ways to make your Accesss database application UI more professional, I show you an approach to microsoft access form design that will have your access database forms looking less like a clunky tool stuck in the 1990's and more like a modern software application.

Once I show you how to add the appropriate Access VBA programming to automate the workflow of the application, hopefully you will be inspired to create your own and keep learning more.

Access database form design tutorial:
Video 1 - Introduction and review of the completed project file.
   • Access database form design tutorial ...
Video 2 - Create the Vendor to Vendor Contact query and test it based on VendorID criteria.    • Access database form design tutorial ...
Video 3 - Design our first form with a combobox linked to our vendor table.
   • Access database form design tutorial ...
Video 4 - Design the vendor detail form & create a click event to return the user to the main form.
   • Access database form design tutorial ...
Video 5 - VBA programming for main form select button click event.
   • Access database form design tutorial ...
Video 6 - Use an If Else statement in our VBA for the click event to select a vendor.
   • Access database form design tutorial ...
Video 7 - Insert the vendor contacts form as a subform in the vendor detail form.
   • Access database form design tutorial ...

Follow me on instagram:
  / analystfactory

Visit my websites:
http://www.analystfactory.com
http://www.toddbrannon.com

Sur cette page du site, vous pouvez voir la vidéo en ligne Access database form design tutorial (2/7) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Todd Brannon 22 mai 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 457 fois et il a aimé 7 téléspectateurs. Bon visionnage!

3,094