Access database development Techniques (IV)

The skills of each subsystem integration

1, option group, switch button, combo box and other controls to use

Manipulating these controls on a form can be an organic way to control the system through a form that can be passed into conditions in queries, reports, and macros, making it easy to control queries, reports, and macros.

2, the Use of the tab control

The new tab control is added in Access version 97, which allows access to integrate more subsystems into a limited form. For example, in the "Print table" form, you can integrate the "score table", "very section tables", a single section of the statistics "subsystem", each subsystem corresponding to a tab page.

3, the use of switch panel forms

Use the switch panel form to integrate all the subform forms together. A switch panel form can be built by using a new form and placing command buttons on it to integrate the various subsystem forms. A switch panel form can be said to be a system main form that directs the user to select the desired action. We can also use the Switch panel Manager in Access to create a switch panel form. The specific methods are as follows:
① Click Tools, add-ins, and then click the Switch Panel Manager command.
② if Microsoft Access asks you whether you want to create a new switch panel, click the Yes button.
③ in the Switch Panel Manager dialog box, click the Edit button.
④ Enter the name of the switch panel in the Switch panel name box in the Edit Switch Panel page dialog box, and then click the New button.
⑤ in the text box of the Edit Switch Panel Item dialog box, enter the appropriate text for the first switch panel button, and then click the command you want in the Command box. If you enter print table in the text box, and then click Open Form as Edit in the Command box.
⑥microsoft whether Access will display the other side box under the Commands box depends on the command you clicked. If necessary, click an item in the box. For example, if you clicked the Open form as Edit command in step 5, in the command box, you can click the name of the form you want to open in the form box, such as Print table, and then click OK.
⑦ Repeat steps 4 through 6 until you have added all the items you want to add to the switch panel. To edit or delete an item, click the item in the items on the Switch panel box, and then click the Edit or Delete button. To reschedule an item, click the item in the box, and then click the Move Up or Move Down button.
⑧ Click the Close button.

Other Tips

1, often compressed database

The database can become fragmented and can not use disk space effectively when modifications to the database are continually added, deleted, and so on. Periodically compressing the database can reorganize the files and free up disk space and improve efficiency. Method: Click Tools, Database Utilities, compact Database command. According to the relevant information, the new version of Access 2000 can be closed every time the database file automatically completed this work, which will bring us great convenience.

2. Settings under multiple users

If you want to allow a database to be shared on a network, such as by several people on the network at the same time, or modify the data, you must set a lot of user options.
The way to set up multiple user options is:
① on the Tools menu, click Options.
② Click the "Advanced" tab to set it up.

3, encryption and generation of ". MdE" file

To keep the database system from being corrupted by others, you can encrypt the database or make the database an ". mde" file. Saving the database as an ". MDE" file compiles all modules, deletes all editable source code, and compresses the target database. Visual Basic Program code will continue to execute, but cannot be viewed or edited, and the size of the database will be reduced by the deletion of the program code. In addition, memory will be optimized for use, which will help improve performance. Saving the database as an. mde file prevents the following actions: View, modify, or create a form, report, or module in Design view, and you cannot view or edit visual Basic program code. The method for generating an. mde file is:
① closes the database. If you are working in a multiuser environment, make sure that all other users have closed the database.
② on the Tools menu, point to Database Utilities, and then click the Generate MDE File command.
③ on the Save Database as MDE dialog box, specify the database you want to save as an MDE file, and click the Generate MDE button.
④ on the Save MDE As dialog box, specify the name of the database, the drive, and the folder.