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