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.
Macros and Performance Tuning
1. Read pages 317 through 314.
2. Participate in Discussion Question 6.2 (DQ6.2)
3. No Programming Challenges assigned.
4. Complete the following final course project
Final Project:
Develop a Microsoft Access database with the table(s) necessary to hold any 5 states of the United States of America, their capitals and a graphic picture of the appropriate state flag or state tree or flower. All this information is available on the Internet. Any graphics may need to be sized to fit your project.
1. Using VBA, construct a multiple choice quiz which randomly selects a state and asks the user to select the correct capital of the randomly selected state.
2. If the user answers incorrectly, the screen should display a message with the word ‘INCORRECT' with the state name, the correct capital and the correct matching graphic.
3. If the user answers correctly, display an appropriate message.