Writing the first code using Microsoft Access

What is Microsoft Access?

One example of application software is Microsoft Access. Also, Access nationwide is a robust relational database management system (RDBMS) that enables users to create and manage databases.

It is a part of the Microsoft Office suite and is designed for businesses, organizations, and individuals who need to manage and analyze structured data.

Many users have no idea how to write a program or a simple piece of code using Microsoft Access. Determine the commands that follow.

How to Launch Microsoft Access

• Click on start from the taskbar
• Select and click on All Programs.
• Click on Microsoft Office
• Move to Ms Access and click on it

Alternative 1

• Double-click on the icon on desktop or
• Right-click on Open, thus the shortcut icon
• Select and click on Open

Alternative 2

• Using the run window, type in the dialogue box msaccess
• Press the enter key once or click on the ok button

Writing the first code using Microsoft Access

1. Open a blank database
2. Go to create tab in the ribbon and click on Module
3. In the new window,vba code can be written
4. In the module, type the following codes:

1      Sub HelloWorld ( )

2              MsgBox “Hellow World”

3      End Sub

5. Go to File, select and click on Save

6. Go back to Access Database Window or ctrl+G to open immediate Window

7. Click on the View Tab

8. Type the following code (Hello World) and press the enter key

NOTE/SUMMARY:

• Click on run
• Click on run macro
• Select the code and click on run
• The message would be displayed in a new window
• Click on Ok

About Author

SURF

See author's posts