Part 8. Managing Your Database

Now that you have learned how to create many different types of database objects, including forms, queries, tables, reports, and the like, it's time to step back and look at the database as a whole. This part covers common tasks you'll need to perform to maintain your database, including renaming an object, deleting an object, and securing your data with a password.

In addition, this part covers setting up relationships among the tables in your database. Access is a relational database and rather than include one huge table, you'll find it better to create several smaller, more focused tables, and then link or relate the tables together as needed. Using various tables, you can create queries, forms, and reports that pull data from several of these tables.