Chapter 8: Developing Access Database Tables

Overview

You have probably heard of Microsoft Access, and you might be eager to put this powerful database tool to use. You might also be hoping that, like other Windows programs, Access 2002 will be simple to use and yet offer you the power you need to handle complex data. Well, relax. By the end of this chapter, you will know how the components of a database work together, and you will be familiar enough with Access to be able to start creating databases to meet most of your needs.

When you have finished with this chapter, you will understand database concepts and know how to:

• Create databases and tables

• Work with records

• Change the structure of tables

• Control the appearance of data

• Restrict data entries

• Find and arrange records