• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Going Beyond the Basics

Chapter 15. Going Beyond the Basics

You have a lot of freedom when you create a database. If you create a database from scratch or modify a wizard-generated database significantly, you could wind up adding unnecessary complications such as tables that contain redundant fields or missing or unneeded relationships, for example. These ultimately make your database run slower than it should. You can use the Performance Analyzer to test your database's performance and suggest ways to improve your design.

If security is a concern, you can go beyond simply setting a password for the entire database. Indeed, you can assign each of your users permissions, which limit the ability to view, edit, and delete objects in your database. You can assign permissions individually, assign users to Access-defined groups with preset permissions, or create new groups with the permissions you want users of that type to have.

Finally, you can create projects, which are special types of files that allow your users to use an Access interface when they work with compatible SQL databases. We don't cover projects in detail, but we do want you to know that they are available. If you'd like more information on working with projects, you should refer to a more advanced text.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint