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

You create a database, add tables, and then start adding data to the tables. All data is stored in a folder on your device’s internal storage (named PortoDB).

Nick Peers reveals how to create your own simple databases in minutes with no coding or server experience required. It’s open source magic!

However, it is definitely not a relational database. In order to create a relational database, you need to combine a master spreadsheet with slave spreadsheets or simple tables.

Jack Wallen shows you how easy it is to create a MongoDB database and collection using the Compass GUI.

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.

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information.

In the video below, Mattias Frank shows us how to create a pivot table in notion, let’s find out how it is done. Watch this video on YouTube.

When tables are created for each topic in a database, you must place common fields into the related table and form a relationship with them for information to be brought together again.

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