In this chapter
Define data types in Access tables
Use the AutoNumber data type as a primary key
Protect your data using field properties
Display helpful information in the Status bar
Know how and when to index
By now, you should be pretty comfortable with the Access user interface. You’ve learned how to create the objects that will make up most of your databases, and you’ve had practice customizing those objects. Now it’s time to look a bit more at the underpinnings of those objects. Although Access lets you get up and running quickly, it also lets you customize your database in almost any way you can imagine. In this chapter, you’ll learn more about tables and how you can use table design view to further improve ...