Introduction

Once you're familiar with the basics of creating and using a database, you're ready to work with some of the more advanced features of Microsoft Office Access 2003 that can help you better manage your database. If you're working in a multi-user environment, where several people need access to the database, you need to explore ways of maintaining database security. Access provides several tools that help you control who can connect to your database and what a user can do once he or she is connected.

In addition to security issues, Access provides tools that help your database operate more efficiently. This includes the ability to compact your database file and to repair it if it is damaged. You can also use Access to analyze the design of your database and tables in order to improve performance and reliability.

Finally, if you're interested in making your database easier to use, Access provides a Switchboard Manager that can put a user-friendly face on your database. With a switchboard, new users can access database reports and forms with a single click of a button, and you can control what parts of the database you want users to be able to access.