ACCDE for assets records.,

[vhung]

Hello AWF,

Please let me know if a newly created ACCDE is good or very good,
In other words how could i (evaluate) the project, is it by using a DOCUMENTER?

Any constructive remarks is appreciated.
Please see attached file,.

 

[The_Doc_Man]

First, it is harder to evaluate an .ACCDE since your ability to explore it is more limited than for an .ACCDB file of the same project. If you have the file only as an .ACCDE, you cannot look at anything in design mode and the module code isn't accessible either. Nor can you reverse the .ACCDE file back to the .ACCDB format. That conversion was a one-way street.

Second, your evaluation depends on (or at least, SHOULD depend on) factors we cannot answer here, so you will have to do the examination and evaluation. Further, the way to properly carry out the evaluation is tenuous since we don't know the style of the project. We don't know what "ease of use" features you will need since they depend on the control style & method for your project.

Even your choice of words in your question leads to an issue. What does "Good" or "Very Good" mean in this context? We could talk about completeness, but if there is no accompanying design goal document, it might be impossible to define those terms. Further, if there is any complexity to the event code for the various forms, testing might become a problem because it might not be easy - or worse, not POSSIBLE - to test all scenarios that this project might encounter.

Project evaluation includes many features.

• Ease of use to include good labeling of controls and conformance to aspects of the real-world process it represents
• Well-organized forms and reports that show what was intended WHEN it was intended to be shown
• Accuracy of any and all computations
• !!!!Conformance to design specifications
• Where options exist, every branch and combination of branches are testable - and tested
• Where anything can be looked up and additions are possible to what CAN be looked up, methods exist to make it easy to augment the list being queried
• Where a sequence of actions is required, the project file must support those actions in the proper sequence. If there is a problem caused by straying from that sequence, the project must prevent deviations from that sequence in the least disruptive manner.
• The project's design must conform to the business process being "modeled" so as to present familiarity to its users.
• IF the design includes role-based behavior (i.e. restrictions on who can de particular actions) then the DB must be more carefully secured. I.e. you cannot depend on users to NOT do the WRONG thing.

These are the big-picture questions I would ask of any large- or mid-scale project.

 

[GPGeorge]

Hello AWF,

Please let me know if a newly created ACCDE is good or very good,
In other words how could i evaluate the project, is it by using a DOCUMENTER?

Any constructive remarks is appreciated.
Please see attached file,.

The most basic question of all is this: "Given the design requirements specified for this database application, does it meet all of those requirements satisfactorily."

Since we can't see those requirements and can't see the database application itself, it's impossible to evaluate it.

The_Doc_Man has offered some detailed things for you to evaluate, though, and I'd strongly recommend you use them to evaluate your project yourself.

Also, the two possible evaluations offered as choices --"good" or "very good" -- suggests a request for validation, not evaluation. You may need to consider "unacceptable" as a possibility.

 

[vhung]

It is true, "harder to evaluate an .ACCDE"
I did go back to ACCDB.

Two process should be applied both the examination and evaluation.

I agree "about completeness"
"Further, if there is any complexity to the event code for the various forms, testing might become a problem because it might not be easy - or worse, not POSSIBLE - to test all scenarios that this project might encounter."

I've made adjustment with my Forms(design and data set/ connection)
This time, there is an existing cute/ single form created, which help me to open those 4 major Forms.

Good thing been observed is that it reduce the time of delay during OnLoad command,
_this cute form has filter command to reduces the quantity of data to be loaded, and codes OnTimer to each of the 4 major forms
The problem i found which is on DELAY during form OnLoad has been resolved,.
noted: data Tables is link from SQL server,. (on table:101 "3k+ rows")

To the REPORTS the filter is already set, base on the required output needed.
Where preview can access to email/outlook options,.

For now that was it, i'm still on the process to determined the important command to be added.

 

[CarlettoFed]

To evaluate a project, you should know, in detail, what you would like it to do and then see directly the structure you have created, so at least an example file.