USVI Public Records

Document text

DAT 115 Chp 4-6 Charles V. Balch, Mar 8 HomeWork Chp 4 Short Answer #1, Pg 193 Chp 5 Matching page 263, Fill in the blank pg 268 Chp 6 Matching B page 345 Chapter 4 Reports Detail: a line for each record. Summary: consolidate records Exception: Selected records (could also be consolidated) Query Reports: Could be any of above but an immediate response Also: Periodic Report Lines (pg 156) Heading: (usually titles, date, etc) Report, Page or section Column define fields Control heading separate one group from another Data (detail) each record Total (summary lines, section total, running total [chp 6]) Footer: (usually page number, H:\!DOCS\MSOFFICE\WINWORD\TEMPLATE\NORMAL.DOT DAT 115 Chp Notes 7 Charles V. Balch Charles V. Balch DAT 115 Chp 4-6 Charles V. Balch, Mar 8 HomeWork Chp 4 Short Answer #1, Pg 193 Chp 5 Matching page 263, Fill in the blank pg 268 Chp 6 Matching B page 345 Chapter 4 Reports Detail: a line for each record. Summary: consolidate records Exception: Selected records (could also be consolidated) Query Reports: Could be any of above but an immediate response Also: Periodic Report Lines (pg 156) Heading: (usually titles, date, etc) Report, Page or section Column define fields Control heading separate one group from another Data (detail) each record Total (summary lines, section total, running total [chp 6]) Footer: (usually page number, instructions etc, Report, Page or section Chapter 5 Special Fields Control Fields indicate an action to be done (routine to use) Codes (flags) are used to indicate class or status (note they need not be descriptive i.e. 1 = male) Control break (do something when a field changes) Discuss Printer Spacing charts pg 205, 212 Chapter 6 DAT 115 Chp 7Chapter 7Errors during Processing Translation errors are defined as errors that result during the translation process (usually as a result of syntax errors. The user should not see these. Most programs are compilde (not interpreted). Essentially, if it works Normal Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading 6 Default Paragraph Font Header Footnote Text List Table Footnote Reference Bibliography Example Quote Question Answer Heading UVZc0 Telecom_Out Telecom_In Page_Heading Title_Heading the first time it will continue to work. UNLESS the system is unstable (i.e. windows memory conflicts). Types of errors - Syntax (usually spelling or some such); Execution (logic) wrong field type, exceding a table size, infinite loops, math errors Types of Data Validation Check data type (numeric vs. string) Value Range (sign, not empty), reasonable (year) Batch vs.. On-line Data Entry and Validadtion Chp 7 page 428 Short Answers numbers 1-8 Chp 8 page 482 Multiple Choice numbers 1-5, Short Answer 1 a-j: Input Validation, sequence (check), consistency (rules)vsUser Friendly Programs Why is this brought up (discuss)? Menus (old), lists, icons Chapter 8: Extract Programs What do they do. Logical operators AND, Exclusive OR (XOR), OR, NOT Chapter 9: Using Tables Tables also called Lists, Arrays and Matrixs Permanent vs. Temporary compiledexceedingValidationMatrixes Sequential search - search entire table not efficient Binary search divides in half but table must be sorted Tables can have dimensions T115\CHì one dimension: simple list two dimension: associated list [Number Name Code] lookup Can be for data or for results Chapter 10: File Access Sequential Access: Record Indicator, Key field, Master Files: Transcation file: Merging/Matching Random Access: Known location Sequential EOF Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charlesñ Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4R DAT 115 Chp 4-6 Charles V. Balch, Mar 8 HomeWork Chp 4 Short Answer #1, Pg 193 Chp 5 Matching page 263, Fill in the blank pg 26 H:\!DOCS\MSOFFICE\WINWORD\TEMPLATE\NORMAL.DOT DAT 115 Chp Notes 7 Charles V. Balch Charles V. Balch Symbol Palatino Book Antiqua Courier Courier New DAT 115 Chp Notes 7 Charles V. Balch Charles V. Balch DAT 115 Chp 4-6 Charles V. Balch, Mar 8 HomeWork Chp 4 Short Answer #1, Pg 193 Chp 5 Matching page 263, Fill in the blank pg 268 Chp 6 Matching B page 345 Chapter 4 Reports Detail: a line for each record. Summary: consolidate records Exception: Selected records (could also be consolidated) Query Reports: Could be any of above but an immediate response Also: Periodic Report Lines (pg 156) Heading: (usually titles, date, etc) Report, Page or section Column define fields Control heading separate one group from another Data (detail) each record Total (summary lines, section total, running total [chp 6]) Footer: (usually page number, instructions etc, Report, Page or section Chapter 5 Special Fields Control Fields indicate an action to be done (routine to use) Codes (flags) are used to indicate class or status (note they need not be descriptive i.e. 1 = male) Control break (do something when a field changes) Discuss Printer Spacing charts pg 205, 212 Chapter 6 DAT 115 Chp 7Chapter 7Errors during Processing Translation errors are defined as errors that result during the translation process (usually as a result of syntax errors. The user should not see these. Most programs are compilde (not interpreted). Essentially, if it works Normal Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading 6 Default Paragraph Font Header Footnote Text List Table Footnote Reference Bibliography Example Quote Question Answer Heading UVZc0 Telecom_Out Telecom_In Page_Heading Title_Heading the first time it will continue to work. UNLESS the system is unstable (i.e. windows memory conflicts). Types of errors - Syntax (usually spelling or some such); Execution (logic) wrong field type, exceding a table size, infinite loops, math errors Types of Data Validation Check data type (numeric vs. string) Value Range (sign, not empty), reasonable (year) Batch vs.. On-line Data Entry and Validadtion Chp 7 page 428 Short Answers numbers 1-8 Chp 8 page 482 Multiple Choice numbers 1-5, Short Answer 1 a-j: Input Validation, sequence (check), consistency (rules)vsUser Friendly Programs Why is this brought up (discuss)? Menus (old), lists, icons Chapter 8: Extract Programs What do they do. Logical operators AND, Exclusive OR (XOR), OR, NOT Chapter 9: Using Tables Tables also called Lists, Arrays and Matrixs Permanent vs. Temporary compiledexceedingValidationMatrixes Sequential search - search entire table not efficient Binary search divides in half but table must be sorted Tables can have dimensions T115\CH.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4-5.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4-6.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOCÿ@Panasonic KX-P1124 LPT1: PANSON24 Panasonic KX-P1124 one dimension: simple list two dimension: associated list [Number Name Code] lookup Can be for data or for results Chapter 10: File Access Sequential Access: Record Indicator, Key field, Master Files: Transcation file: Merging/Matching Random Access: Known location Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charlesñ Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch C:\!DOCS\DAT115\CHP3.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4-5.DOC Charles V. Balch H:\!DOCS\DAT115\CHP4-6.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOC Charles V. Balch H:\!DOCS\DAT115\CHP7.DOCÿ@Panasonic KX-P1124 LPT1: PANSON24 Panasonic KX-P1124 Symbol Palatino Book Antiqua Courier Courier New DAT 115 Chp Notes 7 Charles V. Balch Charles V. Balch r switch