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.

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.

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.