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 ...

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

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.

Use this form when you want to create a new table with columns that are not present in existing tables. It is also useful if you are running SQL statements from an SQL application in another SQL-based ...

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.

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.

The following example shows how to read DBMS data into SAS and create additional variables to perform calculations or subsetting operations on the data. This example creates the SAS data set ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.