Access and VB assignment

These assignments should be done within Access using VBA (they should not be done in regular Visual Basic).

• Create a new Access database with a couple of tables to experiment with.
• Using that Access databases, create a button on a form that does different calculations depending on a code. The results of the calculation should be displayed on a form.
• Do something else in response to a click event using VBA
• I would like you to experiment more with using Visual Basic in Access. Using a form, do the following:
• A if statement
• A while loop
• An until loop
• An array - take a code in from the database, pull information out of a table and display the data taken from the table on the form
• Extra credit if you do a nested if statement (an if within an if)