Access 2016: Formatting Forms by GCFLearnFree.org

Microsoft Access, Creating forms

When I put subforms into the main form, I need to make sure that the main ID and the sub IDs are all correct. I need to make this correct in three places.

Highlight the form by clicking on it to activate the property sheet. Find DATA, LINK CHILD FIELDS and specify the correct […]

Tips:Conversion from Excel Date to SAS Date

http://www.sascommunity.org/wiki/Tips:Conversion_from_Excel_Date_to_SAS_Date

 

When SAS-importing is not working

proc import out=work.test

datafile='C:\sastest\excelfile.xlsx'

dbms=xlsx replace;

sheet='Sheet1';

run;

proc export data=sashelp.class

outfile='C:\sastest\excelfile2.xlsx'

dbms=xlsx replace;

sheet='Sheet2';

run;

Logitech H800 no sound problem

I have to say I spent about an hour trying to figure out how to use it off a PC. It worked immediately for my Samsung phone, but it refused to produce sound off my PC. After internet-searching for solutions, I made it work. Here is how:

a) Go to http://support.logitech.com/en_us/product/wireless-headset-h800and scroll down to "Headset […]

R Studio

DPLYR is some kind of module that allows efficient data management.

library(dplyr)

 

This keeps rows that has a specified value:

filter(dataname,School=="Ad High School")

x <- filter(dataname,School=="Ad High School")

 

How to derive standard deviation from standard error

Algorithm:

SD=Standard error * sqrt(N);

 

Reference:

http://handbook.cochrane.org/chapter_7/7_7_3_2_obtaining_standard_deviations_from_standard_errors_and.htm

 

QC: I checked the algorithm using SAS. The result was consistent with the algorithm (i.e., SD=standard error*sqrt(N)).

proc means data=sashelp.class mean std stderr n; var height; run;

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ Mean 62.3368421

SD 5.1270752

Stadard Error 1.1762317

N 19 ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Open source softwares

 

–Python 3.5

https://www.python.org/downloads/

–PHP & MySQL (from WampServer)

http://www.wampserver.com/en/

Statistical Analysis Program

–R

https://cran.cnr.berkeley.edu/

–GPower

http://www.gpower.hhu.de/en.html

–Optimal Design

https://sites.google.com/site/optimaldesignsoftware/home

Editing Programs

— NotePad++

https://notepad-plus-plus.org/download/v7.1.html

–Sigil

https://github.com/Sigil-Ebook/Sigil/releases/tag/0.9.6 (There is a link to the exe file at the bottom of the page. […]

Code Academy PHP problem sets

<html> <p> <?php // Create an array and push on the names // of your closest family and friends $fam=array(); array_push($fam,"Jeana"); array_push($fam,"Niko"); array_push($fam,"Kaz"); array_push($fam,"Hiroko"); array_push($fam,"Yoko"); print count($fam); $n_elements=count($fam); // Sort the list sort($fam); // Randomly select a winner! $roll=rand(1,$n_elements); print $roll; $which_person= $array[$roll]; print $which_person; // Print the winner's name in ALL CAPS $which_person2=strtoupper($which_person); print […]

Data and Statistical Programming downloads

Programming

–Python 3.5

https://www.python.org/downloads/

 

–PHP & MySQL (from WampServer)

http://www.wampserver.com/en/

 

Statistical Analysis Program

–R

https://cran.cnr.berkeley.edu/

–GPower

http://www.gpower.hhu.de/en.html

–Optimal Design

https://sites.google.com/site/optimaldesignsoftware/home

 

Editing Programs

— NotePad++

https://notepad-plus-plus.org/download/v7.1.html

–Sigil

https://github.com/Sigil-Ebook/Sigil/releases/tag/0.9.6 (There is a link to the exe file at the bottom of the page.