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.
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.