Exercises


1. 

Describe two ways you can improve support for multiple users in your application.

image from book

2. 

Describe two ways you can improve the performance of your application.

image from book

3. 

What is involved in building a help system for your application?

image from book

4. 

Describe some ways you can add security to your application.

image from book

5. 

What is an ACCDE file? How does deploying your application using an ACCDE file differ from using the Access runtime version?

image from book

Answers

1. 

One way to improve support for multiple users is to ensure that the proper type of record locking is being used. If your application is using page or table locks, for example, then more records than the one being accessed will be locked and other users will be unable to modify them. With bound forms, you can modify table locks in Tools image from book Options on the Advanced tab. With unbound forms, you specify the lock type in your code, for example by setting the lock type of your ADO recordset. Another way to improve support for multiple users is to separate standalone Access databases into two separate files: one database file that contains the tables and is shared on a network and another database file with the user-interface objects that is loaded onto each user’s computer.

2. 

There are various ways to improve the performance of your Access applications. One way is to optimize the queries that retrieve data to ensure that they use the correct syntax, join to the correct tables, and use indexes so the retrieval will be faster. Another way to improve performance is to reduce the complexity of your forms, for instance by eliminating unnecessary controls and moving some code from forms to standard modules. Improving the code itself is another way to improve performance. For example, make sure to use the smallest data type you really need, make your procedures reusable to eliminate redundant code, and replace slower types of code statements with faster statements. If the user interface is separated into a separate database file than the tables, open the user-interface file exclusively to improve performance. Finally, the Performance Analyzer can help to identify areas for improvement.

3. 

To build a help system, you first create the content for the help system using any tool that can create HTML documents, such as Microsoft Word. You specify identifiers for the various topics so they can be retrieved later. After the help topics have been created and assigned identifiers, you then compile the help system into a help file and hook up the help system to your application. You assign your application to the help file just created. You then can set various properties in your application, for example at the form level or at a particular control level to point to a related help topic.

4. 

There are various ways to add security to your applications. For example, you can add a password to the database and a separate one to the source code. You can also add users and groups that have various security settings. For example, some users may have the ability to modify source code and data, while other users only have access to the data through the forms. By creating an ACCDE file, you can compile your application into a file that removes all source code. This is another way to add security to your application because it ensures that no one who opens that file can view or modify the source code.

5. 

ACCDE files are a special type of Access file that can be created to compile the database and remove all source code. An ACCDE file is one way you can distribute the application to end users. The Access runtime allows you to distribute your application to users who do not have a full version of Access installed on their computer. The Access runtime hides the database window from the users so they cannot modify the objects, such as the forms and reports. Built-in toolbars are not supported, so you have to build your own toolbars for the users. However, unlike ACCDE files, Access databases distributed with the runtime version still contain all of the code and could be opened by someone with the full version of Access.




Beginning Access 2007 VBA
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
Year: 2004
Pages: 143

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net