From the course: Microsoft Access Essential Training (Office 2024/LTSC)
Join today to access over 24,700 courses taught by industry experts.
Control input with masks
From the course: Microsoft Access Essential Training (Office 2024/LTSC)
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 important, consistently. We can make use of the Input Mask Field Property to help make sure that every time we enter in a new phone number, it gets formatted the same. I'll take the CustomerPhoneNumbers table into Design View using the button at the beginning of the Home tab. Then I'll select the PhoneNumber field, and that reveals a whole bunch of new Field Properties in the bottom half of the window. One of them is called Input Mask. Click in the cell to the right of that, and that'll reveal a new button all the way over here on the far right. It has three dots or an ellipsis symbol. This is called a Build button, and we'll see this same button show up throughout the interface in Access as we build out additional objects. Go ahead and click it, and that opens up the Input Mask Wizard. Here we have a list 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.