Rules to Better Access Databases

• Do use spaces in table names?
• Do you avoid underscores (preference only)?
• Do you have hidden tables or queries (Upsizing problem)?
• Do you always have a unique index on a table?
• Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?
• Do you have valid ValidationText property(Upsizing problem)?
• Do you use the Format and InputMask properties on a field?
• Do you use the Caption property on a field (Upsizing Problem)?
• Do you use the AllowZeroLength property on a field (Upsizing Problem)?
• Do you use the Required property on a field?
• Do you use a unique index and the Required property on a field?
• Do you use prefix sys in table name (Best Practice)?
• Schema - Do you always have version tracking tables?
• Do you have multiple key foreign key relationships on tables that map to fields of a different name (Upsizing Problem)?
• Do you have fields with multiple key indexes (Upsizing Problem)?
• Do you have complex queries (Upsizing Problem)?
• Do you remove VBA function names in queries before upsizing queries (Upsizing problem)?
• Do you avoid parameter queries with EXISTS keyword and comparison operators (<> or =)(Upsizing Problem)?
• Microsoft Access - Do you make response screens?
• Microsoft Access - Do you know the fastest way to add a new record in a large table?