Access Query Tips

Use indexes on the fields in the criteria section when using the query design screen. In other words, index the fields on the right hand side of a where clause.

By Admin

Access Table Relationship Tips

Use the auto number field from the master table to create subordinate table relationships. A subordinate table is a detail table. This approach requires a corresponding long integer field in the subordinate table. Be aware that your Access subversion must be up to date in order to get good results.

By Admin

Access Database Naming Tips

Use short names when using a backend database in order design middleware between the frontend and the backend.

By Admin