Don't worry about your database. Build Richard's database in the videos along with him. It helps you learn to do it instead of just watching. Once you feel comfortable with it then start your own. You will learn so much more from expert 13 onward that you'll end up scrapping your own database anyways a few times on the way up as you learn easier and better ways to do things.

Yeah, this whole thing of learning Access can be daunting if you let it.  Right now it's a bit like drinking from a fire hose.  The speed with which you have gone through the courses you really haven't given your brain a chance to catch up.  I'm +1 with what Adam said.  

Different people learn differently but the method I use is to sit down and watch the video through the first time full screen without Access even open.

Then watch the video a second time, and follow along in your own Access recreating what he is doing on screen, doing exactly as Richard is doing.  Start and stop, then do little bits.  The great thing about the videos is that you can rewind and watch it again, unlike sitting in front of a teacher in a lecture hall at school.  You also have the advantage of having the db downloads, in most cases, that you can compare to when your db isn't working like his.  Is it a pain in the ASS to type in all of the stuff?  Yes, but honestly, it is just a price you have to pay.  You develop the muscle memory as well as the eye-brain memory by doing rather than just copying it.

Richard does a great job of speaking what he is doing but even he does things that don't get spoken.  I can't even begin to tell you the number of times I notice that he clicked a menu item I missed, typed a quote mark, or inserted text that I totally missed the first time viewing.

Limit yourself.  I find that for me a 1 hour learning session is about the right amount.  Also I do best without distraction.  Turn off the phone. Distance yourself from other things like kids, wife, TV, radio, etc.

Even 5+ years in, I am still going back and reviewing the older videos.  I'm amazed at the new stuff I pick up (or reinforce) with each viewing.  I'd venture to say I've watched most videos a minimum of 3-4 times.  Some of them a dozen or more. (Double Double Quotes comes to mind.)

The difference with learning via the videos is you can't ask real time questions. I see Richard do something and I wonder what if he did it a slightly different way? That's when I pause the video and tinker with it a little. Sometimes I find it works both ways sometimes I learn DON'T DO IT that way, but I learn. I've written several databases over the years, each one better than the last but until I started watching Richard's videos I didn't realize mistakes I had made. Now, I'm rewriting them and making them much better than they were and they'll survive in the future and future programmers will be able to administer them better than if I left them as they are currently written.

Very true Glenn, real time questions are out the window.  This resource is the next best option though.
You have the Moderators here as "Teaching Assistants" as well as other student input.  Richard jumps in so much it is great!  If there is enough confusion or questions on a topic he makes a video.

That is what I love about this community.  You would be very hard pressed to find anyone else, any where else,
that provides help that even comes close.  Bar NONE.

Thanks everyone for reply... I will try to take at least 2 days to restart my brain and will try both methods to watch only and watch and practice on same time.
Thanks again

Discovered that watch and customise things on my database on the spot makes huge difference.
But now I am really in need to more formulas on date and text (equations). To run my queries on what I need.
Where can I find more formulas?

Your best bet is to run a search in the Microsoft Access Outlines Index.
Use Ctrl-F and type in your key words.  Your question is a bit vague but this will get you started:

date function
string function
formula

Date Criteria
DateDiff
Date Math
DatePart

If Then
IIF Function
NZ Function


Just to name a few.  It really depends on what you are wanting to accomplish.

Feelin' the love. Thanks, guys.

Yeah, I thought about real-time instruction YEARS ago. I could host an hour-long live session and help a dozen people. Or, in that same hour, I could record a new video that would help THOUSANDS of people over the next couple of years. Easy decision.

And yes... I absolutely love my TAs. They rock!