Microsoft Access Count Distinct Values Function
Ms Access Count Distinct function in normal SQL language is the function to determine the number of records of different non-NULL values, while Count function return the number of records…
Lookup Wizard in Microsoft Access 2013 and 2016
The Lookup wizard in Microsoft Access 2013 is the feature for creating the lookup field. With the lookup field, you can create the relation for one table with other tables…
File Extension of MS Access 2003-2016 Version
The file extension Of MS Access has been changing following the years and the software version. The very first Access version is Access 1.1. Up until Access 2003, the past…
Upload and Publish Access Database on SharePoint
This tutorial will guide you to upload and publish microsoft access database on sharePoint. SharePoint is web based application that integrates with Microsoft Office, which designed for document management, storage…
Access Database Multiple Users Split and Share
Access Database Multiple Users Split or Share Function – Because it is part of Ms. Office Products which is offline in usage, many people thought that Access cannot handle multiple users for…
Ms Access Union Query SQL Function Syntax
Ms Access Union Query is the SQL function to combine multiple tables or queries into a single result, its not the same as the Select function, because Select take the…
MS Access Substring Function
Microsoft Access Substring function is mainly to extract the characters in the string. As we all know, the Substring function is not existed in Access, both in query or VBA…