Access 2016 for Beginners Part 17: How to Design a Database in the 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 take a look at the datasheet view in detail. Here we will talk about design in the datasheet view such as formatting fields, data types, validation, and more.
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 ;-)
Welcome back to our course on Access 2016. In this section and the next couple of sections we’re going to look at Datasheet View in quite a bit more detail.
Now I pointed out earlier on that you can design in Datasheet View and you can do data maintenance in Datasheet View. But I think it’s fair to say that it isn’t really the most suitable way of doing either of those things. Having said that, many people like to use Datasheet View. And one advantage of using Datasheet View is that you can do both design and data maintenance using one view and one set of tools.
So what I’m going to do in this first section is to look at doing design in Datasheet View and then in the other two sections I’m going to concentrate on the data aspects.
We’re not going to need the Navigation Pane for a little while so let’s just collapse that over to the left. And let’s select the Fields tab in the Table Tools on the Ribbon.
Now if you look at the left-hand group on the Fields tab you have a Views group with a Views button. And of course I’ve already pointed out that at the bottom here you’ve got a choice of Datasheet View or Design View. Now in fact you can toggle between those two views just by using the top half of the button.
So bearing in mind that we’re looking at design aspects here let’s look at that Add and Delete group.
Now you’ve already seen that I can add a new field at the end of the field list over there on the right using that click to add column. But if I say selected the Country column, the country field, I could add a field of one of these types just by clicking on the button in the Add and Delete group. So if I wanted a short text field click there and I have a short text field with a default name of Field 1 added to the right of the Country column which is the column that I had selected. Now some of the most popular data types are shown here with single buttons. So there’s Number, Currency, Date and Time, Yes/No. if I click on More Fields I have a very, very long list of potential fields that I can add using this approach. The other button that you’ll see in the Add and Delete group is the Delete button. And if I want to delete a field I select it. I get a warning there about permanently deleting the selected field, confirm, and that field is gone again. So that’s a straightforward way of adding and deleting fields to a table.
Let’s move on now to the next group, that’s Properties. I mentioned quite a bit earlier on in the course that in Datasheet View you don’t really have the full power that you have in Design View but you can certainly do a lot to maintain the properties of the fields in a table. So let’s select the TripName column, the trip name field. And some of the controls in the Properties group are enabled. So for instance if I click on Name and Caption I could change the name of the field or the description of the field. I could add a caption which would appear in certain situations, as we’ll see later on in the course.
I can also change the field size for the trip name or I could set a default value. Currently there isn’t a default value for trip name. Notice that the other properties are
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.