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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.