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

Caption Property

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

By Admin

Creating an Import Specification in Access 2003

When you want to import text files in Access it can be saved as a specification and imported using VBA code. Below is the step-by-step process for creating an Import Specification.

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

Benefits of Using Access

The Benefits of a Microsoft Access database are that it helps to quickly track and report information, having a rich user interface, and interactive design capabilities. It can also be used for web applications. Here are some categories that explain the detailed benefits of Microsoft Access databases:

By Admin