batch processing
Batch processing is adopted to avoid record-by-record processing and make full use of the powerful functions of SQL statements.
standardize
In-depth study of relational database theory, especially standardization theory. When designing tables, please ensure that at least the requirements of the third normal form are met. Master set operations (union, intersection and difference) and relational operations (selection, projection and connection), and you will find that connection and normalization are closely linked.
OO
Use object-oriented technology: from object-oriented analysis (OOA) to object-oriented design (OOD) to object-oriented programming (OOP). According to the relationship among tables, forms and sub-forms, simulation with reports and sub-reports can greatly improve the readability and maintainability of the program.
Query results show that
The query results can be displayed by forms or reports, which are technically interlinked. By adjusting the display conditions of a form or report, you can control the range of records displayed. When using a query as a data source, it is more convenient to dynamically change SQL statements than to reference form controls in the query. Because SQL statements are generated in VBA, they can be stored in character variables first, and then the SQL statements of the query can be updated.
algorithm design
To develop a system, we must first solve technical problems, that is, algorithms. Understand the algorithm through a simple example, and then design it in detail. As can be seen from the questions from netizens, many people are unclear about the problem, and there are many professional contents unrelated to the algorithm, which makes it difficult for others to understand.
Use of tool functions
Avoid using too many tool features, because this will reduce the readability, maintainability and portability of the code. When you need others' help, they may find it difficult to help. More importantly, in the process of migrating from MDB to ADP, you will find that portability is particularly important.