Free Access VBA Macros exercises

This page lists 25 Access VBA Macros exercises. You can use the menu on the left to show just exercises for a specific topic.

This page lists 25 Access VBA Macros exercises. You can use the menu above to show just exercises for a specific topic.

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Creating functions
Level:
Course: Access VBA macros
Exercise: Calculate the difference between Oscar wins and nominations in a function.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Messages and variables
Level: Relatively easy
Course: Access VBA macros
Exercise: Ask a user to type in their name and age, and store these in variables.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Messages and variables
Level: Relatively easy
Course: Access VBA macros
Exercise: Use VBA to run a simple query, displaying a message box.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Creating functions
Level: Relatively easy
Course: Access VBA macros
Exercise: Create a function to show someone's lifespan in years.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Messages and variables
Level: Average difficulty
Course: Access VBA macros
Exercise: Write a macro to ask for the name of a table, then open this table.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Messages and variables
Level: Average difficulty
Course: Access VBA macros
Exercise: Write a VBA procedure to suppress warnings and run an action query.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Recordsets
Level: Average difficulty
Course: Access VBA macros
Exercise: Adding, listing and deleting directors using VBA and recordsets.

Go to exercise ...

Software: Access VBA Macros
Version: Access 2010 and later
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 ...

Software: Access VBA Macros
Version: Access 2010 and later
Topic: Messages and variables
Level: Harder than average
Course: Access VBA macros
Exercise: Write a procedure to run a make-table action query, then delete the table created.

Go to exercise ...

You can search our full list of Access exercises here. Or why not learn to do them the right way on one of our classroom Access training courses in the UK, or on one of our live online Access courses wherever you are in the world?

This page has 0 threads Add post