how r microsoft excel used as database...plzz tell me
Answers
Answered by
1
Related tutorial: Microsoft Excel 2003 Step by Step Database Tutorial.
At times, we need to keep track of information and a good place to this is in an Excel database file. Whether it is a personal list of phone numbers, a contact list for members of an organization or team, or a collection of coins, cards, or books, an Excel database file makes it easy to enter, store, and find specific information.
Microsoft Excel has built it tools to help you keep track of data and to find specific information when you want it. As well, with its hundreds of columns and thousands of rows, an Excel spreadsheet can hold an enormous amount of data.
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 recordsCompleting the Database Formatting - Formatting the title and cell color
At times, we need to keep track of information and a good place to this is in an Excel database file. Whether it is a personal list of phone numbers, a contact list for members of an organization or team, or a collection of coins, cards, or books, an Excel database file makes it easy to enter, store, and find specific information.
Microsoft Excel has built it tools to help you keep track of data and to find specific information when you want it. As well, with its hundreds of columns and thousands of rows, an Excel spreadsheet can hold an enormous amount of data.
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 recordsCompleting the Database Formatting - Formatting the title and cell color
Similar questions