Chapter 9: Making Access Data Easily Available

Overview

Simple tables like the one you created in Chapter 8 will probably meet many of your needs. However, with relational databases like Access, you can manipulate tables so that you can easily find and use the information they contain. In this chapter, you look at more ways to work with Access and Access tables, and you learn how to use forms, queries, reports , and data access pages to retrieve information from the database.

When you have finished this chapter, you will know how to:

• Copy table structure

• Create and customize forms

• Establish table relationships

• Create queries

• Run queries based on multiple criteria

• Update and move records

• Create reports

• Create and modify data access pages