Editing MS Access Database Model In Excel Power Pivot
[1] Download access database and view the content using excel application:
https://archive.org/download/oltp-olap/Financial_Sample_OLAP.accdb
[2] Create a new Excel blank worksheet
[3] Go to Data tab.
Select Get Data>From Database>From Microsoft Access Database
[4] In the Navigator window, select multiple tables.
[5] In the Data tab, under the Data Tools section, select Manage Data Model
A Power Pivot for Excel window will display the tables.
Click Diagram View button.
Tables will be displayed in diagram forms.
[6] Link the tables by dragging the key fields from one table to the corresponding fields in the matching tables.
https://archive.org/download/oltp-olap/Financial_Sample_OLAP.xlsx
https://archive.org/download/oltp-olap/Financial_Sample_OLTP.xlsx
https://archive.org/download/oltp-olap/campus_documentdb.json
