Create a new database - Microsoft Support
It explains how to create a desktop database by using a template, and how to build a database from scratch by creating your own tables, forms, reports, and other database objects. It also …
Create a Data Model in Excel - Microsoft Support
A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook. Within Excel, Data Models are used transparently, …
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate …
Create a PivotTable with an external data source
Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.
Reverse engineer an existing database into a database model
With the Reverse Engineer Wizard, you can create a database model from an existing database or an Excel workbook. Database models graphically show the structure of a database so you …
Video: Start a new database from a blank template
Training: How to create a new database file, and the types of databases you can create.
Video: Build tables with the Table Designer - Microsoft Support
When you create a table with Table Design, you can be more deliberate about designing your database, set field types, create a lookup list, and create a foreign key to pair with your …
Create, edit, and manage connections to external data
You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog …
Use Power Query in Excel for the Web - Microsoft Support
Excel incorporates Power Query (also called Get & Transform) technology to provide greater capability when importing, refreshing, and authenticating data sources, managing Power …
Create a relationship between tables in Excel - Microsoft Support
Although Excel can tell you when a relationship is needed, it can't tell you which tables and columns to use, or whether a table relationship is even possible. Try following these steps to …
Using Access or Excel to manage your data - Microsoft Support
In a relational database, you organize your information into multiple tables. In a well designed relational database, each table is flat and contains information about only one type of data.