From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Control input with masks
From the course: Access 2019 Essential Training
Control input with masks
- [Instructor] Access databases give us lots of ways to control the input of data into the tables. This helps ensure that what's entered is typed correctly, and often more importantly, consistently. We can often make use of the input mask field property to help make sure that every time we enter in a phone number it gets formatted properly. Let's take a look at this with our guest table, and I can open it straight into design view by right clicking on it in the navigation pane, and choosing design view from the pop up menu. We're gonna focus on the phone number field, so go ahead and click on it, and that'll update all of the field properties down below. The one I wanna take a look at is the input mask which is the third one down from the top. I'll go ahead and click in the blank cell to the right of input mask, and that'll then display a button way over here on the far right with the three dots on it. This is called a build button, and we're gonna see this button appear in lots of…
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.