0
Yes, Excel can be used as a database but not to the same extent as other applications. It is primarily a spreadsheet application, so it does not have all the facilities you might want if you are creating a database. Something like Oracle or MySQL or Microsoft Access are better suited to be used as a database.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Is Excel the best-rated database management software?
Excel is a very well rated database management software, and as such with the rest of the word products. Word is a great processor, and powerpoint is great for presentations.
Why is it important to have database?
the database is used to maintain the data properly and it is easy to recover.
What is the purpose of database auditing?
Database auditing is used to observe the actions of the database users. It is commonly used for security purposes to ensure that information is only accessed by those with the proper authority to view it.
Gwalior vat numbers database?
The Gwalior VAT numbers database is the name of a database that lists jobs numbers. The job numbers database is used as a list for all jobs and job vacancies for the Gwalior District.
What functionality does a database provide?
There are a number of functionalities that a database provides. Some of the functionalities that database provide are : security of data, reduced redundancy also ease of accessing data.
Why is Excel not itself database but can be used as database?
Microsoft Excel is not a database, it is a spreadsheet. You could use it for a rudimentary database application, but that is not it's primary function.
What is external data in Excel?
It is data coming from another source, such as a database. It is external to Excel, but being used by Excel.
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
Is Excel a database file?
No. Excel is a spreadsheet package, not a file. You can use some basic database functions within Excel and you can also use Excel to store database information. However, in this respect, Excel is better for databases that are essentially flat files - Excel is not best suited for complex database structures.
Why Microsoft Excel is dbms?
Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.
Is Microsoft Excel the database software of the Microsoft office suite?
No. Excel is a spreadsheet. Access is the database.
Where can you find a database?
on Microsoft excel you can find a database.
In school what software do you use to create a database?
Microsoft Acess... To the person who wrote excel that's used for spreadsheets which is different from a database.
What technologies should be used for uploading an excel file and processing it to the database?
Using struts we can do it samir
Is Excel capable of making database?
No, Excel cannot make a database file. However, databases can be imported onto it. The primary software for making a database is Microsoft Access.
What does an identifier do in Excel?
When used as a database, an identifier in Excel identifies a record, so it acts like a primary key field. You can then find records easier.
What are the differences between Microsoft Excel and Oracle Database?
Excel is a spreadsheet program. Oracle is for databases. Excel has some databasing capabilities, but it is not its main purpose.
