Microsoft Access 2010 Tutorials
More Cool Access Stuff / Copying Tables
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / More Cool Access Stuff / Copying Tables)
The ability to very easily copy a table is a really, really neat trick that an administrator needs to know about, and I think I mentioned this in one of the videos somewhere in the course, but I wanted to make sure I put it in it's own video, so that you see it, because it is such a protection, this will save you an entire afternoon or weekend sometime, and that is copying tables. Now I just want to show you this, it's not going to take very long. Let's say that somebody's told me, that I need to make a significant change to my students table. We're going to change some data here, and we're going to do updates on say three quarters of this table, all at once, using a query. I do not want to unleash a query on my production data, that's going to make that big of a change, or could potentially cause a serious problem. So what I can do is, when I start to write my query up, I can test it, and notice I have a students copy of the database here. I'm going to delete that, and show you how I got that OK? So I'm going to delete that, and make it go away, but notice before I do anything to the students table, I can just simply right click it, say Copy, and then right click in the tables again, and choose Paste. And notice it's going to paste the table as a copy of students, I can get the structure only, notice if I OK that, there's copy of students, there's no data, but I got all the structure alright? If I go into Design View, there is my table, just like it was, but it's empty alright? And so, I am going to delete this one, and you will hear it warn me, play the irritating music, and let's go back and do it again. I right click, I Copy, and then I come back, I can click anywhere in here, and I choose Paste, and I can get structure and data, or I can append this data to an existing table, so if I do structure and data, obviously you see I've got everything. Or like you saw there, I can take this data, and stick into another table. So you can do some cool things here, but now if I run my test query on my copy of students, and it totally messes my data up, no big deal. I just delete this, make another copy of my real one, and try it again. Once I see that it's working, now I can get rid off, I can drop, or delete this copy tables, OK? I can't while its open, but I can right click now, and Delete this, then go tweak my query, and apply it to the real table. So this ability to very easy right click, Copy, right click, Paste a table, is a really cool administrative trick you need to hang onto, when you're doing some of these kind of scary edits on these tables.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
