Access Solutions

How to Make Pivot Charts in MS Access

In this article we look at the steps involved in creating Pivot charts in MS Access in quick time. You might already be aware of the charting feature in MS Excel, but MS Access too, comes built in with a great charting feature. The basics of both these are pretty much the same and Access has some brilliant charting tools. You need Pivot Charts when you wish to do an interactive analysis. A Pivot Chart is simply a graphical representation of the data in a Pivot Table. There are two types of...

Read more »

4 Ways to Log Error in MS Access – A Primer

In this article we look at several ways at logging errors in MS Access for reference and corrective action. There is no limitation to how many times can a user encounter error in an Access databases. There can be multiple reasons for varied errors to arise. However, to avoid an error from recurring, the user can always opt for logging errors. Logging error in MS Access involves maintaining a record of what all errors occur, when, and how frequently. This helps you avoid a recurring error...

Read more »

Subreports – Why Do You Need Them in Access?

In this article we explore the need of subreports and learn to create them too. We create reports in MS Access to summarize data in a database, but there might be a need to create a summary of two related tables, in this situation, a user can make use of a subreport. Subreports are the reports of related tables and not complete databases, these can be inserted in a main report. Subreports prove to be an essential part of the Report feature in MS Access, by using subreports apart from the...

Read more »