ADVANCED VBA EXERCISES▼
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!
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):
- 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:
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:
The result of running your macro to list the Beatles
Save this workbook as Beatles input form, then close it down.