Chapter 28. Access Essentials

In this chapter

Planning an Access Database 836

Working with Database Objects 839

Exporting and Importing Data 843

Creating and Customizing Tables 844

Defining Relationships Among Tables 848

Building Forms and Reports 852

Using Queries to Extract Data from a Database 861

Creating and Applying Filters 872

Troubleshooting 873

Secrets of the Office Masters: Restricting Data Entry 874

Planning an Access Database

Of all the Office applications, Microsoft Access is by far the most demanding and conceptually challenging. Anyone who has ever composed an interoffice memo or put together a budget can relate to Word and Excel instantly; an Access database, on the other hand, is made up of many individual objects, each of which ...

Get Special Edition Using Microsoft Office 2007 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.