Access database form design tutorial (4/7)

Publicado el: 23 mayo 2020
en el canal de: Todd Brannon

319

This is video 4 of a 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 start designing the vendor detail form and create a click event using the Macro Builder to return the user to the main form.

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

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

En esta página del sitio puede ver el video en línea Access database form design tutorial (4/7) de Duración hora minuto segunda en buena calidad , que subió el usuario Todd Brannon 23 mayo 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 319 veces y le gustó 6 a los espectadores. Disfruta viendo!