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

Saving a Form

The final step is for you to save the Form object. This can be done at any time during the creation of the form. To save the Form, you can click on the ‘Save’ Button at the very top of the toolbar. (The Save Button looks like a disk icon.)

By Admin

Corruption Issues

When Access is not used properly, database corruption can often occur which results in an unusable database or a database that experiences random errors or performs inconsistently.

By Admin

Setting a Page Header

A Page Header is the text that displays at the top of the report page. To create a Page Header, select the ‘Label’ icon from the Toolbox. The Label icon has the capital and small letter A's.

By Admin

Saving a Report

The final step is to save the report object. Note: This can be done at any time during report creation.

By Admin