Category: PHP, MySQL

MS Access typically won’t be used in a real-world web application, but you can have it generate some of the SQL for you with it’s easy-to-use drag-and-drop interface. Even for non-web applications (using MS Access as the front-end) it’s not good for “big” databases.

You can use MS Access to generate some of the SQL for you, that you can then transform to be compatible with a different relational database.

Let’s assume we have two tables with these fields: Creating a query in MS Access to show the number of total hours played by user would look like this: You can view the SQL by changing the “View” at the top left to SQL View

If you create a Delete query in MS Access, it will provide SQL similar to this: Remove contents between DELETE and FROM (specifically, the “*”).
Newsletter

Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week

Glimpse streamlines Laravel development by seamlessly deploying GitHub pull requests to preview environments with the help of Laravel Forge. Glimpse streamlines Laravel development by seamlessly deploying GitHub pull requests to preview environments with the help of Laravel Forge.
Fathom Analytics | Fast, simple and privacy-focused website analytics. Fathom Analytics | Fast, simple and privacy-focused website analytics.
Shirts painstakingly handcrafted by under-caffeinated developers. Shirts painstakingly handcrafted by under-caffeinated developers.
Community Partners