Microsoft Access VBA Macros training exercises

Showing exercises 1-17 (out of 17)

Category: Access VBA Macros
Topic: The VBA code editor
Level: Relatively easy
Course: Access VBA macros
Exercise: Create a procedure to open and close a table, displaying a modal message box in between.

Go to exercise ...

Category: Access VBA Macros
Topic: Messages and variables
Level: Relatively easy
Course: Access VBA macros
Exercise: Write a macro which displays an InputBox asking for the name of a table, then opens the named table.

Go to exercise ...

Category: Access VBA Macros
Topic: Messages and variables
Level: Average difficulty
Course: Access VBA macros
Exercise: Display two input boxes asking for integers, then display message built up showing answer.

Go to exercise ...

Category: Access VBA Macros
Topic: Messages and variables
Level: Average difficulty
Course: Access VBA macros
Exercise: Turn off Access warning messages, then run an action query to update a particular field in a table of films.

Go to exercise ...

Category: Access VBA Macros
Topic: Creating functions
Level: Relatively easy
Course: Access VBA macros
Exercise: Create a function to calculate the success rate for each film in a table giving its oscar nominations and wins.

Go to exercise ...

Category: Access VBA Macros
Topic: Creating functions
Level: Average difficulty
Course: Access VBA macros
Exercise: Write your own VBA function to calculate the years since release of a film, using the DateDiff and Date functions.

Go to exercise ...

Category: Access VBA Macros
Topic: Visual Basic explained
Level: Relatively easy
Course: Access VBA macros
Exercise: Look at a set of sets of objects, and explain in each case why they are not proper collections.

Go to exercise ...

Category: Access VBA Macros
Topic: Visual Basic explained
Level: Average difficulty
Course: Access VBA macros
Exercise: Converting English to VBA and back again - explaining object orientation.

Go to exercise ...

Category: Access VBA Macros
Topic: Attaching code to forms
Level: Relatively easy
Course: Access VBA macros
Exercise: Attach code to 3 buttons to change various simple properties of forms and controls (eg whether navigation buttons appear).

Go to exercise ...

Category: Access VBA Macros
Topic: Attaching code to forms
Level: Relatively easy
Course: Access VBA macros
Exercise: Change the TOP and LEFT properties of an image of Pablo the Penguin by clicking on buttons on a form.

Go to exercise ...

Category: Access VBA Macros
Topic: Attaching code to forms
Level: Average difficulty
Course: Access VBA macros
Exercise: Attach macros to buttons to hide or show a picture of Osama bin Laden - more difficult than it should be because you can not hide a control which has the focus.

Go to exercise ...

Category: Access VBA Macros
Topic: Attaching code to forms
Level: Average difficulty
Course: Access VBA macros
Exercise: Get a label on a form to flash, by using the Timer event to change the Visible property.

Go to exercise ...

Category: Access VBA Macros
Topic: Attaching code to forms
Level: Harder than average
Course: Access VBA macros
Exercise: Create a splash form for a database, which loads when you first enter the database then disappearss after a second or so.

Go to exercise ...

Category: Access VBA Macros
Topic: Looping
Level: Relatively easy
Course: Access VBA macros
Exercise: Create macros to loop over all of the Access objects, listing out the names of tables and forms.

Go to exercise ...

Category: Access VBA Macros
Topic: Recordsets
Level: Relatively easy
Course: Access VBA macros
Exercise: A simple macro to add, delete and modify records in a table of languages.

Go to exercise ...

Category: Access VBA Macros
Topic: Recordsets
Level: Average difficulty
Course: Access VBA macros
Exercise: Write a macro to add a new toy to a products table, then modify it to check that the toy added does not already exist.

Go to exercise ...

Category: Access VBA Macros
Topic: Case studies
Level: Relatively easy
Course: Access VBA macros
Exercise: Create a separate module containing navigation code, and attach its functions to buttons on a form.

Go to exercise ...

This page has 0 threads Add post