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

https://archive.org/download/oltp-olap/campus_columndb.json

https://archive.org/download/oltp-olap/campus_graphdb.json