From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
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 record. The default value will allow you to simply skip over that field while typing, and it'll automatically put in the most common information. Of course if you'd like to change it you could. The default value is simply a suggestion. Let's go ahead and add one to our guests table. Now we can either do this in data sheet view or design view; the process is gonna be exactly the same. I'll do it design view. Let's go ahead and right-click on the guests table and open it straight into design view. Now let's suppose the majority of our guests come from the United States. Because of this I could streamline our data entry by setting up a table to automatically suggest United States as the default value for the country field. Let's go ahead and select that, and down in the field properties, we're gonna find the default value…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.