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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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