What is MySQL?
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. (Source: Wikipedia)
Microsoft Access
Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.
Using MySQL with Microsoft Access
In this tutorial, you will learn how to create a database on Microsoft Access and how to use MySQL codes to send queries to the database.
We will use few of the basic MySQL codes in our example. If you want to get familiar with Introductory MySQL Language, click on the button below:
Example - 1
I will show you how to use MySQL on Microsoft Access in the following steps:
Step - 1
Let’s open up Microsoft Access and create a database.
Step - 2
Create a Table from the Create Tab on top
After you have created your table, it would look something like this.
Step - 3
Let’s add some data to our table.
Click the “Downward-Arrow”. This will open up the option to select the “Type” of your data.
Here, I have created a table of data.
Step - 4
If you have inserted your data on your database. You can write queries in MySQL Language to make commands.
To do that, open the “Design” tab on the top.
After opening the “Design” tab, Select “SQL View”. This
This is will open up the Query Table. Here you can write your SQL codes.
Step - 5
Let’s write a code.
SELECT * FROM Table1
This code selects everything from out table.
Query:
After writing the query, click on “Run” to run your code.
Result:
We have selected everything from our table.
After you are done with your query, you can either save or close the query by clicking on the close icon on the top right
Now you try.
SELECT Salary
FROM table1
WHERE id = 5;
SELECT Name
FROM table1
WHERE Salary >= 40000;
Follow step – 4 and try out the example code I have provided. Let’s see what happens.