Complete programming challenges

Assignment Help Visual Basic Programming

Reference no: EM131924213

The Internet and Microsoft Office Requirements Microsoft Access VBA Programming - Object-Orientated Programming with Access VBA

1. Read pages 291 through 316.

2. Participate in Discussion Question 6.1 (DQ6.1)

3. Complete Programming Challenges 1 through 4 on page 316.

A. Program Challenge 1: Create a new database called BookStore with one table called Books.

Add the columns ISBN,Title,PublishDate, and Price to theBooks table. Add a few records to the Books table. Create a new connection class called CustomConnection that connects to your BookStore database. The new class should have two methods-one method for opening an ADO Connection object and a second method for closing the ADO Connection object.

The method that opens a database connection should take a single string argument, which represents the path and filename of the database. [Place a screen capture here of the code for the two methods making the ADO connections.]

B. Program Challenge 2: In the same database application from Challenge 1, create a new class called Books. This class should have a read-only property for each column in the Books table.

Create a method in the Books class called FindBook. The FindBook method should take in an ISBN. Build a SQL string based on the ISBN and use ADO programming techniques to open a recordset and assign the recordset field values to the class's matching properties. You should use the CustomConnection class to create and retrieve any Connection objects.

[Place a screen capture here of code for the FindBook method.]

C. Program Challenge 3: Enhance Challenges 1 and 2 by building a form with controls that allow a user to find a book by entering an ISBN. Use your Books class from Challenge 2 to find and retrieve book details. [Place a screen capture here of the form you developed.]

D. Program Challenge 4: Enhance the user interface from Challenge 3 to allow a user to add and remove books. To accomplish this, you need to modify the Books class from Challenge 2 by adding two methods called AddBook and RemoveBook.

Reference no: EM131924213

Questions Cloud

Examine the ways companies can improve the sustainability : Examine the ways companies can improve the sustainability performance of their supply chains - what must specific industries do to ensure a sustainable supply

Who would you say are the competitors to online universities : Their initial practices may have worked well previously, but may not serve them well in the long term. The newspaper industry is one that may face extinction.

Write an argumentative essay on the given questions : Your task is to write an argumentative essay answering one of the following questions, drawing from concepts and theories discussed so far this semester.

What characteristics result in toxic leadership : Select a female leader that faced challenges based on gender and whose circumstances would be different if the leader had been male.

Complete programming challenges : In the same database application from Challenge 1, create a new class called Books. This class should have a read-only property for each column in the Books tab

Explain what role these have on the way the business operate : Explain what role these have on the way the business operates. Evaluate whether the company's actions seem to align with their set of values.

What type of lymphocyte generates antibodies : What type of lymphocyte generates antibodies? Explain what the two curves are depicting AND why they have different shapes. Essay.

Create and defend a thesis : Create and defend a thesis (your thesis = your own position on the argument) in which you argue for abortion by giving a moral principled objection to the other

Identify five reasons for evaluating training : Regardless of the industry type or size, U.S. companies spend substantial amounts of money on training programs. With so much time, effort, and money spent.

User Account

All Pages