Access database form design tutorial (2/7)

Veröffentlicht am: 22 Mai 2020
auf dem Kanal: 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

Auf dieser Seite können Sie das Online-Video Access database form design tutorial (2/7) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Todd Brannon 22 Mai 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 457 Mal angesehen und es wurde von 7 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

465