From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Set a default value

Set a default value

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Set a default value

- [Instructor] When you have a field that'll commonly contain the same information record after record, you can specify a default value to appear when entering in the data. The default value will allow you to simply skip over that field while typing and will automatically put in the most common information. Of course, if you want to change it, you can. The default value is simply a suggestion that Access makes. Let's go ahead and add one to our Guests table. I'll go ahead and double click on it to open it up. Now, we can do this in either Datasheet view or Design view. The process is exactly the same. I'll go ahead and do it in Design view by switching my view into Design view. Now, let's suppose that the majority of our guests come from the United States. Because of this, I can streamline our data entry process by setting up the table to automatically suggest the United States as the default value in the Country Field. To do this, we'll come down and we'll just select any cell here…

Contents