Microsoft Access A to Z: How to Best Use the Form Wizard to Create Form/Subforms

This screencast shows you how to prepare data so that when you use the Form Wizard, the best arrangement of data is presented including form/subforms. It shows how a main form may have one or even two subforms, and how related data changes in the subform as you navigate through the records of the main form.

[larryminnich]

This remarkable presentation shows the power of basing a form on a query rather than directly on tables. Absolutely excellent!

[atefedu]

Lisa Friedrichsen you are such a great professor and you have an amazing way to teach people, I wish you have the whole course as a complete on Youtube instead of the 5 - 10 minutes video. I still benfit from these short video but I can only imagine if you have the whole lecture.
Thanks so so much for yout efforts and your hard work to put these videos together.
It is highly appreciated
Thanks

[BalefulHead]

I greatly appreciate this series. I'm starting a business from home and am well versed in Excel but now I have database needs and no database experience.

Problem I've run into is that forms don't appear if they've been created by the form wizard. This problem has happened to a lot of people, as I've found others with the same issues while searching the net for solutions, but the responses to those individuals is an array of random odds and ends. I've tried every solution that I've encountered and nothing has helped. Have you experienced this problem or have you had to handle how to resolve this issue?

In the meantime, I'm designing my own form from scratch but that's exceedingly tedious and I've yet to master the more advanced features.

[dagnachewdesta]

Is there any way I can find out which table and column used the form ? If Form pulling data from multiple tables.

[stanTrX]

When i encounter relation tables involved in queries as both sides are 1-1, query (so the form creates by that query) does not work.