Advanced VBA | Linking to data exercise | Listing Beatles - ADO

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

You can learn how to do this exercise if you attend one of more of the courses listed below!

Software ==> Advanced VBA  (33 exercises)
Version ==> Any MS Office versions
Topic ==> Linking to data  (3 exercises)
Level ==> Average difficulty
Courses ==> Fast track Excel VBA  /  Advanced VBA
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

The database in the above folder contains a single table called tblBeatles, listing for each Beatle the following fields (the database is in Access 2007/2010 format, so you won't be able to open it in Access 2003):

  • FirstName
  • LastName
  • Dob (the Beatle's date of birth)
  • Verdict (what you think about them)

Create a macro and assign it to the ADD THIS BEATLE button so that when you click on the button, Excel adds a record to the Beatles database:

Advanced VBA exercise - Linking to data (image 1)

You'll need to create a connection string and open a recordset

If you get this working, create a macro and assign it to the LIST BEATLES button so that the macro reads the Beatles' names into an array from the database, then loops over this array to build up a message which it then displays:

Advanced VBA exercise - Linking to data (image 2)

The result of running your macro to list the Beatles

Save this workbook as Beatles input form, then close it down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post