Access Solutions

How to Add Hyperlinks and Charts to a MS Access Report

By adding charts and hyperlinks in your Access reports, you can ensure that the reports become more visibly presentable and can link to data resources. Reports for an MS Access database help summarize what is contained in a database. The database reports is an essential feature of the application, which allows the user to quickly make sense of the data. With objects like hyperlink, charts and buttons, the report in MS Access will only become more comprehensive, detailed and informative....

Read more »

MS Access is Here to Stay – And It will Continue to Exist in Near future

In this article we look why it is likely that the MS Access database application will remain popular in coming years despite the availability of a plethora of enterprise grade RDBMS. MS Access was developed by Microsoft more than 2 decades ago, from then till now, the application has continuously been used and appreciated by millions of users all over the globe. Access was once a part of the MS Office applications in Windows editions for home use. But only recently, both Access and Excel...

Read more »

How to Create a Multi-column Lookup List in MS Access

In this article we look at quickly creating multi-column lookup lists in MS Access with minimum effort. A lookup field or a lookup list in MS Access allows users to efficiently enter data in a datasheet, by providing the user with multiple stored options of user friendly values, per record. These values are bound to other values in the value list. These lookup lists can be multi-column and/ or multi valued. A multi-column lookup list is one which consists of multiple columns of values, this...

Read more »