Access Solutions

How to Quickly Invoke Mail Merge from MS Access

Using this article reader can learn to invoke Mail Merge from MS access effectively in quick time. Users can create and print form letters in Microsoft Word using Mail Merge. For example, Employment Contracts, which have fixed employment terms, with changing personal details of the employees like their name, allowance, and contract period etc. which can go on for several pages. Normally the document needs to be pre-printed where the employees’ details can be printed or hand written. But...

Read more »

How to Summarize Data in MS Access using Crosstab Query

Here we learn about the use of Crosstab Queries in MS Access, and how to create them. When you are working on Access databases, and need a summary that looks more like an Excel spreadsheet, you might want to try using the Crosstab Query. Just like an Aggregate Query gives you an aggregate of certain fields, a Crosstab Query can give you a comprehensive summary of certain fields. Plus an Aggregate query can be used when you are looking for one final number, the function of Crosstab query is...

Read more »

How to Enable and Use Large Number Data Type in MS Access

In this article, we learn how can Large Number Data type be added in an Access table, and what will be its impact.  Even if you are not an enterprise level business, there might be situations when you need to deal with very large numbers. These do not have to be monetary figures and can be a result of any calculation you performed with the available data. The large number data type field in Access anyway does not take up monetary value, it is helpful if you have some really big numbers to...

Read more »