Microsoft Access 2010 Tutorials
Working with Datasheet View / Replacing Values
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 / Working with Datasheet View / Replacing Values)
This video is entitled Replacing Values, and I just want to show a couple little gotchas on editing data in these tables. Now, the first thing I'm going to do, you will notice, I'm in the Students table, and I'm in the Datasheet View. I'm going to go up here and change my alternating rows back to something a little more subtle, OK? And I'll just do that. I hope you can still see those on the rows. Let me do a little less of subtle. How about that, OK? So you can see these, but what I want you to see is, when we start editing the data in these tables or replacing these values it's very easy to do. For example, Jimmy Hank, alright? There should have been an S on that. So if I just click in the field I can just start to type, then when I click in any other field that just got saved to the database right here, OK? Now if I want to undo that I can come up here and try to do Undo and it can get it back. But if I try to Undo again, notice it jumps back to something I did previously, and this can really start to confuse me. It sorted my SID column. Now I can also double-click on a field and type something totally different, OK? I can change his name to Smith because for some reason I put in Hank when I registered him, don't ask me why. But notice that if I change him to Smith and I come down here and, say, change to Suzy to Hanks and then change Harold to Jones, now if I try to Undo, I can get that one back but I can't get the other ones back, OK? It jumped back to that SID. So here's the first thing to understand, and this is the simplest way I know to say it. There is some sort of bizarre undo situation going on here and what it really is doing is it saves this data. If I change Hanks to Johnson, as soon as I tab to the next field, or moved to the next field, this got written to the database and saved. Now if I change the age here to fourteen, I can move to another field and I can either undo or hit the Escape key and it will pull the last one back. But I can keep hitting Escape. Can you hear that? And nothing else is going on here. So here's the bottom line. Anytime you change data you get one shot to go somewhere else and Escape and change that, but you will lose that at a certain point. So here's your bottom line, be very, very careful as you're inputting here. Databases aren't as forgiving as like Excel and Word because we don't have multiple levels of Undo and we can't go back and undo fifteen inserts. So just be very careful as you edit in this environment and move off. Now because once you make a change to a database and you've lost that change, the only way to get it back is to restore from a prior backup, and that's never any fun. So again, just know that you can click on these, make your changes, and as soon as you click off it has saved your data and then you have one shot to get it back. And once you make another change or two you've lost that opportunity to undo and so you just want to be very, very careful with that so that you can see what's going on. Now, if you're going to jump in here and make a change you can do some tricks that I've seen other people do, which is do a screen print here. Just take a screen shot of the screen, save it over into a word document, make your change or two, and then look back, you have something to reference. All kind of ways that people try to take care of this, but the best way is to just, when you get in here and start editing, make sure you're focused on this. Pay close attention because you really only get one or two Undo's, OK? So that's just a little warning about inputting data and replacing values in here.
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
