Questions and Answers of Programming with Microsoft Visual Basic 2015

The statement Constant dblRATE As Double is an example of a _____________________.a. Correct statementb. Logic errorc. Syntax errord. Run time error
Open the Martins Solution (Martins Solution.sln) file contained in the VB2015\AppA\Martins Solution folder. Use what you learned in the appendix to debug the application.
Which key is used to step through code?a. F5b. F6c. F7d. F8
Open the Hawkins Solution (Hawkins Solution.sln) file contained in the VB2015\AppA\Hawkins Solution folder. Use what you learned in the appendix to debug the application.
The SQL SELECT statement performs case-sensitive comparisons.a. Trueb. False
If a funnel symbol appears next to a field’s name in the Query Builder dialog box, it indicates that the field is ___________________.a. Used in an ORDER BY clause in a SELECT statementb. Used in a
Open the Adalene Solution (Adalene Solution.sln) file contained in the VB2015\Chap14\Adalene Solution-Sort folder. The btnSort_Click procedure should sort the records in alphabetical order by city
In this exercise, you modify the Oscar Winners application from this lesson. Use Windows to make a copy of the Oscars Solution folder. Rename the copy Oscars Solution-Advanced. Open the Oscars
In this exercise, you modify the application from Exercise 2. Use Windows to make a copy of the Jacoby Solution folder. Rename the copy Jacoby Solution-LINQ. Open the Jacoby Solution (Jacoby
Which of the following will delete the record associated with a DataRow variable named findRow?a. findRow.Delete()b. findRow.Remove()c. delete(findRow)d. None of the above
Open the Morgan Industries Solution (Morgan Industries Solution.sln) file contained in the VB2015\Chap14\Morgan Industries Solution folder. The application is connected to the Employees database,
You can use the SQL ___________________ statement to remove a record from a database.a. DELETEb. DETACHc. ERASEd. REMOVE
Open the VB2015\Chap14\Valentia Solution\Valentia Solution (Valentia Solution.sln) file. The application is connected to the Employees database, which contains a table named tblEmploy. Each record in
Using the StatesDataSet from Review Question 1, which of the following will assign the Atlanta record to the row variable?a. row =StatesDataSet.tblStates.FindCapital("Atlanta")b. row
Open the VB2015\Chap14\Polter Solution\Polter Solution (Polter Solution.sln) file. The application is connected to the Products database, which contains a table named tblProducts. Each record in the
You can use the SQL ___________________ statement to add a record to a database.a. ADDb. ADD INTOc. APPENDd. INSERT
Which of the following will select the SSN field from the tblPayInfo table and then sort the records in descending order by the SSN field?a. SELECT SSN FROM tblPayInfo DESCb. SELECT SSN FROM
Open the VB2015\Chap14\Fashions Solution\Fashions Solution (Fashions Solution.sln) file. The application is connected to the Stores database, which contains a table named tblStores. Each record in
The StatesDataSet from Review Question 1 is associated with the TblStatesBindingSource and TblStatesTableAdapter objects. Which of the following will sort the records by the Capital field?a.
Open the Addison Playhouse Solution (Addison Playhouse Solution.sln) file contained in the VB2015\Chap14\Addison Playhouse Solution folder. The application is connected to the Play database, which
The FillByCity method is associated with a parameter query. Which of the following invokes the method, passing it the contents of the txtCity control’s Text property?a.
The tblEmploy table contains seven fields. The EmpNum, Rate, and Code fields are numeric. The LastName, FirstName, Hired, and Status fields contain text. The Status field contains either the letter F
Which of the following will select the State and Sales fields from the tblStores table?a. SELECT State AND Sales FROM tblStoresb. SELECT State OR Sales FROM tblStoresc. SELECT State, Sales FROM
Open the VB2015\Chap14\Jacoby Solution\Jacoby Solution (Jacoby Solution.sln) file. The application is connected to the Sales database, which contains a table named tblSales. Each record in the table
Two records were added to the StatesDataSet from Review Question 1. Which of the following will save the records in the States database?a. TblStatesBindingSource.Save(StatesDataSet.tblStates)b.
Open the JM Sales Solution (JM Sales Solution.sln) file contained in the VB2015\Chap14\JM Sales Solution folder. The application is connected to the AnnualSales database, which contains a table named
The tblMagazine table contains three fields. The Cost field is numeric. The Code and MagName fields contain text.a. Write a SQL SELECT statement that arranges the records in descending order by the
In this exercise, you modify the Oscar Winners application from this lesson. Use Windows to make a copy of the Oscars Solution folder. Rename the copy Modified Oscars Solution. Open the Oscars
The StatesDataSet contains a table named tblStates. The table contains two text fields named State and Capital. Which of the following will add a new record to the dataset?a.
The process of connecting a control to an object in a dataset is called ______________ .a. Assigningb. Bindingc. Joiningd. None of the above
Open the VB2015\Chap13\Debug Solution\Debug Solution (Debug Solution.sln) file. The application is connected to the Friends database stored in the Friends.accdb file. The database contains one table
If the current record is the ninth record in a dataset that contains 10 records, which of the following statements will position the record pointer on the tenth record?a.
In this exercise, you modify the College Courses application from Exercise 6. Use Windows to make a copy of the Courses Solution folder. Rename the copy Modified Courses Solution. Open the Courses
In this exercise, you use a Microsoft Access database named Calories. The database, which is stored in the VB2015\Chap13\Access Databases\Calories.accdb file, keeps track of the calories consumed
In this exercise, you modify one of the Adalene Fashions applications from this lesson.a. Use Windows to make a copy of the Adalene Solution-Labels folder. Rename the copy Adalene Solution-ListBox.
Which of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b.
In this exercise, you use a Microsoft Access database named Trips. The database, which is stored in the VB2015\Chap13\Access Databases\Trips.accdb file, keeps track of a person’s business and
Open the MusicBox Solution (MusicBox Solution.sln) file contained in the VB2015\Chap13\MusicBox Solution-LINQ folder. The application is connected to the MusicBox database, which is stored in the
In a LINQ statement, which clause limits the records that will be selected?a. Limitb. Order Byc. Selectd. Where
Open the MusicBox Solution (MusicBox Solution.sln) file contained in the VB2015\Chap13\MusicBox Solution-ListBox folder. Connect the application to the MusicBox database. The database, which is
In this exercise, you use a Microsoft Access database named Courses. The database is stored in the VB2015\Chap13\Access Databases\Courses.accdb file. The database contains one table named tblCourses.
Open the Magazine Solution (Magazine Solution.sln) file contained in the VB2015\ Chap13\Magazine Solution-Intermediate folder. The application is connected to the Magazines database, which is stored
The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total of the items in inventory?a. Dim intTotal As Integer =Aggregate item In
Open the MusicBox Solution (MusicBox Solution.sln) file contained in the VB2015\Chap13\MusicBox Solution-Labels folder. Connect the application to the MusicBox database. The database, which is stored
The information in a _____________________ database is stored in tables.a. Columnarb. Relationalc. Sortedd. Tabular
Open the Sports Action Solution (Sports Action Solution.sln) file contained in the VB2015\Chap13\Sports Action Solution folder. Connect the application to a Microsoft Access database named Sports.
The tblBooks table in the Books database contains a numeric field named Price. Which of the following determines the number of books whose price is at least $20? The dataset’s name is
The tblCds table contains three fields. The CdNum and Price fields are numeric; the Title field contains text. The dataset’s name is CdsDataSet. Write a LINQ statement that selects records having
The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records having at least 500 of the item in stock?a. Dim records =From item In
Open the MusicBox Solution (MusicBox Solution.sln) file contained in the VB2015\Chap13\MusicBox Solution-DataGridView folder. Connect the application to the MusicBox database. The database, which is
A _____________________ is an organized collection of related information stored in a computer file.a. databaseb. datasetc. fieldd. record
Open the Playhouse Solution (Playhouse Solution.sln) file contained in the VB2015\Chap13\Playhouse Solution folder. Connect the application to a Microsoft Access database named Play. The database is
The tblBooks table in the Books database contains a numeric field named Quantity. Which of the following determines the total number of books in the BooksDataSet?a. Dim intNumBooks As Integer
Open the Magazine Solution (Magazine Solution.sln) file contained in the VB2015\Chap13\Magazine Solution-Introductory folder. The application is connected to the Magazines database, which is stored
Which of the following statements selects all of the records in the tblCities table?a. Dim records =From city In CitiesDataSet.tblCitiesSelect All cityb. Dim records =From city In
Diamond Spa records the ID, name, and price of each of its services in a database named Services. The Services database, which is stored in the VB2015\Chap13\ Access Databases\Services.accdb file,
If the record pointer is positioned on record number 7 in a dataset, which of the following will move the record pointer to record number 8?a. TblBooksBindingSource.GoNext()b.
In this exercise, you modify the Games Galore application from this lesson. Use Windows to make a copy of the Games Solution folder. Rename the copy Games Solution-TotalGames. Open the Games Solution
Which of the following determines the number of records in the BooksDataSet?a. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooksIn Counterb. Dim intNum As Integer =Aggregate book In
In this exercise, you modify one of the Adalene Fashions applications from this lesson. Use Windows to make a copy of the Adalene Solution-Aggregate folder. Rename the copy Modified Adalene
Which of the following calculates the average of the values stored in a numeric field named Population?a. Dim dblAvg As Double =Aggregate city In CitiesDataSet.tblCitiesSelect city.PopulationInto
Diamond Spa records the ID, name, and price of each of its services in a database named Services. The Services database, which is stored in the VB2015\Chap13\Access Databases\Services.accdb file,
The _____________________ property stores an integer that represents the location of the record pointer in a dataset.a. BindingNavigator object’s Positionb. BindingSource object’s Positionc.
In this exercise, you modify the Games Galore application from this lesson. Use Windows to make a copy of the Games Solution folder. Rename the copy Games Solution-NewUsed. Open the Games Solution
The tblBooks table in the Books database contains a numeric field named BookNumber. Which of the following will select book number 401 from the BooksDataSet?a. Dim records = From book In
The tblBooks table contains five fields. The BookNum, Price, and QuantityInStock fields are numeric; the Title and Author fields contain text. The dataset’s name is BooksDataSet.a. Write a LINQ
Which of the following will select only records whose City field begins with the letter L?a. Dim records = From StoresDataSet.tblStoresSelect City.ToUpper Like "L*"b. Dim records = From
In this exercise, you modify one of the Adalene Fashions applications from this lesson. Use Windows to make a copy of the Adalene Solution-Labels folder. Rename the copy Modified Adalene
Which of the following objects connects a database to a DataSet object?a. BindingSourceb. DataBasec. DataGridViewd. TableAdapter
In this exercise, you modify the Games Galore application from this lesson. Use Windows to make a copy of the Games Solution folder. Rename the copy Games Solution-Rating. Open the Games Solution
The Enable Deleting check box in a _____________________ control’s task list determines whether a record can be deleted from the control.a. BindingNavigatorb. BindingSourcec. DataBindingNavigatord.
Create an empty Web Site application named ZipCode and save it in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
A _____________________ occurs when a user clicks a Submit button on a Web page.a. Clientpostb. Postbackc. Sendbackd. Serverpost
Create an empty Web Site application named Guessing Game. Save the application in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s
When a check box’s AutoPostBack property is set to _____________________, the code in its _____________________ event procedure will be automatically processed by the server when the value in its
In this exercise, you create a Web application that displays how much a person would weigh on the following planets, given his or her weight on Earth: Venus, Mars, and Jupiter. Create an empty Web
The text that appears on the application’s tab in the browser window is determined by the _____________________ property.a. Application object’s Nameb. Application object’s Titlec. DOCUMENT
Create an empty Web Site application named MacroTech. Save the application in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title
Which event procedure contains the code to process when a check box is selected by the user?a. Checkedb. CheckBoxChangedc. CheckedChangedd. SelectedCheckBox
The HTML instructions in a Web page are processed by the _____________________.a. Client computerb. Web server
Create an empty Web Site application named Dice. Save the application in the VB2015\ Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title
Which event procedure contains the code to process when a different radio button is selected in a radio button list control?a. CheckedChangedb. SelectedIndexChangedc. SelectedIndexd. SelectionChanged
You can use a ___________________ control to verify that an entry on a Web page is within minimum and maximum values.a. MinMaxValidationb. MaxMinValidationc. EntryValidatord. RangeValidator
The first Web page in an empty Web application is automatically assigned the name _____________________.a. Default.apsb. Default1.vbc. Default.aspxd. WebFormDefault.aspx
Which of the following determines whether the first radio button in the rblAges control is selected?a. If rblAges.Selected = 0 Thenb. If rblAges(0).Selected Thenc. If rblAges.SelectedIndex = 0 Thend.
Create an empty Web Site application named Bakery and save it in the VB2015\ Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
You can use a ___________________ control to verify that a control on a Web page contains data.a. RequiredFieldValidatorb. RequiredFieldc. RequiredValidatord. None of the above
Create an empty Web Site application named Market and save it in the VB2015\Chap12 folder. Add three new Web pages named Default.aspx, Apples.aspx, and Oranges.aspx to the application. Change each
An online form used to purchase a product is an example of a _____________________ Web page.a. Dynamicb. Static
Create an empty Web Site application named Tea and save it in the VB2015\ Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
Which of the following If clauses determines whether the chkTaxable control is selected?a. If chkTaxable = True Thenb. If chkTaxable.Checked Thenc. If chkTaxable.Selected Thend. If
Create an empty Web Site application named Tips and save it in the VB2015\ Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
The Visual Basic code in a Web page is processed by the ___________________.a. Client computerb. Web server
Create an empty Web Site application named Carnival and save it in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
A _____________________ is a program that uses HTML to render a Web page on the computer screen.a. Browserb. Clientc. Serverd. None of the above
In this exercise, you modify the Satellite Radio application from this lesson. Use Windows to make a copy of the Radio folder. Rename the copy Modified Radio. Open the Modified Radio Web site.
Which of the following tools is used to group related radio buttons on a Web page?a. ButtonRadioListb. ListRadioButtonc. RadioButtonListd. RadioButtons
Create an empty Web Site application named Circle and save it in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to
In code, you refer to a control on a Web page using the control’s ___________________ property.a. Captionb. IDc. Named. Text
Create an empty Web Site application named Spa and save it in the VB2015\Chap12 folder. Add a new Web page named Default.aspx to the application. Change the DOCUMENT object’s Title property to Spa

Showing 1 - 100 of 662