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 “*”).