Microsoft computer training exercises (page 4 of 41)

Showing exercises 61-80 (out of 813)

Category: Access 2010
Topic: Creating subforms
Level: Average difficulty
Course: Access Developers
Exercise: Create subforms based on the one-to-many relationships in a Microsoft Access 2007 database.

Go to exercise ...

Category: Access 2010
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use simple VBA macros to control user input in a Microsoft Access 2007 database.

Go to exercise ...

Category: Access 2010
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use simple VBA programs to add functionality to the forms in a Microsoft Access 2007 database.

Go to exercise ...

Category: Access 2010
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use VBA to create a menu system for a Microsoft Access 2007 database.

Go to exercise ...

Category: Access 2010
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Create criteria forms in a Microsoft Access 2007 database using VBA to control the system.

Go to exercise ...

Category: Access 2010
Topic: Uses of VBA
Level: Average difficulty
Course: Access Developers
Exercise: Use VBA in a Microsoft Access 2007 database to create a criteria form system.

Go to exercise ...

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

This page has 0 threads Add post