Access 2016 for Beginners Part 19: Entering and Modifying Data in Datasheet View

Get a FREE Microsoft Access 2019 Introductory Course here https://theskillstream.com/access-2019-intro-course
Get the complete 9-hour Access 2016 training course here https://www.simonsezit.com/courses/microsoft/learn-microsoft-access-2016-training-tutorials/
Get the complete 8-hour Access 2016 advanced course here https://www.simonsezit.com/courses/microsoft/learn-microsoft-access-2016-advanced-training-tutorials/
During this Microsoft Access 2016 training tutorial video, we will talk about entering and modifying data in datasheet view. Among the topics covered are column width and row height, hiding fields, deleting records, and finding and replacing data.
Check out some of our other training on YouTube:
Access 2016 training tutorials: https://www.youtube.com/playlist?listPLzj7TwUeMQ3jb4HGldAc307RUUCn2lX4F
PowerPoint 2016 training tutorials:https://www.youtube.com/playlist?listPLzj7TwUeMQ3jj_QkuckJNn8RddhwlQKOM
VBA for Excel tutorials: https://www.youtube.com/playlist?listPLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2016 training for beginners: https://www.youtube.com/playlist?listPLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2
Project 2016 training: https://www.youtube.com/playlist?listPLzj7TwUeMQ3gPqakrFQ8fSNPu00rsOuzu
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)
Hello again and welcome back to our course on Access 2016.
In this third section on Datasheet View I’m going to look at actually entering and modifying data in Datasheet View. We’ve done a little bit of this already but I want to give you some useful tips and information about finding your way round when you need to add or modify data and also how to make this process easier, particularly in specific situations.
So I’m going to close the Navigation Pane. I don’t need that at the moment. And what we’re going to look at first is the column widths. Now you’ve already seen how to adjust a column width. So for instance if I wanted to increase or decrease the width of the Country column I hover over the header, go to the right-hand edge till I get the double arrow and then I can manually adjust the width. However if I right click on the heading one of the options is Field Width. And then I can either specify a column width in units, so for instance I could say here I don’t want 19.25. I want 16 and click on OK or there’s also a best fit option. Let me select a couple of columns. Let me select TripName, hold the Shift key down and select ActivityLevel, right click, Field Width, click on Best Fit. Now both of those columns widths have been adjusted to fit all of the data.
Now when you’re dealing with a long text field like the Description field Access 2016 won’t necessarily make the width of a column absolutely huge until it gets all of the text in because that could make it a very wide field indeed. But if I right click on that and go to Field Width and do Best Fit it does make it quite a bit wider but it’s limited and it only goes so far in that width.
Now note there that once I’d made the Description field in particular much wider I now need that scroll bar at the bottom to go from left to right through the fields in my table in Datasheet View.
Now not only can you adjust the column widths you can adjust the row height as well. And again you’ve got two basic options there. If you select a row and then go to the lower edge over here on the left, note again the double arrow, I can drag row height and it adjusts the height of all rows. Note in this case that with a long text field like Description this has the advantage that you’re sort of moving all of the text or a lot more of the text into View. Now note that you can also set this to a fixed height using a little dialog. So if I right click say on ID 4, go to row height. If I wanted to say make it a specific height, say 50 units, click on OK. All of the rows, all of the records in the table, the rows in Datasheet View adopt that same height.
That can be a particularly useful thing for two reasons. One as I’ve just pointed out where you’ve got a long text field it can help you to see more of the long text at once. And a second very useful reason is that if you’re using touch it can make it a lot easier to be very accurate with touch with those taller rows because if you switch between touch and mouse mode, let me just demonstrate this. Although it spaces out the controls on the Ribbon, for example, it doesn’t make any difference to the spacing and arrangement of the data in Datasheet View. So let’s just go into touch mode now, look at the Ribbon and look at the data. Although the Ribbon
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.