Viewing a Form

Once you have placed your objects where you would like them to appear on the form, you will want to view the form as a user would. Up until now, you have been in what is referred to as the ‘Design’ view.

By Admin

Caption

Caption is the name that displays in the title bar at the very top of the form. In the example below, the Caption field was edited to display "Add/Edit Suppliers"

By Admin

Adding Objects to the Report

When you return to the Properties window for the Report object, you will see the SQL details in the Record Source field. Now that you have identified which table or tables to select data from, objects need to be added from the table(s) to the report.

By Admin

Hardware Recommendations For Running Access

Hardware matters. Invest in a faster PC and Microsoft Access databases will run faster. Be alert for sellers packaging fast processors with minimal memory and a slow hard drive to keep prices low. Look at all aspects of the purchase when database speed is a priority. A faster hard drive is worth the investment and more memory will help!

By Admin

Access Databases Compacting Tips

Compact an Access database periodically by selecting 'Compact and Repair'. Compacting allows Access to rearrange the data in the same way you might rearrange your spice shelf. It fills in the space left behind by the deleted objects.

By Admin