Here's a question I recently received:
I am a loyal user of your lessons and have been for a long time. Twice in answer to your request for suggestions I have written to say that an index is needed. This e-mail is to strongly emphasize that suggestion. Right this minute I am trying to import an xls file into an access database and need to review your lesson on that. To find that lesson, however, is an unnecessarily time consuming task in itself which would be simply with an index. You should take an index out of some access textbook as a guide and indicate your course and lesson numbers after each entry. I have tried to do that myself, but I don’t have all of your courses and it is a very tiresome exercise to scan through every lesson (which takes a lot of time) only to find that I don’t have the information. I am sure such an index would be a popular item in your offering. -Bill
Bill, you are absolutely correct. I have been slowly building one - it's more of a table of contents - but it's online HERE. You'll see it in the menubar on that class (and there's one for Excel, since these two classes have lots of lessons).
It's a complete list of every course and every topic covered in that course. You can use your browser to search for a specific topic (in Internet Explorer or FireFox just hit CTRL-F for the search feature).
Also, I've added a SEARCH page to the site, so you can type in any keyword, like DLOOKUP, and it will automatically find any page (usually a course outline) that has that topic in it.
You're right though, I should sit down one of these days and just go through one of these monster Access books with their index and make my own - and indicate which lessons cover what topics. It would be a good way to make sure I'm covering everything - and more importantly to help you guys out.
Problem is, that's very time consuming, and I've got lots of other videos to record.
Help...??? Ha ha ha.
Oh... and to answer your question, if you go to the Access index and search for "import" you'll find that I covered it in Access 308.
Rick