Access delete table records

frature_access
This Access tutorial explains how to delete table records and delete records that exist in another table in Microsoft Access. Access delete table records You can always modify or delete table data manually by viewing the table and then press the delete button in keyboard. With Query, you can delete specific rows of record that meet the criteria. Note that you may delete data in an Access table, but you cannot delete data in linked table. For example, if your Access table is linked to Excel spr...
More

Access Instr Function

frature_access
This Access tutorial explains how to use Access INSTR Function in Expression and VBA, and explain difference among vbUseCompareOption, vbBinaryCompare and vbTextCompare. Access INSTR Function Access INSTR function is used to search a substring (part of the string) within a string (string is a text) and return the position of the first occurrence. For example, in the string “FinanceDepartment”, the substring “Department” can be found at 8th position within “FinanceDepartment”, the function w...
More

Access Mid Function to extract substring

frature_access
This Access tutorial explains how to use Access MID Function to extract substring from a string. Access MID Function MID Function is quite similar to LEFT Function and RIGHT Function, where RIGHT Function extracts a substring on the right, LEFT Function extracts a substring on the left, while MID extracts a substring in the middle of the string. Other than Access, Mid Function can also be used in Excel worksheet, Excel / Access VBA. Access MID Function is commonly used with Instr Function (...
More

MS Word VBA add footer to all word documents in folder

microsoft-word
This MS Word VBA tutorial explains how to add footer to all word documents in a folder automatically. MS Word VBA add footer to all word documents in a folder A couple of years ago, my manager asked me to add the keyword Public / Confidential / Restricted to all Word documents footers to meet compliance requirement (this is a common practice), I painfully did it manually for hundreds of documents. In fact it could have been done automatically. In some of my previous posts, I have demonstrate...
More

MS Access SQL select MAX record of each group

frature_access
This MS Access tutorial explains how to use Access SQL to select MAX record (MAX row) of each group. Access SQL select MAX record In Microsoft Access, you can select fields you need to Group and then use MAX to get the max record of each Group. However, the result only returns the grouped fields but not all the fields in the original table. In this tutorial I will show two methods to select all fields. Example - Select Max data Table1 below stores the performance rating of each employee in d...
More

Access VBA check if Query is empty

feature_access_vba
This Access tutorial explains how to check if table or Query is empty in Access VBA. You may also want to read: Microsoft Access VBA Export all Query to Text File Access VBA check if Query is empty In Access VBA, there are SQL related Functions that simulate SQL. Access DCOUNT Function is one to simulate SQL COUNT. To count the number of records in a Query, we can use * in the first argument of DCOUNT Function. For example, the below VBA counts the number of records in Query1 DC...
More

Access SQL SELECT DISTINCT Clause

frature_access
This Microsoft Access tutorial explains how to use SELECT DISTINCT Clause in Access Query. Microsoft Access SQL SELECT DISTINCT Clause SELECT DISTINCT can be used in Microsoft Access SQL to select unique values in a field. Note that you cannot use this keyword in Query Design View, you can only use it directly in SQL View. The outcome of DISTINCT is exactly the same as GROUP BY if you only try to find the unique values, but GROUP BY can be used together with other Aggregate Functions such a...
More

Access VBA NPV Function to calculate Net Present Value

feature_access_vba
This Access tutorial explains how to use NPV Function in Access VBA to calculate Net Present Value. You may also want to read: Excel NPV Function Net Present Value Net Present Value is to calculate the present value of future cash flow. For example, your client will give you $10000 when the project completes after 1 year, assume there will be inflation, the future $10000 will be less than the present $10000. Assume the inflation is 4%, the present value of $10000 is 10000/(1+4%) = 9615.3...
More

SPSS test reliability using Cronbach’s Alpha

spss
This SPSS tutorial explains how to test reliability using Cronbach's Alpha in SPSS. What is reliability and Cronbach's Alpha Reliability means whether the data are consistent using different instruments to measure the data. One example is the questionnaire design, in which more than one questions are asking the same thing but using different wordings. If the answers are inconsistent then the data has low reliability. Cronbach's Alpha is a common measure for reliability and internal consistency...
More

SPSS generate random number (decimal and whole number)

spss
This SPSS tutorial explains how to generate random number in SPSS (decimal and whole number). You may also want to read: Excel VBA generate non-duplicated random number Assign unique random number using Excel SPSS generate random number (decimal number) Assume that we have 10 data from 1 to 10.   Navigate to Transform > Compute Variable   On the left hand side, type a name for the Target Variable, which is the new variable that contains the random nu...
More