Access database form design tutorial (5/7)

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

253

This is video 5 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.

In this installment the Access database form design tutorial series, we write the VBA code for our main form select button click event using the Code Builder and test the results of the click event using a message box. We also see what happens when we click the select button and no vendor is selected in the form combo box.

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

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 (5/7) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Todd Brannon 23 mai 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 253 fois et il a aimé 8 téléspectateurs. Bon visionnage!