Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

Once the schema is created, close the SQL Script window. You’re ready to create a table. Creating a table I’ve created a database called SERVERS, that will be listed in the SCHEMAS pane.

Here's how to create a database query using the Design View tool. The LibreOffice suite of tools enables user to employ a seriously powerful office suite that can cover a number of tasks.