Access Database Recovery

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 »

How to Use Attachment Data Type to Store Multiple Files in a Record in MS Access

In this article, we will learn about the Attachment Data Type field in MS Access, its key details, and how to create a table with attachment data type column. If you needed proof regarding the versatility of MS Access, then here it is. This application might be used for storing small to big amounts of data, but it can also be used for storing different formats of data. Access databases are not just for storing textual or numeric data, but can also be used for storing information that is in...

Read more »