About creating an application

About creating an application

After you become familiar with Microsoft Access and learn how to create tables, queries, forms, reports, custom command bars, and so on, you can add macros and Visual Basic for Applications code to tie these objects together in an application. An application organizes related tasks so that the user can focus on the job at hand, not on how the application works or on the program used to develop the application. For comprehensive information on creating an application, see Building Applications with Forms and Reports. You can also ask the Office Assistant about specific topics.

You can control how your application looks and behaves when it starts by setting options in the Startup dialog box (Tools menu). For example, you can indicate which form your application displays when it starts, or you can specify the text that appears in the title bar while your application is running. For more information, see Building Applications or click .

If you plan to distribute your application to other users, you might want to establish security to protect the objects you have created, as well as the data in your tables. For more information on security, see Building Applications or click .

After your application has been distributed, use the maintenance tools provided by Microsoft Access to periodically compact and repair the database. Be sure to provide a way for users at remote locations to do this as well. For more information, see Building Applications. For information on repairing and compacting a database, click .

Note   In addition to the tools and information provided by Microsoft Access to assist you with application development, Microsoft Office 2000 Developer provides tools to help you develop Microsoft Windows-compatible and Office-compatible applications. For information on what tools Microsoft Office 2000 Developer includes, click .