Lessons

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Access 322
Get notifications when this page is updated

Intro

In lesson 322, you will learn about record locking, using the Recordset Seek method for faster data searches, working with external recordsets to connect to other databases, and looping through the Fields collection in Microsoft Access. We will also build a user logon system step by step. This lesson uses Microsoft Access 2003, but most of the material applies to earlier versions as well.

Transcript

Welcome to Microsoft Access 322 brought to you by accesslearningzone.com. I am your instructor, Richard Rost.

In today's lesson, we are going to talk about record locking, the Recordset Seek method, which is faster than Find, external recordsets, which is connecting to outside databases, and the Fields collection that lets you loop through all the different fields in a table so you don't have to specify them one at a time.

We are also going to build a project, which will be a user logon system. This class follows Microsoft Access 320 and 320.1. I strongly recommend taking both of those classes before this one.

In this class, I will be working with Microsoft Access 2003. However, most of the material should be backward compatible with all previous versions of Access back to about Access 2000.

I strongly recommend you sit back and relax, watch the lesson one time through, then watch it a second time while following along with the examples, and build the database that I build in class. Don't try to apply what you learn immediately to any other databases that you might be working on.

The database files for this class can be found online at accesslearningzone.com/students. You will find a list of all the sample database files there.

Again, it is strongly recommended that you build the databases in class that I am building.

If you have any questions about the material covered in today's class, please feel free to post a note in the student interaction forums. You will see the student interaction forums next to the video window if you are watching this class on our website. If you are using our video player software and you are connected to the internet, you should see the student interaction forums pop up right next to the video player.

If you have any other Access questions, please visit the forums on the website at accesslearningzone.com/forums.

We have brand new interactive forums as of October 2008. I created all new forums, and you can log on, check them out, and chat with me, other students, and other Access experts.

And of course, I can't stress enough again to do the examples yourself. You will benefit the most by building the databases that I build in class.

Quiz

Q1. What is one of the main topics covered in Microsoft Access 322?
A. Creating Excel Macros
B. Record locking
C. Front-end JavaScript
D. SQL Server Integration Services

Q2. What is the primary benefit of the Recordset Seek method mentioned in the lesson?
A. It is easier to remember than Find
B. It works only with forms
C. It is faster than Find
D. It replaces all other record search functions

Q3. What should students do while watching the lesson for the first time?
A. Skip to the exercises only
B. Try to apply the concepts to other databases immediately
C. Sit back, relax, and watch the lesson one time through
D. Take the final quiz

Q4. Why is it recommended to watch the lesson a second time while following along?
A. To memorize the script
B. To practice typing
C. To build the database being demonstrated
D. To speed up the video

Q5. What does the Fields collection allow you to do in Access?
A. Only edit the first field in a table
B. Delete tables automatically
C. Loop through all the different fields in a table
D. Import tables from Excel

Q6. Where can students find the sample database files for the class?
A. Only in printed textbooks
B. On accesslearningzone.com students section
C. Attached to every email from Access
D. Embedded inside the Access program

Q7. What is recommended before trying Microsoft Access 322?
A. Completing both Microsoft Access 320 and 320.1
B. Learning SQL Server Management Studio
C. Installing Windows Server
D. Reading the Windows Registry documentation

Q8. What kind of project will be built during this course?
A. Inventory tracking system
B. Payroll management app
C. User logon system
D. Calendar scheduling tool

Q9. What should students do if they have questions about the course material?
A. Only email the instructor directly
B. Ignore their questions
C. Post a note in the student interaction forums
D. Wait until the next course

Q10. What is emphasized repeatedly for maximizing learning in this class?
A. Buying more courses
B. Building the databases shown in class yourself
C. Memorizing every detail from the video
D. Reading unrelated forums

Answers: 1-B; 2-C; 3-C; 4-C; 5-C; 6-B; 7-A; 8-C; 9-C; 10-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone focuses on several advanced Access topics including record locking, using the Recordset Seek method for faster searching compared to Find, working with external recordsets to connect with other databases, and utilizing the Fields collection to loop through all fields in a table without needing to specify each one individually.

During this lesson, I will guide you through building a user logon system as our main project. This class is a continuation of Microsoft Access lessons 320 and 320.1, so I highly suggest you complete those courses before starting this one to ensure you have the necessary background.

For this class, I am using Microsoft Access 2003, but rest assured that most of the content should be compatible with earlier versions as far back as Access 2000.

My advice is to watch the lesson all the way through first. Once you have a good understanding, watch it again while following along, and make sure you actually build the example database demonstrated in the course. Refrain from trying to immediately apply these techniques to any other projects until you are comfortable with the material.

You can download all of the database files used in this class from the Access Learning Zone students page. There you will find a complete list of sample databases for this lesson.

If you have questions about anything covered in the class, I encourage you to participate in the student interaction forums. These are available right next to the video if you are watching on the website, or they will appear alongside the video player if you are using our software and are connected to the internet.

If you have additional Access questions, please visit the main forums on our website. We have new interactive forums where you can connect with me, other students, and Access professionals to get help and share ideas.

It is absolutely essential that you work through the examples yourself. Doing so is the best way to master the techniques I will be teaching.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Record locking in Microsoft Access
Using the Recordset Seek method
Comparing Seek and Find methods
Creating and using external recordsets
Connecting to external databases
Using the Fields collection in VBA
Looping through table fields programmatically
Building a user logon system in Access