Programming With Microsoft Visual Basic 2017 8th Edition Diane Zak - Solutions

Open the Proper Case Solution.sln file contained in the VB2017\Chap07\Proper Case Solution folder. The interface provides a text box for entering a person’s first and last names. The btnProper_Click procedure should display the first and last names in the proper case. In other words, the first
Open the Color Solution.sln file contained in the VB2017\Chap07\Color Solution folder. The btnDisplay_Click procedure should display the color of the item whose item number is entered by the user. All item numbers contain exactly five characters. All items are available in four colors: blue, green,
In this exercise, you modify the Password application from this chapter’s Apply lesson. Use Windows to make a copy of the Password Solution folder. Rename the copy Password Solution-Spaces. Open the Password Solution.sln file contained in the Password Solution-Spaces folder.a. Start the
Open the Validate ISBN Solution.sln file contained in the VB2017\Chap07\Validate ISBN Solution folder. The interface provides a text box for entering a 13-character ISBN. The btnValidate_Click procedure should use the ISBN’s check digit, which is the last digit in the number, to determine whether
In this exercise, you modify the Password application from this chapter’s Apply lesson. Use Windows to make a copy of the Password Solution folder. Rename the copy Modified Password Solution. Open the Password Solution.sln file contained in the Modified Password Solution folder. The
In this exercise, you modify the Check Digit application from this chapter’s Apply lesson. Use Windows to make a copy of the Check Digit Solution folder. Rename the copy Check Digit Solution-Hyphens. Open the Check Digit Solution.sln file contained in the Check Digit Solution-Hyphens
Which method right-aligns a string?a. PadLeftb. PadRightc. LeftAlignd. RightAlign
Which property allows you to specify a specific character that will always be displayed in a text box, no matter what character the user types?a. Charb. CharPasswordc. Passwordd. PasswordChar
Which property specifies the number of characters that a text box will accept?a. Lengthb. MaxLengthc. LengthMaxd. Maximum
Which of the following statements enables the btnClear control?a. btnClear.Enabled()b. btnClear.Enabled = Yesc. btnClear.Enabled = Trued. btnClear.Enable = True
Which of the following statements sends the focus to the btnClear control?a. btnClear.Focus()b. btnClear.Focus() = Truec. btnClear.SendFocus()d. btnClear.SetFocus()
Which of the following statements generates a random integer from 1 to 25 (including 25)?a. intNum = randGen.Next(1, 25)b. intNum = randGen.Next(1, 26)c. intNum = randGen(1, 25)d. intNum = randGen.NextNumber(1, 26)
Which of the following statements declares an object to represent the pseudo-random number generator in a procedure?a. Dim randGen As New RandomNumberb. Dim randGen As New Generatorc. Dim randGen As New Randomd. Dim randGen As New RandomObject
Which of the following expressions evaluates to True when the strItem variable contains the string “1234Y5”?a. strItem Like "####[A-Z]#"b. strItem Like "9999[A-Z]9"c. strItem Like "######"d. None of the above.
Which of the following statements changes the contents of the strSocSec variable from “000-11-2222” to “000112222”?a. strSocSec = strSocSec.Remove("–")b. strSocSec = strSocSec.RemoveAll("–")c. strSocSec = strSocSec.Replace("–","")d. strSocSec = strSocSec.ReplaceAll("–")
If the strWord variable contains the string “spring”, which of the following statements assigns the letter r to the strLetter variable?a. strLetter = strWord.Substring(2)b. strLetter = strWord(2)c. strLetter = strWord(2, 1)d. All of the above.
Which of the following statements changes the contents of the strZip variable from 60521 to 60461?a. strZip = strZip.Insert(2, "46") strZip = strZip.Remove(4, 2)b. strZip = strZip.Remove(2) strZip = strZip.Insert(2, "461")c. strZip = strZip.Remove(2, 2) strZip = strZip.Insert(2, "46")d. All of the
The strName variable contains the string “Jeffers”. Which of the following statements changes the contents of the variable to the string “Jeff”?a. strName = strName.Remove(4)b. strName = strName.Remove(5)c. strName = strName.Remove(5, 3)d. strName = strName.Remove(3, 5)
The strDue variable contains the string “$****75”. Which of the following statements removes the dollar sign and asterisks from the variable?a. strDue = strDue.Trim("$"c, "*"c)b. strDue = strDue.TrimStart("*"c, "$"c)c. strDue = strDue.TrimStart("$"c, "*"c)d. All of the above.
If the strWord variable contains the string “crispy”, which of the following statements assigns the letter s to the strLetter variable?a. strLetter = strWord.Substring(3)b. strLetter = strWord.Substring(3, 1)c. strLetter = strWord.Substring(4, 1)d. None of the above.
The strName variable contains the string “Doe Jane”. Which of the following changes the variable’s contents to the string “Doe, Jane”?a. strName = strName.Insert(3, ",")b. strName = strName.Insert(4, ",")c. strName = strName.AddTo(3, ",")d. None of the above.
Which of the following statements assigns the first four characters in the strItem variable to the strWarehouse variable?a. strWarehouse = strItem.Assign(0, 4)b. strWarehouse = strItem.Assign(1, 4)c. strWarehouse = strItem.Substring(0, 4)d. strWarehouse = strItem.Substring(1, 4)
If the strAddress variable contains the string “15 Palm Ave.”, what will the strAddress.IndexOf("Palm", 5) method return?a. –1b. 5c. 6d. False
If the strAddress variable contains the string “41 Main Street”, what will the strAddress.IndexOf("Main") method return?a. –1b. 3c. 4d. True
If the strMsg variable contains the string “Her birthday is Friday!”, which of the following assigns the number 16 to the intNum variable?a. intNum = strMsg.Substring(0, "F")b. intNum = strMsg.Contains("F")c. intNum = strMsg.IndexOf("F")d. intNum = strMsg.IndexOf(0, "F")
If the strName variable contains the string “Sharon Kelper”, which of the following changes the contents of the variable to the string “Sharon P. Kelper”?a. strName = strName.Insert(6, " P.")b. strName = strName.Insert(7, " P.")c. strName = strName.Insert(8, "P. ")d. None of the above.
If the strPresident variable contains the string “Abraham Lincoln”, what value will the strPresident.IndexOf("ham") method return?a. Trueb. –1c. 4d. 5
Which of the following methods can be used to determine whether the strRate variable contains the percent sign?a. blnResult = strRate.Contains("%")b. intResult = strRate.IndexOf("%")c. intResult = strRate.IndexOf("%", 0)d. All of the above.
The strAmount variable contains the string “678.95”. Which of the following statements changes the contents of the variable to the string “678.95!!!”?a. strAmount = strAmount.PadRight(9, "!")b. strAmount = strAmount.PadRight(9, "!"c)c. strAmount = strAmount.PadRight(3, "!"c)d. None of the
Which of the following statements changes the contents of the strWord variable from “led” to “lead”?a. strWord = strWord.AddTo(2, "a")b. strWord = strWord.Insert(2, "a")c. strWord = strWord.Insert(3, "a")d. strWord = strWord.Into(3, "a"c)
Which of the following assigns the number of characters in the strAddress variable to the intNum variable?a. intNum = strAddress.Lengthb. intNum = strAddress.LengthOfc. intNum = Length(strAddress)d. intNum = LengthOf(strAddress)
Open the VB2017\Chap06\FixIt Solution\FixIt Solution.sln file. Start the application. Click 20 in the Length combo box and then click 30 in the Width combo box. Click the Calculate area button, which should display the area of a rectangle having a length of 20 feet and a width of 30 feet. Notice
In this exercise, you create an application that calculates the number of single rolls of wallpaper required to cover a room. Create a Windows Forms application. Use the following names for the project and solution, respectively: Wallpaper Project and Wallpaper Solution. Save the application in the
In this exercise, you create an application that calculates a customer?s cable bill. Create a Windows Forms application. Use the following names for the project and solution, respectively: Cable Direct Project and Cable Direct Solution. Save the application in the VB2017\Chap06 folder. a. Create
In this exercise, you modify the application created in Exercise 9. Use Windows to make a copy of the Translator Solution folder. Rename the copy Translator Solution-Sub. Open the Translator Solution.sln file contained in the Translator Solution-Sub folder. Change the three functions to Sub
Create a Windows Forms application. Use the following names for the project and solution, respectively: Translator Project and Translator Solution. Save the application in the VB2017\Chap06 folder.a. Create the interface shown in Figure 6-59. The combo box should display the following words:
Mats-R-Us sells three different types of mats: Standard ($99), Deluxe ($129), and Premium ($179). All of the mats are available in blue, red ($10 extra), and pink ($15 extra). There is also an extra $25 charge if the customer wants the mat to be foldable. Create a Windows Forms application. Use the
The Donut Shoppe sells four varieties of doughnuts: Glazed ($1.05), Sugar ($1.05), Chocolate ($1.25), and Filled ($1.50). It also sells regular coffee ($1.50) and cappuccino ($2.75). The store manager wants you to create an application that displays a customer?s subtotal, 6% sales tax, and total
In this exercise, you modify one of the Seminars applications from Chapter 4’s Apply lesson. Open the Seminars Solution.sln file contained in the Seminars Solution-RadioButton folder. Create an event-handling Sub procedure named ClearDue and associate it with each radio button’s CheckedChanged
In this exercise, you modify one of the Seminars applications from Chapter 4’s Apply lesson. Open the Seminars Solution.sln file contained in the Seminars Solution-CheckBox folder. Create an event-handling Sub procedure named ClearAmountDue and associate it with each check box’s CheckChanged
In this exercise, you modify the Cerruti Company application from this chapter’s Apply lesson. Use Windows to make a copy of the Cerruti Solution folder. Rename the copy Modified Cerruti Solution. Open the Cerruti Solution.sln file contained in the Modified Cerruti Solution folder. Change the
Create a Windows Forms application. Use the following names for the project and solution, respectively: OnYourOwn Project and OnYourOwn Solution. Save the application in the VB2017\Chap02 folder. Plan and design an application of your choice. The only requirement is that you must follow the minimum
Which of the following objects provides the connection between a DataSet object and a control on a form?a. Boundb. Bindingc. BindingSourced. Connecting
If an application contains the Catch ex As Exception clause, which of the following can be used to access the exception’s description?a. Ex.Descriptionb. Ex.Exceptionc. Ex.Messaged. Exception.Description
The field that links a child table to a parent table is called the _____________________.A. Foreign key in the child tableB. Foreign key in the parent tableC. Link key in the parent tableD. Primary key in the child table
The CompanyDataSet contains a table named Sales and a field named Income. Which of the following loops will accumulate the values in the Income field?a. For Each row As CompanyDataSet.Sales.RowIn CompanyDataSet.Sales.RowsSales.Row += row.IncomeNext rowb. For Each row As CompanyDataSet.Sales.RowIn
Which of the following refers to the process of connecting a dataset object to a control in the interface?A. AssigningB. BindingC. JoiningD. None of the above.
Which of the following is true?a. Data stored in a relational database can be retrieved both quickly and easily by the computer.b. Data stored in a relational database can be displayed in any order.c. A relational database stores data in a column and row format.d. All of the above.
Which of the following SQL data types is associated with the Visual Basic String data type?a. Char(n)b. String(n)c. Varchar(n)d. Both a and c.
Which of the following SQL data types can store the number 12345.67?a. Decimal(7, 2)b. Decimal(5, 2)c. Decimal(2, 7)d. Decimal(2, 5)
Create a Windows Forms application. Use the following names for the project and solution, respectively: OnYourOwn Project and OnYourOwn Solution. Save the application in the VB2017\Chap11 folder. Plan and design an application of your choice. The only requirement is that you must follow the minimum
Which of a database file’s properties determines if and when the file is copied to the project’s bin\Debug folder?a. Copy to Debugb. Copy to Outputc. Copy to Output Directoryd. Copy to bin\Debug
SQL stands for _____________________.a. Select Query Languageb. Semi-Quick Languagec. Structured Quick Languaged. Structured Query Language
Open the VB2017\Chap11\FixIt Solution\FixIt Solution.sln file. Open the Code Editor window. Correct any errors in the code. Start the application. Click the Calculate button. The total on hand should be 125.
Which of the following is false?a. You can use a query to retrieve specific information from a database.b. You can write queries using SQL.c. You cannot use a query when a database has more than one table.d. None of the above.
You can use the bindingnavigator control to _____________________.A. Add records to a datasetB. Save records in a datasetC. Delete records from a datasetD. All of the above.
The Employees table contains six fields. The EmpNum, Rate, and DeptCode fields are numeric. The LastName, FirstName, and Status fields contain text. The Status field contains either the letter F (for full time) or the letter P (for part time). The DeptCode field identifies the employee’s
Open the Adalene Solution.sln file contained in the VB2017 Chap12 Adalene Solution folder. The application is already connected to the Adalene.mdf file, and the AdaleneDataSet has already been created. Start the application to view the records in the dataset and then stop the application. The
Open the Opals Solution.sln file contained in the VB2017\Chap12\Opals Solution folder. The application is already connected to the Opals.mdf file, and the OpalsDataSet has already been created. The Product table in the database is shown in Figure 12-40. Create a query that calculates the total
Which of the following will select the State and Capital fields for states with populations that exceed 5,000,000? (The Population field is numeric.)a. SELECT State, Capital FROM States WHERE Population > 5000000b. SELECT State, Capital FROM States WHERE Population > '5000000'c. SELECT State,
Which of the following will select the Id and Status fields for records whose Status field contains only the letter F?a. SELECT Id, Status FROM Employ WHERE Status = 'F'b. SELECT Id, Status FROM Employ ORDER BY Status = 'F'c. SELECT Id, Status FROM Employ FOR Status = 'F'd. SELECT Id, Status FROM
Open the Games Solution.sln file contained in the VB2017\Chap12\Games Solution folder. Start the application to view the records, and then click the Exit button. In addition to displaying all of the records, the application should allow the user to display only the games for a specific platform,
Which of the following will select the State and Capital fields for the Kansas and Kentucky records?a. SELECT State, Capital FROM States WHERE State LIKE 'K_'b. SELECT State, Capital FROM States WHERE State LIKE 'K*'c. SELECT State, Capital FROM States WHERE State LIKE 'K%'d. SELECT State, Capital
In this exercise, you modify the Games application from Exercise 5. Use Windows to make a copy of the Games Solution folder. Rename the copy Games Solution-Total. The frmMain_Load procedure should display (in a label control) the total value of the games sold in the store. Display the value with a
In a SELECT statement, which clause is used to limit the records that will be selected?a. LIMITb. ORDER BYc. ONLYd. WHERE
What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate?a. The field is used in a SELECT statement’s ORDER BY clause.b. The field is used in a SELECT statement’s WHERE clause.c. The field is the primary key.d. The field is the foreign key.
Open the VB2017\Chap12\FixIt Solution\FixIt Solution.sln file. Start the application. Click the Grade radio button, type the letter a in the Grade box, and then click the Display button. The application should display three records in the DataGridView control. It should also display the number 3 in
The SQL SELECT statement performs case-sensitive comparisons.a. True b. False
When used in a parameter query, which of the following WHERE clauses will select the records for employees working more than 40 hours?a. WHERE Hours > @Hoursb. WHERE Hours > !Hoursc. WHERE Hours > #Hoursd. WHERE Hours > %Hours
Which of the following calculates the average of the values in the OnHand field?a. SELECT AVERAGE(OnHand) AS Available FROM dbo.Inventoryb. SELECT OnHand.AVG AS Available FROM dbo.Inventoryc. SELECT AVG(OnHand) AS Available FROM dbo.Inventoryd. SELECT AVG.OnHand AS Available FROM dbo.Inventory
Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field?a. SELECT Year, Sales, Commission = Sales * 0.1 FROM dbo.TrentSalesb. SELECT Year, Sales, AS Commission = Sales * 0.1 FROM dbo.TrentSalesc. SELECT Year, Sales,
A computer that requests an asp page from a web server is called a _____________________ computer.A. BrowserB. ClientC. RequestingD. Server
Which of the following is a program that uses html to render a web page on the Computer screen?A. BrowserB. ClientC. ServerD. Renderer
Which of the following is responsible for processing a web page’s html instructions?A. Client computer b. Web server
In code, you refer to a control on a Web page by using which of the following properties?a. Captionb. IDc. Named. Text
Which of the following controls is used to verify that a control on a Web page contains data?a. FieldValidatorb. RequiredFieldc. RequiredFieldValidatord. RequiredValidator
Which of the following controls is used to verify that an entry on a Web page is within minimum and maximum values?a. MinMaxValidationb. MaxMinValidationc. EntryValidatord. RangeValidator
Logic errors are listed in the Error List window.a. True b. False
The process of locating and fixing any errors in a program is called _________________.A. Bug-proofingB. Bug-eliminatingC. DebuggingD. Error removal
While stepping through code, the debugger highlights the statement that _____________________.A. Was just executedB. Will be executed nextC. Contains the errorD. None of the above.
Open the New Pay Solution.sln file contained in the VB2017\AppC\New Pay Solution folder. Use what you learned in the appendix to debug the application.
Open the Hawkins Solution.sln file contained in the VB2017\AppC\Hawkins Solution folder. Use what you learned in the appendix to debug the application.
Open the Allenton Solution.sln file contained in the VB2017\AppC\Allenton Solution folder. Use what you learned in the appendix to debug the application.
While stepping through the code in the Code Editor window, you can view the contents of controls and variables that appear in the highlighted statement only. a. True b. False
Open the Framington Solution.sln file contained in the VB2017\AppC\Framington Solution folder. Use what you learned in the appendix to debug the application.
Open the Commission Calculator Solution.sln file contained in the VB2017\AppC\ Commission Calculator Solution folder. Use what you learned in the appendix to debug the application.
When entered in a procedure, which of the following statements will result in a syntax error?a. Me.Clse()b. Integer.TryPars(txtHours.Text, intHours)c. Dim decRate as Decimeld. All of the above.
Open the Beachwood Solution.sln file contained in the VB2017\AppC\Beachwood Solution folder. Use what you learned in the appendix to debug the application.
The statement constant dblrate as double is an example of a _________________.A. Correct statementB. Logic errorC. Syntax errorD. Run time error
Open the Average Score Solution.sln file contained in the VB2017\AppC\Average Score Solution folder. Use what you learned in the appendix to debug the application.
You use __________________ to pause program execution at a specific line in the code. a. A breakpointb. The error list windowc. The step into option on the debug menud. The stop debugging option on the debug menu
Open the Martins Solution.sln file contained in the VB2017\AppC\Martins Solution folder. Use what you learned in the appendix to debug the application.
Open the CityState Solution.sln file contained in the VB2017\Chap08\CityState Solution folder. Open the Code Editor window. Locate the btnDisplay_Click procedure. The procedure should declare and initialize two parallel one-dimensional arrays named strStates and strCities. Use the names of any five
The intNums array is declared as follows: Dim intNums() As Integer = {10, 5, 7, 2}. Which of the following blocks of code correctly calculates the average value stored in the array? The intTotal, intSub, and dblAvg variables contain the number 0 before the loop is processed.a. Do While intSub <
The intSales array is declared as follows: Dim intSales() As Integer = {10000, 12000, 900, 500, 20000}. Which of the following loops will correctly multiply each element by 2? The intSub variable contains the number 0 before the loop is processed. a. Do While intSub <= 4intSub *= 2Loopb. Do
The intsales array is declared as follows: dim intsales() as integer = {10000, 12000, 900, 500, 20000}. The statement intsales(2) + = 10 will _____________________.a. Replace the 900 amount with 10b. Replace the 900 amount with 910c. Replace the 12000 amount with 10d. Replace the 12000 amount with
Open the Electricity Solution.sln file contained in the VB2017\Chap08\Electricity Solution folder. Open the Code Editor window and locate the btnCalc_Click procedure. Each of the 12 numbers in the array declaration statement represents the cost of electricity for a month. The procedure should use
The strItems array is declared as follows: Dim strItems(20) As String. The intSub variable keeps track of the array subscripts and is initialized to 0. Which of the following Do clauses will process the loop instructions for each element in the array?a. Do While intSub > 20b. Do While intSub
In this exercise, you modify one of the Waterson Company applications from this chapter’s Apply lesson. Use Windows to make a copy of the Waterson Solution-Highest folder. Rename the copy Waterson Solution-Highest-DoLoop. Open the Waterson Solution.sln file contained in the Waterson
Which of the following declares a five-element one-dimensional array?a. Dim intSold(4) As Integerb. Dim intSold(5) As Integer = {4, 78, 65, 23, 2}c. Dim intSold() As Integer = {4, 78, 65, 23, 2}d. Both a and c.

Showing 500 - 600 of 831

Programming With Microsoft Visual Basic 2017 8th Edition Diane Zak - Solutions

Step by Step Answers