142 Final Course Review

1
142 Final Course Review

• By Shawn

2
Final Examination

• Multiple Choice (50)
• VB Short Answer (34)
• Theory
• Code (Fill in blanks, short blocks)
• Algorithm Tracing (esp. Loops)
• VB Programming (16)
• For this review Anything in red is not in the
  exam

3
Chapter 6 - Functions

• String Functions
• Ucase(String), Lcase(String)
• Ltrim (String), Rtrim(String), Trim (String)
• Left, Right (String, Length)
• Mid (String, Start, Length (opt))
• Space
• InStr (Target String, Search String, Case)
• Len( )
• Conversion Functions
• Str, Val
• Cdate, other conversions (Cbool, )

4
Chapter 6 - Functions

• Math Functions
• Int, Fix (Watch Negatives Int(-199.11) -200,
  Fix(-199.11) -199
• Round
• Sqr
• IsNumeric, ..Date,
• Date, Time
• Rnd ? Int(Rnd() Range ) Offset
• Format
• Currency, Fixed, Percent
• 0.,gt
• FormatCurrency,

5
Chapter 6 - Functions

• User Defined Sub-Procedure (Week 5)
• Units of code that are NOT associated with a
  specific event/control and can be used anywhere
  on a form or in the project
• Call
• Functions (Week 9)
• A function returns a value through its name
• Arguments (in the call) vs Parameters (in the
  function)
• Scope FunctionName (ArgList) as Type
• Variable FunctionName (ArgList)
• Pass By Reference, Pass By Value
• ByVal, ByRef
• Event Procedure (Week 9)
• Click, Form_Load, Set LostFocus, KeyPress,
  GotFocus
• MouseUp, Down, etc..

6
Chapter 7 - Repetition

• Looping
• For / Next
• Counters (Step)
• Incrementing and decrement
• Do While
• Do Until
• Post-test vs. Pre-test
• Definite vs. Indefinite

7
Chapter 8 - Arrays

• Variable Arrays (Week 5 6)
• Dim arrayname (lower bound to higher bound) as
  Datatype
• Two Dimensional (Week 10)
• Dim arrayname (Rows, columns) as datatype
• Control Arrays (Week 5)
• lblAddress(index).Caption
• User Defined Types (Week 10)
• Collections of different data types
• Not arrays
• Type End Type

8
Chapter 9.1

• Sequential files (Week 5)
• Fields Data element single piece of info
  about a person, place, or thing
• Records Group of related info about a person,
  place, or thing
• Data file A collection of related records
• Sequential files access records in consecutive
  order, Random, Binary
• Fixed-Width, Comma Delimited
• Open pathname for mode as filenumber
• Pathname filename and location
• Mode Input, Output, Append
• Filenumber Unique file handle 1 to 511
• Write filenumber, info write a record to a
  file (Write 1 , writes a blank line) and
  forwards to next record
• Input filenumber, variablelist reads info
  from a file and forwards to next record
• Close filenumber close the file
• EOF(filenumber) determine end of file
• Line Input , Print , PadRight

9
Chapter 10 11

• Databases (Week 7)
• Relational database stores info in tables
  accessed in rows and columns
• Five steps to make a database
• Identify, Organize, Establish relationships,
  Index, Data validation
• Index Index field, pointer field
• UDA Universal data access
• OLE DB Object Linking and Embedding Database
• ADO ActiveX Data Object
• SQL Structured Query Language
• Select Command Select fields from table where
  condition order by field
• RecordSource which records in the database you
  want to access (table)
• RecordSet object, and the Refresh Method
• Fields object
• Addnew, CancelUpdate, Delete, Movefirst,
  MoveNext, Update
• Dot member selection operator
• Refresh

10
From The Notes

• List Boxes (Week 5)
• .addItem, .Clear, .Text
• Array Manipulation (Week 6)
• The Search
• Max / Min
• The Bubble Sort
• Refinement 1 (Usually not 2)
• Array deletes, parallel arrays

11
From The Notes

• Common Dialog Boxes know names and what they do
• Dlgcommon.dialogbox (ShowOpen, ShowSave,
  ShowPrinter, ShowColor, ShowFont)
• Object.Filter description1filter1description2
  filter2.
• Understand flags
• Error Handling - On Error Goto line .. Exit sub..
  Line
• On Error Resume 0 turn error trapping off
• Err.description, err.number
• Resume
• Control User actions, good data formatting

12
From The Slides

• VBA Excel
• Spreadsheet, Cells (Reference)
• Range, Functions
• Formulae, copying, absolute
• Macros
• Reference sheets in Code
• IsNumeric, IsText

13
From The Slides

• VBA Excel (cond)
• Autofit, .Font
• ActiveSheet selections

14
Overall

• Know Vb Project contains
• Form
• Variables (module/form level)
• Controls
• Event procedure
• Instruction Variables (local)
• Code Module
• Variables (global/public)
• Procedures
• Instruction Variables

15
What

• Text Book (chapters 5-10)
• Chapter 7 (no flex grid)
• Chapter 8 (no user defined types)
• Chapter 9 (no Random Access Files)
• Chapter 10 (no adding / deleting data, no
  creating databases using VB)

16
What ctd.

• Assignments
• VB2
• No explicit questions but should understand
  fundamental algorithms very well
• VBA
• No explicit questions but should understand
  fundamental algorithms very well
• Class Notes
• Starting w/ Set5_W04.ppt

17
The End

• Have a great summer and I hope to see all of you
  in the IS concentration next year.and
  rememberIS isnt all programming!!