SPSS test reliability using Cronbach’s Alpha

Posted on April 22, 2016 by Wyman W

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...

SPSS generate random number (decimal and whole number)

Posted on April 20, 2016 by Wyman W

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...

SPSS Simple Random Sampling using Select Cases

Posted on April 19, 2016 by Wyman W

This SPSS tutorial explains how to conduct Simple Random Sampling using Select Cases in SPSS. You may also want to read: Excel VBA generate non-duplicated random number Assign unique random number using Excel SPSS Simple Random Sampling In conventional simple random sampling, you need to assign an ascending number to each value of a variable and then generate a random number to help you select the corresponding data. While SPSS can generate random number using Compute Variable, it ...

SPSS Automatic Recode

Posted on April 18, 2016 by Wyman W

This SPSS tutorial explains how to use SPSS Automatic Recode to convert variable from string to number (from Nominal to Scale). SPSS Automatic Recode In SPSS, the ideal data source is to convert all nominal data to numeric data, and then use Value Labels to map the corresponding text, it is because many analysis cannot use nominal data. Automatic Recode is a function to create a new column and automatically convert nominal variable from text to number. It also allows conversion of numeric v...

Access Report group by date problem

Posted on March 25, 2016 by Wyman W

This Access tutorial explains how to group by date (one date for each group) in Access Report and explain the issue. You may also want to read: Access Report keep a group together in one page Access Report group by date problem When you create an Access Report, the default setting isn't group by date. To illustrate, assume that we have an employee database as below. Table1 Hire Date Employee ID 20/12/2016 001 20/12/2016 002 21/12/2016 003 21/12/2016...

Access first date of month and last date of month

Posted on March 14, 2016 by Wyman W

This Access tutorial explains how to find first date of month, last date of month using Access Expression and VBA Function. You may also want to read: Excel first date of month and last date of month Access first date of month To find first date of month in Access, first we have to understand DateSerial, you can use it to combine the year, month and day to a date. Syntax of Date Function DateSerial( year, month, day ) Example Formula Result Explanation DateSerial(2012,1,...

Get exchange rate using VBA Access Function

Posted on January 18, 2016July 24, 2017 by Wyman W

This tutorial demonstrates how to create a VBA custom function (UDF) in Microsoft Access in order to get the real time exchange rate. You may also want to read Get Foreign Exchange Rate in Excel Get exchange rate using VBA Access Function Yahoo Finance is designed in the way to facilitate you to get data. You can establish a connection to Yahoo and directly get the exchange rate using User Defined Function. Open Access, press ALT+F11 > Tools > References > enable "Microsoft W...

Access VBA DoCmd.TransferText Method

Posted on January 10, 2016June 12, 2017 by Wyman W

This Access VBA tutorial explains how to import and export Access Objects to text using DoCmd.TransferText Method. You may also want to read Access VBA Export all Queries to Excel Access VBA import txt using DoCmd.TransferText Method Syntax of DoCmd.TransferText Method DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) Name Required/Optional Data Type Description TransferType Optional AcTextTransferType T...

Microsoft Access VBA Export all Query to Text File

Posted on January 10, 2016January 10, 2016 by Wyman W

This Access tutorial explains how to use Access VBA to export all Query to Text file. You may also want to read: Microsoft Access Export all Queries to Excel Access VBA DoCmd.TransferText Method Export Access Objects to Text (non VBA) There are two kinds of export that we can use to export an Access object to Text file. Assume that we want to export Query1 to Text. Right click on the Query > Export > Text File This page has a check box Export data with format...

Microsoft Access Export all Queries to Excel

Posted on January 8, 2016June 1, 2016 by Wyman W

This Access tutorial explains how to export all Queries to Excel. You may also want to read: Access VBA auto generate mass report by group to Excel Microsoft Access Export all Queries to Excel Assume that you have created three Queries in Access database, all you want to export them to Excel. Press ALT+F11 > insert a Module > paste the below code Public Sub export_Excel() Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDb() For Each ...