Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

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.

You create a database, add tables, and then start adding data to the tables. All data is stored in a folder on your device’s internal storage (named PortoDB).

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information. Access is ...

How to create Tables with Table Designer in Access You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns.

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

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.