Non-Programmers Desktop Choice

Microsoft Access is often the desktop solution of choice used by non-programmers to create their own customized database solution. The Access tables are easily customized and can support a variety of field types and indexes. Access also has the ability to enforce referential integrity which prevents the database from accepting ‘orphaned’ records which could corrupt your database. An orphaned record is a record that exists in the database and does not match any other records.

By Admin

Access Technical Limitations and Notes

Microsoft Access Table

By Admin

Set back ground image to Access form

Usually in Access applications, the form wizard has a white background. To get better visualization, we can set any image as the form background - similar to how we set our desktop backgrounds. Open the form in the design view. Select the property window...

By Admin

Access Report and Form Tips

Avoid restricting records or performing calculations within the form or report. Place record restrictions and complex calculations at the query level. Use a filter only if absolutely necessary and only at the query level.

By Admin

Security

Microsoft Access offers the following ways to secure the application while allowing users to remain productive: Database Password Workgroup Security Encryption MDE Version

By Admin