Conclusion

In this chapter, we first examined lookup fields to gain a broader sense of database organization and table structure. We then dug into the specifics of table creation.

We have spent much time on table structure and design. But we haven't actually gotten around to entering and editing data in your database, which is an essential part of your work. The next chapter focuses on these topics.

TIP It's a good idea to get into the habit of compacting your database when you exit, which enables you to use disk space more efficiently. Choose Tools, Database Utilities, Compact and Repair Database.

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.