Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 29. Blocking Bad Data > Data Integrity Basics
1. Data Integrity Basics
All of Access's data validation features work via the Design view you learned about in Chapter 27. To put them in place, you choose a field and then tweak its properties. The only trick's knowing what properties are most useful. You've already seen some in Chapter 27, but the following sections fill in a few more details.
Tip:
Remember, Access gives you three ways to switch to Design view. You can right-click the table tab title and then choose Design View from the menu, use the Home → View button on the ribbon, or use the tiny view buttons at the Access window's bottom-right corner. And if you're really impatient, then you don't even need to open your table first—just find it in the navigation pane, right-click it there, and then choose Design View.
