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

Bundle Programming With Microsoft Visual Basic 2015 7th + Mindtap Programming 1 Term Printed Access Card 7th Edition Diane Zak - Solutions

8. Open the Framington Solution (Framington Solution.sln) file contained in the VB2015\AppA\Framington Solution folder. Use what you learned in the appendix to debug the application.
7. Open the Beachwood Solution (Beachwood Solution.sln) file contained in the VB2015\AppA\Beachwood Solution folder. Use what you learned in the appendix to debug the application.
6. Open the Average Score Solution (Average Score Solution.sln) file contained in the VB2015\AppA\Average Score Solution folder. Use what you learned in the appendix to debug the application.
5. 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.
4. Open the Allenton Solution (Allenton Solution.sln) file contained in the VB2015\AppA\Allenton Solution folder. Use what you learned in the appendix to debug the application.
3. 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.
2. Open the New Pay Solution (New Pay Solution.sln) file contained in the VB2015\AppA\New Pay Solution folder. Use what you learned in the appendix to debug the application.
1. Open the Commission Calculator Solution (Commission Calculator Solution.sln) file contained in the VB2015\AppA\Commission Calculator Solution folder. Use what you learned in the appendix to debug the application.
8. 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
7. The statement Constant dblRATE As Double is an example of a _____________________.a. correct statementb. logic errorc. syntax errord. run time error
6. 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
5. 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. Trueb. False
4. Which key is used to step through code?a. F5b. F6c. F7d. F8
3. Logic errors are listed in the Error List window.a. Trueb. False
2. 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
1. The process of locating and fixing any errors in a program is called _____________________.a. bug-proofingb. bug-eliminatingc. debuggingd. error removal
4. 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, which contains a table named tblEmploy. Each record in the table contains seven fields. The EmpNum
3. 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 table has three fields. The ItemNum (primary key) and ItemName fields contain text; the Price
2. 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
1. 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.
4. You can use the SQL ___________________ statement to remove a record from a database.a. DELETEb. DETACHc. ERASEd. REMOVE
3. You can use the SQL ___________________ statement to add a record to a database.a. ADDb. ADD INTOc. APPENDd. INSERT
2. 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.
1. When used in a parameter query, which of the following WHERE clauses will allow you to select the records for employees working more than 40 hours?a. WHERE Hours >= 40b. WHERE Hours > ?c. WHERE Hours > #d. WHERE Hours < ?
2. 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
1. 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
8. 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 WHERE clause in a SELECT statementc. the primary keyd. the foreign key 9. The SQL SELECT
7. In a SELECT statement, which clause is used to limit the records that will be selected?a. LIMITb. ORDER BYc. ONLYd. WHERE
6. 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 tblState WHERE Population >5000000b. SELECT State, Capital FROM tblState WHERE Population >'5000000'c. SELECT State,
5. Which of the following will select the State and Capital fields for the Kansas and Kentucky records?a. SELECT State, Capital FROM tblState WHERE State LIKE 'K'b. SELECT State, Capital FROM tblState WHERE State LIKE 'K*'c. SELECT State, Capital FROM tblState WHERE State LIKE 'K%'d. SELECT State,
4. 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 tblEmp WHERE Status = 'F'b. SELECT Id, Status FROM tblEmp ORDER BY Status = 'F'c. SELECT Id, Status FROM tblEmp FOR Status = 'F'd. SELECT Id, Status
3. 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
2. 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
1. SQL stands for ___________________.a. Select Query Languageb. Semi-Quick Languagec. Structured Quick Languaged. Structured Query Language
7. 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 name within state name. Code the procedure and then test the application appropriately.
6. 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 Solution (Oscars Solution.sln) file contained in the Oscars Solution-Advanced folder. Use the Delete
5. 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 Solution.sln) file contained in the Jacoby Solution-LINQ folder.Add a button named btnTotal to the form.
4. 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 the table contains seven fields. The EmpNum field is the primary key. The Status field contains
3. 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
2. 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
1. 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
5. 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
4. 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 =StatesDataSet.tblStates.FindByCapital("Atlanta")c. row =StatesDataSet.tblStates.FindByState("Georgia")d. both b
3. 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.
2. 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.
1. 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.
10. 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
9. 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
8. 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
7. 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
6. 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
5. 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
4. 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
3. 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
2. 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
1. 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
5. 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.tblBooks Where book.Price > 20 Into
4. 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.tblBooks Into Countb. Dim intNumBooks As Integer =Aggregate book In
3. Which of the following determines the number of records in the BooksDataSet?a. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooks In Counterb. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooks Into Countc. Dim intNum As Integer =Aggregate book In BooksDataSet.tblBooks
2. 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.tblBooks Where book.BookNumber = "401" Select bookb. Dim records = From book In
1. 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
6. 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
5. 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
4. 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
3. 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
2. 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
1. 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
6. In a LINQ statement, which clause limits the records that will be selected?a. Limitb. Order Byc. Selectd. Where
5. 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.tblInventory Select item.InStock Into Sumb. Dim intTotal As Integer =Sum item In
4. 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.tblInventory Where item >= 500 Select item.InStockb. Dim records =From item In
3. Which of the following statements selects all of the records in the tblCities table?a. Dim records =From city In CitiesDataSet.tblCities Select All cityb. Dim records =From city In CitiesDataSet.tblCities Select cityc. Dim records =Select city From CitiesDataSet.tblCitiesd. Dim records = From
2. 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.tblCities Select city.Population Into Averageb. Dim dblAvg As Double =From city In CitiesDataSet.tblCities Select city.Population Into
1. Which of the following will select only records whose City field begins with the letter L?a. Dim records = From StoresDataSet.tblStores Select City.ToUpper Like "L*"b. Dim records = From tblStores Where tblStores.City.ToUpper Like "L*"Select cityc. Dim records =From store In
7. 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
6. 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
5. 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
4. 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.
3. 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
2. 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
1. 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
12. 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
11. The process of connecting a control to an object in a dataset is called ______________ .a. assigningb. bindingc. joiningd. none of the above
10. 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
9. 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
8. 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
7. 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.
6. Which of the following objects provides the connection between a DataSet object and a control on a form?a. Boundb. Bindingc. BindingSourced. Connecting
5. The information in a _____________________ database is stored in tables.a. columnarb. relationalc. sortedd. tabular
4. A _____________________ is an organized collection of related information stored in a computer file.a. databaseb. datasetc. fieldd. record
3. 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
2. 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
1. Which of the following objects connects a database to a DataSet object?a. BindingSourceb. DataBasec. DataGridViewd. TableAdapter
6. 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,
5. 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
4. 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
3. Create an empty Web Site application named Willow 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 Willow Hill. Willow Hill Athletic Club offers personal training sessions to its members. The
2. 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
1. 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
6. 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,
5. Which event procedure contains the code to process when a check box is selected by the user?a. Checkedb. CheckBoxChangedc. CheckedChangedd. SelectedCheckBox

Showing 1 - 100 of 1847

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last

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