How to Look Up Values From 1 Microsoft Access Table & Automatically Insert Them in Another Table

Video Transcript

"Hi! My name is Dave Andrews. Today I am going to show you how to look up values from one Access table and automatically insert them into another. Let us open up Access by clicking on the Start button, going to All Programs. Let us click Microsoft Office and from there let us open Access. What we are going to do is open up a database. I have one here that I am going to click on to open it, called Select Into. Now, I have a table here called People and if I double click on it, you can see that it has several columns including a column called a Person Name, Person Telephone, and Person Address. What I want to do is look up specific columns out of this table and insert them into a new table. We do that with a query. Go to Create and select the Query Design. Let us close out of this and then click on the Sequel View. This opens up the Sequel View for your table. I already have one created, so I am going to right click on it and go to Design View on it. This is the Sequel View for the Sequel Query that I have created. Basically, it selects the Person Name and the Person Telephone, every single row of that into the Friends Table, which currently does not exist, from the People Table. When we run this query, it is going to select that data and automatically create the Friends table with just these rows we selected. Let us click on Run. Actually, the content has been disabled so I have to click Options, and say Enable This Content. That is one thing that might happen to you. Say Ok. Now, let us open that query back up again. Now, what it is going to warn you is that you are about to run a Make Table query that is going to create a table in your database. That is fine. So, let us just click Yes. "You are about to paste three row into that table." That is fine as well. Click Yes. As you can see, our Friends Table has been created and all it has in it is the Person Name and the Person Telephone that we looked at from the other table. My name is Dave Andrews, and I have just showed you how to look up values from one table and insert them into another in Microsoft Access."