Відео

This is a second part of the previous video, demonstrating how easy it is to add data to the model we setup in the previous video. Link to previous video: ua-cam.com/video/8gduheMn6ys/v-deo.html Link to sample files: 1drv.ms/f/s!AiiRmD8lm1KijAZWXAOytk8iUL0z?e=47S2NK

This video covers creating multiple drop-down lists and how to convert the data into a workable reusable expanding process. Link to Excel Workbooks: 1drv.ms/x/s!AiiRmD8lm1KijAijS0Xg6NaWf_BG?e=Zt39cz Link to Previous video: Tables VS Ranges: ua-cam.com/video/dqfbddtjE3M/v-deo.html

So many educators on Excel keep don't seem to know how to utilize tables vs named ranges and their built in functions.

The challenge is different from today. Fewer individuals in the field, less who are good enough. This is done while the parachutes are open, thus more challenging because of the speed each individual goes through the air at is different. This was not sponsored, so they could not purchase equipment which would more closely match each other's speed. They had to adapt on the moment, in the air to ...

Found it feasible. The singing is outstanding.

A Christian song.

Latin Rascals Macho Mozart

Implement navigation controls so the user goes to the best field to begin data inut. Implements controls over data, to ensure quality data is saved. And more

In the first video, we created a single form with multiple tables. In this video, we create several forms showing you how to link them together with the appropriate associated data.

This video takes you through the steps of developing a Form with multiple subforms, the flow between them, and control over navigation and data input.

I create a single form with 4 tables which results in some issues the users should know. We work around them and implement workable solution.

I created a 4 table subform and found some surprises. Firstly, a 4 form subform is not possible, see how I got past that. Secondly, moving from one subform to another is not automatic. And finally, staying on the same related record is not either. Gather around and see how I got past these.

Access Custom Auto number

Putting the Pieces Together

Navigate Excel by Name

Access DB - The Nex Step

Custom Auto Number in Access Database

Access - Custom Auto Numbers

Excel to Access Pt 3

Part 2: Excel to Access

Excel to Access

The Infamous Excel If Function

Auto Save on Your Excel workbook on Exit

You must know about this Excel Function.

Excel Functions

Refinancing your home? Are you sure it is a sound investment?

What you Know about Tesla is probably wrong