Vb Important Question per Chapters 10,11,12

Chapter 10 –

What do you mean by file organization? What are the different types of file organization?

What are the differences between a random file and a sequential file?

What are the three steps necessary to process data files?
List/tabulate and explain the file modes for data files.
What is the significance of a file number? What function can be used to determine an available file number?

Explain the differences between the Output and Append modes.

What is the format for the statements to read and write sequential files?

Explain what occurs when an Open statement is executed?

Explain the function EOF(N).

When would an On Error statement be used? Explain the three forms of the On Error statement.

Explain the function and use of the Err object. Explain its Source, Number and Description properties.

Explain the following –
QueryUnload event
The Raise method
The Resume statement and its three forms
Exit Sub and Exit Function statements
Get and Put statements
LOF function
Trim, LTrim and RTrim functions

How do we read and write a random file?

What does updating a data file mean?

Give example for using the InputBox function.


Chapter 11 –

Explain the difference between a data control and a data-bound control. List all controls that can be data bound or data aware.

Explain the BOF and EOF properties.

Explain the following properties –
Connect
DatabaseName
RecordSource
DataSource
DataField

Explain the following methods –
MoveNext
MovePrevious
MoveFirst
MoveLast
AddNew
Update
CancelUpdate
Delete

What steps are needed to add a new record to a database?

What steps are needed to delete a record from a database?

What steps are needed to change the data in a database record?

How can you check for the user deleting the only record in a Recordset?

Describe the following terms – file, record, current record, table, row, column, field, and key field w.r.t. a database.


Chapter 12 –

Differentiate among tables, dynasets, and snapshots recordsets

For which type(s) of recordset is a Find valid (FindFirst, FindNext, FindLast, or FindPrevious)? What types of data can be searched for with a Find?

For which type(s) of recordset is a Seek valid? Which fields in a recordset can be searched with a Seek?

What is SQL, and how is it used in Visual Basic?

When does a control's Validate event occur? How is the Cancel argument used? Explain the property Causes Validation.

Explain the following –

RecordCount and AbsolutePosition properties (write a small piece if code to display the record count and record number)

Reposition event

Explain the methods – FindFirst, FindLast, FindPrevious and FindNext

NoMatch property

BookMark property

Write a short note on MS DB Grid. Explain some of its properties.

Vb Important Question per Chapters 7,8,9

 Chapter 07 –

1. Explain List Box and Combo Box controls.

2. Name and describe the three styles of combo boxes.

3. Explain the following properties –

a. ListCount

b. ListIndex

c. List

d. AddItem

e. Clear

f. RemoveItem

g. Sorted

4. What are the different loop-constructs in VB?

5. Explain the difference between a pretest and a posttest in a Do/Loop.

6. Explain the differences between a Do/Loop and a For/Next loop.

7. How do the Left, Right, Mid and Len functions operate?

8. What is the purpose of Printer.Print? How do you control the horizontal spacing of printer output?

 Chapter 08 –

1. Define the following terms –

a. Array

b. Element

c. Subscript

d. Array of controls

e. Subscripted variable

2. Why would a list box control need both a ListIndex property and an ItemData property?

3. How to setup and use a control array?

4. Explain Select Case statement with an example.

5. Explain the use of For Each/Next in traversing the array.

6. Write a short note on user defined data types. Give an example.

7. What do you mean by multidimensional array? How do we implement it?

 Chapter 09 –

1. Explain the difference between ByVal and ByRef. When is each used?

2. What actions trigger the Initialize event and the Terminate event of an object?

3. What is a collection? Name two collections that are automatically built into VB.

4. What properties and methods are provided by the Collection object?

5. Write short notes on key features of object-oriented language.

6. Write a short note on class module.

7. Write a short note on Property Procedures.

8. (How do we create a new object using a class?) What are the three choices of creating a new object?

9. Explain early binding versus late binding.

10. Explain the following –

a. ActiveX control with an example

b. A DLL (Dynamic Link Library)?

c. API (Application Programming Interface)

Vb Important Question per Chapters 4,5,6

 Chapter 4 –

1. Explain the purpose of relational and logical operators.

2. Differentiate between a comparison performed on numeric data and a comparison performed on string data. How does VB compare the Text property of a text box?

3. Explain If ...Else construct and nesting.

4. Define the term Validation. When is it appropriate to do validation? Give three different cases.

5. Explain Message Box function and give an example of five message box constants.

6. Explain a Boolean variable. Give an example.

 Chapter 05 –

1. What does the term common dialog box mean? Name and explain atleast three types of common dialog boxes. What is the name of extension of the file in which common dialog box control is stored?

2. Explain the difference between a sub procedure and a function procedure.

3. What is a return value? How can it be used?

4. Explain the differences between ByRef and ByVal. When would each be used?

5. Explain the difference between a menu and a submenu.

 Chapter 06 –

1. What does the phrase standard code module mean?

2. Discuss the difference between declaring a variable in the General Declarations section of a standard code module and declaring a variable in the General Declarations section of a form code module.

3. What are the purposes of a splash screen and About box?

4. Explain the Hide and Show methods.

5. Explain the Form Load and Form Activate events.

6. What do you mean by modal and modeless forms?

7. Explain the Load and Unload statements.

8. Explain the Me keyword.

9. How do we declare a global variable and global constant?

10. Explain global and static variables.

11. Explain Dim, Public and Private keywords (for this, refer to other chapters also).

Vb Important Question per Chapters

 Chapter 1 –

1. What does cmdPush_Click mean? What does cmdPush in cmdPush_Click refer to? What does Click in cmdPush_Click refer to?

2. What is a Visual Basic event? Give some examples of events.

3. What is the purpose of Name property of a control?

4. What is the General Declarations section of a form module? What belongs there?

5. What are compile, run-time and logic errors, when do they occur and what might cause them?

6. What does context-sensitive Help mean? How can you use it to see the Help page for a command button?

 Chapter 2 –

1. How does the behavior of option buttons differ from the behavior of check boxes?

2. If you want two groups of option buttons (five option buttons in each group) on a form, how can you make the groups operate independently?

3. Answer the following –

a. What is the purpose of key-board access keys? How do they operate at run-time?

b. What is a ToolTip? How can you make a ToolTip appear?

c. What is a focus? How can you set the focus to a particular control?

d. What is concatenation and when would it be used?

e. How to continue a very long VB statement onto another line?

f. What is the default property of a control? Give an example.

4. How are the With and End With statements used? Give an example.

 Chapter 3 –

1. Distinguish between variables, constants, and controls.

2. Define Data type. Describe the various data types with the number of bytes occupied by them internally.

3. What do you mean by scope of a variable? Explain Procedure – level, Module – level and Global variables.

4. Explain the Naming Conventions and list the prefixes for the most common types of data types.

5. What is the purpose of the Val function?

6. What do you mean by Named and Intrinsic constants? Give one example for each.

7. Explain the following functions –

a. FormatCurrency

b. FormatNumber

c. FormatPercent

d. FormatDateTime

8. Write a short note on – Order of precedence.