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

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.

Power BI supplies a default date table that’s adequate for many time grouping requirements. Find out how to know if that table is adequate.

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.

A developer shouldn't spend time on database table creation when unit tests run. Instead, have Hibernate create tables in the database for JPA and other data-driven applications.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

Creating Tables in Design View You have created a new database in the first part of this tutorial, and you've chosen to create a table in Design View. Below is a portion of what you should have on ...

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.