Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

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.

Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...

Jack Wallen shows you how easy it is to create a MongoDB database and collection using the Compass GUI.

Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

How to make your first pivot table To start, navigate to Google Sheets and open the spreadsheet you want to work on. This example uses a coin collection because that's more interesting than ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.