Steps For Building A Database In Excel?

Asked By FidanoskiF 0 points N/A Posted on - 09/01/2016

I want to know the steps for building a database in Excel. The purpose of the building is to access records and make quires to filter data and process information.

• Status: Open
• Question Views: 324
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Eaana Albert 2105 points N/A #85164

Steps For Building A Database In Excel?

To build a database in Excel is not generally possible but you can build something similar to the database using the given steps.

Step 1: Create master and details table.

Step 2: Format the tables with the required formatting and colors.

Step 3: From the Insert tab click on the Pivot table and add all the required tables to the view

Step 4: Add the views and modify the required views to display the content according to the requirements.

About Eaana Albert

Questions
18

Answers
27

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/01/2016
• Question Category: MS Excel