Chapter 8 Making It Easy for Others to Use Your Database

Key Points To open a Switchboard

  • On the Objects bar, click Forms, and then double-click Switchboard to open it in Form view. (Click the View button if you want to see it in other views.)

Creating a Splash Screen To create a splash screen

  1. On the Objects bar, click Forms, and then double-click Create form in Design view.

  2. Click the Save button, type a name in the Form Name box, and click OK.

  3. If the Properties dialog box is not already displayed, press .

  4. Set the form properties you want in the Properties dialog box.

  5. If the Toolbox is not displayed, click the Toolbox button, and then insert any objects you want to include on your splash screen, and format them as necessary.

  6. Save the design.

Keeping Your Application Healthy To create a backup of your database

  1. On the File menu, click Back Up Database.

  2. In the Save Backup As dialog box, navigate to the folder in which you want to store the backup, accept the file name Access provides, and click Save.

Keeping Your Application Healthy To run the Compact and Repair database feature

  • On the Tools menu, point to Database Utilities, and then click Compact and Repair Database, enabling macros when prompted.

Keeping Your Application Healthy To analyze performance

  1. Open the database you want to analyze, and then on the Tools menu, point to Analyze, and click Performance.

  2. To check the entire database, click the All Object Types tab.

  3. Click Select All, and then click OK to start the analyzer.

  4. Scroll through the list, click each entry in turn, and read through all the analysis notes, and click the Optimize button.

  5. Close the Performance Analyzer dialog box.

Keeping Your Application Healthy To run the Documenter

  1. On the Tools menu, point to Analyze, and then click Documenter.

  2. Click the All Object Types tab.

  3. Click Select All, and then click OK to start the documentation process.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset