Tips

..to previous page [5] ..to last page 


Tables
  • It is not good practice to use words like "name", "print", "report", "input" that could be used in other ways as field names.
  • Try to get used to using object programming conventions with field names. Use "joined" words. Any new words start with a capital (e.g. FullName, LastName)
  • For linking fields keep the field name in all tables the same, but try to give a meaningful name. E.g. EmpId rather than counter or code
  • When creating fields create in the following order;
    • Primary key fields
    • Secondary /related fields
    • Entity specific fields

Queries

Forms

Reports

Pages (Access 2000+)

Macros

Modules
 

[Rev 15/01/01 ] 12/5/98 © 1998-2000 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.