From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 24,700 courses taught by industry experts.
Data validation rules - Microsoft Access Tutorial
From the course: Access Essential Training (Office 365/Microsoft)
Data validation rules
- [Instructor] Validation rules allow you to control what data gets saved in the database. If you try and enter in a value that isn't allowed by the rule, access will display a warning and allow you to fix the problem. I want to put a validation rule into effect on our customer phone numbers table. I want to make sure that the phone type is identified in a consistent way. The type should be either home, mobile, or work. I don't want people to enter in cell phone, or personal phone, or other descriptive words that may be correct but doesn't quite fit with my standardized categories. We can create a validation rule that ensures that the data meets my expectations, and I'll make that change in design view. Click on the phone type field to reveal its properties below, and find the validation rule property. Click to the right, then click the build button on the far right, and that brings us into the expression builder. At the top is where we'll type in the formula that we need the data to…
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.