Office File Recovery

How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range

Using parameter query in MS Access is a child’s play; it is as easy as using a Criteria for creating a query. In this article we look at using them to limit records to a specific data range. A parameter query is one of the most useful and easiest ways of creating an advanced query. It is one of the most common methods used for creating queries. One of the unique features about parameter query is that it allows users to create queries which can be updated, during the command to reflect on...

Read more »

How and When to Use Quotation Marks In MS Access

Both users and developers at times use Quotation Marks while working with Access database. In this article we will learn such use case scenarios in detail. MS Access developers have regularly used Quotation marks for several purposes including most notably in SQL statements. Let look at some key situations where you need to use Quotation Marks: When a user wants to specify criteria for any domain aggregate function. When specifying or using criteria for Find method. When the user...

Read more »

How to Link MS Access 2016 with Data from Dynamics 365

In this article we look at linking MS Access with Microsoft’s cutting edge Dynamics 365 ERP platform to allow data synchronization. Microsoft allows users to link their MS Access data with Microsoft Dynamics 365, a powerful business management tool based on an intelligent cloud application that integrates ERP (Enterprise Resource Planning) modules in a single software package. Given the fact that Dynamics 365 spans across several modules like finance, sales, and CRM (Customer Relationship...

Read more »