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 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

Properties Window

The Properties Window is found directly below the Project Explorer window. It displays the properties for the object currently highlighted in the Project Explorer. If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Properties Window under the View menu.

By Admin

Viewing a Report

Up until now, you have been editing and viewing your report in the Design View. Once the design has been completed, you will want to view your report as a user would view it.

By Admin

Objects in Project Explorer

You might assume that all of the Forms, Reports, and Modules that you create will automatically appear in the Project Explorer. However, this is not true. The VBA environment will only know about the objects if you tag them as "having a module".

By Admin