New Semester Started Get 50% OFF Study Help! --h --m --s Claim Now

Question Answers

Textbooks

Find textbooks, questions and answers

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Study Help
Tutors
AI Study Planner NEW
Sell Books

Search
Sign In
Register

study help
computer science
programming with microsoft visual basic 2015

Programming With Microsoft Visual Basic 2015 7th Edition Diane Zak - Solutions

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 tblPayInfo ORDER BY SSN DESCc. SELECT SSN FROM tblPayInfo WHERE SSN DESCd. SELECT SSN FROM tblPayInfo SORT
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 table contains five fields. The StoreNum (primary key) and Sales fields contain numbers; the
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. TblStatesBindingSource.Sort = "Capital"b. TblStatesBindingSource.Sort("Capital")c.
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 contains a table named tblReservations. Each record in the table has three fields: a numeric field
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. TblCityTableAdapter.FillByCity(CityDataSet.tblCity, txtCity.Text)b. TblCityTableAdapter.FillByCity(txtCity.Text)c.
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 (for full time) or the letter P (for part time). The Code field identifies the employee’s
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 tblStoresd. SELECT ONLY State, Sales FROM tblStores
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 has four numeric fields named RecordNum (the primary key), YearNum, MonthNum, and Sales. The
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. TblStatesBindingSource.Update(StatesDataSet.tblStates)c.
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 tblSales. Each record in the table has two numeric fields: YearNum (the primary key) and Sales. The
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 Cost field.b. Write a SQL SELECT statement that selects only the MagName and Cost fields from records
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 Solution (Oscars Solution.sln) file contained in the Modified Oscars Solution folder. Modify the
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. StatesDataSet.tblStates.AddStatesRow(strS, strC)b. StatesDataSet.tblStates.AddRowToStates(strS, strC)c.
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 named tblFriends. The table contains nine records. Open the Code Editor window and review the
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. TblEmployBindingSource.Position = 9b. TblEmployBindingSource.Position += 1c. TblEmployBindingSource.MoveLast()d. All of the above
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 Solution (Courses Solution.sln) file contained in the Modified Courses Solution folder. Add a
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 during the day. The database contains one table named tblCalories. Each record has the following six
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. Open the Adalene Solution (Adalene Solution.sln) file contained in the 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. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d.
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 pleasure trips. The database contains one table named tblTrips. Each record has the following four text
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 MusicBox.accdb file. The tblBox table in the database contains four text fields. Start the application
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 stored in the VB2015\Chap13\Access Databases\MusicBox.accdb file, contains a table named tblBox. Bind the
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. Each record has the following four fields: ID, Title, CreditHours, and Grade. The CreditHours field
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 in the Magazines.accdb file. The database contains a table named tblMagazine. The table’s Cost
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 InventoryDataSet.tblInventorySelect item.InStockInto Sumb. Dim intTotal As Integer =Sum 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 in the VB2015\Chap13\Access Databases\MusicBox.accdb file, contains a table named tblBox. Bind the
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 database is stored in the VB2015\Chap13\Access Databases\Sports.accdb file. The database contains
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 BooksDataSet.a. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooksWhere book.Price > 20Into
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 titles that begin with the word “The” (in either uppercase or lowercase). Then write a LINQ
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 InventoryDataSet.tblInventoryWhere item >= 500Select item.InStockb. 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 stored in the VB2015\Chap13\Access Databases\MusicBox.accdb file, contains a table named tblBox.
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 stored in the VB2015\Chap13\Access Databases\Play.accdb file. The database contains one table named
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 =Aggregate book In BooksDataSet.tblBooksInto Countb. Dim intNumBooks As Integer =Aggregate book In
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 in the Magazines.accdb file. The database contains a table named tblMagazine. The table’s Cost
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 CitiesDataSet.tblCitiesSelect cityc. Dim records =Select city From CitiesDataSet.tblCitiesd. Dim records = From
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, contains a table named tblServices. Open the Diamond Solution (Diamond Solution.sln) file contained in
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. TblBooksBindingSource.Move(8)c. TblBooksBindingSource.MoveNext()d. TblBooksBindingSource.PositionNext
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 (Games Solution.sln) file contained in the VB2015\Chap13\Games Solution-TotalGames folder. Add a
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 BooksDataSet.tblBooksInto Countc. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooksInto
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 Solution-Aggregate. Open the Adalene Solution (Adalene Solution.sln) file contained in the 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 Averageb. Dim dblAvg As Double =From 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, contains a table named tblServices. Open the Diamond Solution (Diamond Solution.sln) file contained in
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. TableAdapter object’s Positiond. None of the above
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 (Games Solution.sln) file contained in the VB2015\Chap13\Games Solution-NewUsed folder. Add a
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 BooksDataSet.tblBooksWhere book.BookNumber = "401" Select bookb. 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 statement that arranges the records in ascending order by the Author field.b. Write a LINQ statement
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 tblStoresWhere tblStores.City.ToUpper Like "L*"Select cityc. Dim records =From store 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-Labels folder. Rename the copy Modified Adalene Solution-Labels. Open the Adalene Solution (Adalene Solution.sln) file contained in the 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 (Games Solution.sln) file contained in the VB2015\Chap13\Games Solution-Rating folder. Add a
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. DataGridView
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 Zip Code Verifier. Use Figure 12-47 as a guide when designing the Web page. Use a
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 Title property to Guessing Game. The application should generate a random integer from 1 through 30,
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 _____________________ property changes.a. Auto, CheckedChanged, Checkedb. Post, Checked,
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 Site application named Weight and save it in the VB2015\ Chap12 folder. Add a new Web page named
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 object’s Tab Named. DOCUMENT object’s Title
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 property to MacroTech. MacroTech sells a software package that is available in three editions. The
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 property to Dice Game. In Chapter 5’s Lesson C, you created the Roll ‘Em Game application. Review
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. None of the above
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 Meyer’s. Use Figure 12-46 as a guide when designing the Web page. The image is contained in the
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 DOCUMENT object’s Title property to Corner Market. Create Web pages similar to the ones shown in
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 Brazilian Tea. Brazilian Tea is a store that sells both hot and iced tea in three different cup sizes:
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 chkTaxable.Selection = True Then
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 Tip Calculator. Use Figure 12-45 as a guide when designing the Web page. In the Code Editor window,
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 Brookfield. Create a Web page similar to the one shown in Figure 12-25. The image on the Web page
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. Right-click Default.aspx in the Solution Explorer window and then click View Designer. Figure 12-60 shows
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 Circle Area.a. Use Figure 12-44 as a guide when designing the Web page. The circle image is contained
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 Monique. Create a Web page similar to the one shown in Figure 12-24. The Spa Monique image is
Create an application, using the following names for the solution and project, respectively: Parking Solution and Parking Project. Save the application in the VB2015\ Chap11 folder. The application should display the total cost of paving the parking lot shown in Figure 11-31. Create a suitable
Create an application, using the following names for the solution and project, respectively: Fire Solution and Fire Project. Save the application in the VB2015\Chap11 folder. The application should display the capacity (volume) of a water tank on a fire engine in both cubic feet and gallons, given
Create an application, using the following names for the solution and project, respectively: Playground Solution and Playground Project. Save the application in the VB2015\Chap11 folder. The application should display the area of a triangular playground in square feet. It should also display the
In this exercise, you create an application that can be used to calculate the cost of installing a fence around a rectangular area. Create the application, using the following names for the solution and project, respectively: Fence Solution and Fence Project. Save the application in the
A class contains a Private variable named _strState. The variable is associated with a Public property named State. Which of the following is the best way for a parameterized constructor to assign the value stored in its strName parameter to the variable?a. _strState = strNameb. State = _strNamec.
Create an application, using the following names for the solution and project, respectively: Serenity Solution and Serenity Project. Save the application in the VB2015\ Chap11 folder. Create the interface shown in Figure 11-49. The image for the picture box is stored in the VB2015\Chap11\Flower.png
In this exercise, you create an application that can be used to estimate the cost of laying sod on a rectangular piece of property. Create the application, using the following names for the solution and project, respectively: Harston Solution and Harston Project. Save the application in the
The Return statement is entered in the ___________________ statement in a Property procedure.a. Getb. Set
Create an application, using the following names for the solution and project, respectively: Glasgow Solution and Glasgow Project. Save the application in the VB2015\Chap11 folder. Create the interface shown in Figure 11-48. Each member of Glasgow Health Club must pay monthly dues that consist of a
In this exercise, you modify the Norbert Pool & Spa Depot application from Exercise 9. Use Windows to make a copy of the Norbert Solution-Introductory folder. Rename the copy Norbert Solution-Intermediate. Open the Norbert Solution (Norbert Solution.sln) file contained in the Norbert
If you need to validate a value before assigning it to a Private variable, you enter the validation code in the ___________________ block in a Property procedure.a. Assignb. Getc. Setd. Validate
In this exercise, you modify the Grade Calculator application from this lesson. Use Windows to make a copy of the Grade Solution folder. Rename the copy Grade Solution-Intermediate. Open the Grade Solution (Grade Solution.sln) file contained in the Grade Solution-Intermediate folder.a. Open the
Open the VB2015\Chap11\Palace Solution\Palace Solution (Palace Solution.sln) file. Create a Rectangle class similar to the one shown earlier in Figure 11-23; however, use Double variables rather than Integer variables. The application should calculate and display the number of square yards of
Which of the following instantiates an Inventory object and assigns it to the chair variable?a. Dim chair As Inventoryb. Dim chair As New Inventoryc. Dim chair = New Inventoryd. Dim New chair As Inventory
Open the VB2015\Chap11\Salary Solution\Salary Solution (Salary Solution.sln) file. Open the Worker.vb class file, and then enter the Worker class definition from Exercises 5 and 6. Save the solution and then close the Worker.vb window. Open the form’s Code Editor window. Use the comments in the

Showing 1200 - 1300 of 1847

First
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

Step by Step Answers

Services

Sitemap
Fun
Definitions
Become Tutor
Used Textbooks
Study Help Categories
Recent Questions
Expert Questions
Campus Wear
Sell Your Books

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship
Online Quiz
Give Feedback, Get Rewards

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Student Discount
Campus Ambassador

Secure Payment

Download Our App

© 2026 SolutionInn. All Rights Reserved