Understanding Access Tables

The topics covered in this Part II explain the techniques for creating and managing Access database tables, the core of any application you build in Access.

These chapters go well beyond simply describing how to build tables. Here, you learn fundamental concepts that are key to using the capabilities documented in the remaining parts of this book.

Chapter 3 lays the foundation by defining tables and their component parts. In Chapter 4, you learn the importance of table relationships and how to effectively build and manage the relationships between the tables in your database. Chapter 5 demonstrates the techniques to effectively sort, filter, and work with your raw tables and datasheets. Finally, Chapters 6 and 7 explain how you can reach outside your database and create tables from imported or linked external data sources.

IN THIS PART

1. Chapter 3
   Creating Access Tables
2. Chapter 4
   Understanding Table Relationships
3. Chapter 5
   Working with Access Tables
4. Chapter 6
   Importing and Exporting Data
5. Chapter 7
   Linking to External Data