DOC PREVIEW
MSU FW 893 - Lecture 6

This preview shows page 1-2-3-4-5 out of 14 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 14 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Data EntrySlide 2Comparing FilesSlide 4Slide 5Slide 6Validation RulesPrinciples for shuttling data between programsSlide 9Slide 10MetadataSlide 12Slide 13Using Forms and Reports in AccessData Entry•Goal is to accurately transcribe data from data sheets into electronic form–Good database design helps–Validation rules help–Good data sheet design (e.g., pre-numbering items) helps•I don’t know of any substitute for double-entry, however!“Original Data” 1 107 11.37 80.68 22.79 65.95 2 70 4.29 78.03 28.44 62.15 3 123 18.22 79.86 26.39 53.92 4 118 16.23 81.12 21.64 67.65 5 105 11.93 78.23 22.41 53.21 6 133 24.14 80.07 24.02 68.73 7 96 10.16 81.39 18.57 59.00 8 126 20.39 78.92 22.76 68.43 9 48 1.07 79.71 21.23 68.8310 80 5.59 81.23 37.46 61.5211 95 9.00 79.27 26.45 60.3312 88 7.05 79.34 28.63 65.1913 92 8.37 78.24 24.45 61.5714 99 9.06 79.19 22.08 63.9115 97 9.42 79.57 21.45 63.3616 133 20.41 80.03 22.15 62.1017 93 7.79 78.92 16.93 58.2718 76 4.86 79.28 24.73 60.4819 74 5.01 80.27 23.04 65.2020 80 5.56 79.68 16.75 64.3821 129 19.93 80.28 28.09 68.1722 95 8.75 77.35 22.09 57.7523 92 7.71 80.72 22.51 54.4224 115 17.30 79.31 23.36 69.3425 131 18.99 80.25 24.72 65.4726 85 6.11 78.76 21.69 61.1427 115 15.15 78.03 33.18 69.7928 72 3.67 77.97 25.11 66.0529 104 10.65 79.90 14.90 64.9030 94 8.56 79.76 24.85 71.73“Copy” 1 107 11.37 80.68 22.79 65.95 2 70 4.29 78.03 28.44 62.1 3 123 18.22 79.86 26.36 53.92 4 118 16.23 81.12 21.64 67.65 5 105 11.93 78.23 22.41 53.21 5 105 11.93 78.23 22.41 53.21 6 133 24.14 80.07 24.02 68.73 7 196 10.16 81.39 18.57 59.00 8 126 20.39 78.92 22.76 68.43 9 48 1.07 79.71 21.23 68.8310 80 5.59 81.23 37.46 61.5211 95 9.00 79.27 26.45 60.3312 88 7.05 79.34 28.63 65.1913 92 8.37 78.24 24.45 61.5714 99 9.06 79.19 22.08 63.9115 97 9.42 79.57 21.45 63.3617 93 7.79 78.92 16.93 58.2718 96 4.86 79.28 24.73 60.4819 74 5.01 80.27 23.04 65.2020 80 5.56 79.68 16.75 64.3821 129 19.93 80.23 28.O9 68.1722 95 8.75 77.35 22.09 57.7523 92 7.71 80.72 22.51 54.4224 1l5 17.30 79.31 23.36 69.3425 131 18.99 80.25 24.72 65.4726 85 6.61 78.76 21.69 61.1427 115 15.15 77.97 33.18 69.7928 72 3.67 78.03 25.11 66.0529 104 10.65 79.90 14.90 64.9030 94 8.56 79.76 24.85 71.72Comparing Files•Save files as “ASCII DOS TEXT”•Use Command Prompt (in Accessories)•For output to screen, type–fc filename1 filename2•For output to a new file, type–fc filename1 filename2 >newfileComparing files Copy of data.txt and ORIGINAL DATA.TXT***** Copy of data.txt"Copy"***** ORIGINAL DATA.TXT"Original Data"********** Copy of data.txt 1 107 11.37 80.68 22.79 65.95 2 70 4.29 78.03 28.44 62.15 3 123 18.22 79.86 26.36 53.92 4 118 16.23 81.12 21.64 67.65***** ORIGINAL DATA.TXT 1 107 11.37 80.68 22.79 65.95 2 70 4.29 78.03 28.44 62.15 3 123 18.22 79.86 26.39 53.92 4 118 16.23 81.12 21.64 67.65********** Copy of data.txt 5 105 11.93 78.23 22.41 53.21 5 105 11.93 78.23 22.41 53.21 6 133 24.14 80.07 24.02 68.73 7 196 10.16 81.39 18.57 59.00 8 126 20.39 78.92 22.76 68.43***** ORIGINAL DATA.TXT 5 105 11.93 78.23 22.41 53.21 6 133 24.14 80.07 24.02 68.73 7 96 10.16 81.39 18.57 59.00 8 126 20.39 78.92 22.76 68.43********** Copy of data.txt15 97 9.42 79.57 21.45 63.3617 93 7.79 78.92 16.93 58.2718 96 4.86 79.28 24.73 60.4819 74 5.01 80.27 23.04 65.20***** ORIGINAL DATA.TXT15 97 9.42 79.57 21.45 63.3616 133 20.41 80.03 22.15 62.1017 93 7.79 78.92 16.93 58.2718 76 4.86 79.28 24.73 60.4819 74 5.01 80.27 23.04 65.20********** Copy of data.txt20 80 5.56 79.68 16.75 64.3821 129 19.93 80.23 28.O9 68.1722 95 8.75 77.35 22.09 57.75***** ORIGINAL DATA.TXT20 80 5.56 79.68 16.75 64.3821 129 19.93 80.28 28.09 68.1722 95 8.75 77.35 22.09 57.75********** Copy of data.txt23 92 7.71 80.72 22.51 54.4224 1l5 17.30 79.31 23.36 69.3425 131 18.99 80.25 24.72 65.4726 85 6.61 78.76 21.69 61.1427 115 15.15 77.97 33.18 69.7928 72 3.67 78.03 25.11 66.0529 104 10.65 79.90 14.90 64.9030 94 8.56 79.76 24.85 71.72***** ORIGINAL DATA.TXT23 92 7.71 80.72 22.51 54.4224 115 17.30 79.31 23.36 69.3425 131 18.99 80.25 24.72 65.4726 85 6.11 78.76 21.69 61.1427 115 15.15 78.03 33.18 69.7928 72 3.67 77.97 25.11 66.0529 104 10.65 79.90 14.90 64.9030 94 8.56 79.76 24.85 71.73*****“ C o p y ” O r i g i n a l D a t a ” 1 1 0 7 1 1 . 3 7 8 0 . 6 8 2 2 . 7 9 6 5 . 9 5 2 7 0 4 . 2 9 7 8 . 0 3 2 8 . 4 4 6 2 . 1 5 3 1 2 3 1 8 . 2 2 7 9 . 8 6 2 6 . 3 6 9 5 3 . 9 2 4 1 1 8 1 6 . 2 3 8 1 . 1 2 2 1 . 6 4 6 7 . 6 5 5 1 0 5 1 1 . 9 3 7 8 . 2 3 2 2 . 4 1 5 3 . 2 1 5 1 0 5 1 1 . 9 3 7 8 . 2 3 2 2 . 4 1 5 3 . 2 1 6 1 3 3 2 4 . 1 4 8 0 . 0 7 2 4 . 0 2 6 8 . 7 3 7 1 9 6 9 6 1 0 . 1 6 8 1 . 3 9 1 8 . 5 7 5 9 . 0 0 8 1 2 6 2 0 . 3 9 7 8 . 9 2 2 2 . 7 6 6 8 . 4 3 9 4 8 1 . 0 7 7 9 . 7 1 2 1 . 2 3 6 8 . 8 31 0 8 0 5 . 5 9 8 1 . 2 3 3 7 . 4 6 6 1 . 5 21 1 9 5 9 . 0 0 7 9 . 2 7 2 6 . 4 5 6 0 . 3 31 2 8 8 7 . 0 5 7 9 . 3 4 2 8 . 6 3 6 5 . 1 91 3 9 2 8 . 3 7 7 8 . 2 4 2 4 . 4 5 6 1 . 5 71 4 9 9 9 . 0 6 7 9 . 1 9 2 2 . 0 8 6 3 . 9 11 5 9 7 9 . 4 2 7 9 . 5 7 2 1 . 4 5 6 3 . 3 61 6 1 3 3 2 0 . 4 1 8 0 . 0 3 2 2 . 1 5 6 2 . 1 01 7 9 3 7 . 7 9 7 8 . 9 2 1 6 . 9 3 5 8 . 2 71 8 9 6 7 6 4 . 8 6 7 9 . 2 8 2 4 . 7 3 6 0 . 4 81 9 7 4 5 . 0 1 8 0 . 2 7 2 3 . 0 4 6 5 . 2 02 0 8 0 5 . 5 6 7 9 . 6 8 1 6 . 7 5 6 4 . 3 82 1 1 2 …


View Full Document

MSU FW 893 - Lecture 6

Documents in this Course
Load more
Download Lecture 6
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Lecture 6 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Lecture 6 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?