Question

How excel can be used as database?

Answer 1

The steps in this tutorial are:

Entering the Data - How data is storedEntering Data Correctly - How to avoid common errorsRows are Records - Organizing your dataColumns are Fields- Organizing your data (con't)Creating the Table - Create the databaseUsing the Database Tools - Sorting and filtering dataExpanding the Database - Adding new records


hope it may help u

Answer 2

This wikiHow teaches you how to create a database using data from a Microsoft Excel spreadsheet by importing the data directly into Access, Microsoft's database management software, or by exporting the Excel data into a format that works with most database software