First, create an entry HTML form capable of passing information to a secondary file. Next, create a Hypertext Preprocessor (PHP) file to accept the data and insert it into the database.

Now it's time to create a table in the MySQL database using the PHP class library. Create a PHP script named createMySQLTable.php in the C:/Apache2/Apache2/htdocs directory.

In Access, you can create forms by using the Form tools found on the Create Tab; in the Form Group, these Form Tools are: Form: Create a Form that allows you to input data into one record at a time.

Click Apply to execute the SQL Script. Your table is now ready for data. Adding data to a table It’s now time to populate that table with some data. This is where it gets tricky.