Using Microsoft Access Tools
When novice developers create an Access database, they generally use few of the software’s powerful functions.
When first creating a database for yourself, you probably got by just fine by simply modifying, adding, and deleting information directly in tables by using datasheets. Later you found out how to create queries, forms, and
reports, and life got more exciting (and more complicated).
Once you graduate to developing database applications to which several users will share access, you must pay more attention to control and design. You must control who is using the database, what data users can access, and how they can use it. Also, you must design the database well so that it is easy for others to understand and use.
Now that you know how to create databases for yourself or a small group, it is time to learn how to share them, perhaps with many users.
By the end of this module, you will know how to:
- Set and modify an Access database password
- Use the Startup dialog options to customize the layout of your database and the functionality available to users
- Identify seven add-in utilities that increase the functionality of Access
- Encrypt and decrypt a database and identify the reasons to use encryption
- Define Replication, identify its purpose, and list the ways it can be done
- Create a copy of a database by using Replication, then synchronize the copies
These features are not for beginning users to jump into, but for users that want to take advantage of the more powerful features.
In the next lesson we will set and modify a database password.