0
No. Microsoft Excel is an accounting worksheet application, not a database. Microsoft Access is a small, simple, but capable, individual-user database application, and Oracle is among the largest of Enterprise-class database applications, and can accommodate the needs of gigantic corporations.
Wiki User
∙ 14y ago
Wiki User
∙ 13y agoNot really, but now a days, every software that deals with data storage, has some feature of DBMS.
Add your answer:
Earn +20 pts
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.
Is there accounting software that has ready-made compatibility with Oracle databases?
Microsoft Excel and Access offer the ability to interface with a Oracle database. This is provided through the Office Suite.
Is there a data base that will allow you to put names at the top - not letters like Excel?
You could use a database like Access or Oracle. You could also use the first blank row in Excel for your headings and Excel can work on them like a database.
Can Excel be used as a database successfully?
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.
Is Microsoft Excel the database software of the Microsoft office suite?
No. Excel is a spreadsheet. Access is the database.
Can I use Access to set up a Database Management System?
yes you can definately use it. access and excel are real good option to set up database management system. access is the really favourable and easy option.
How can you convert an Access database to an Excel spreadsheet?
To export the Access database to an Excel sheet in an easy way and for a detailed explanation, see the related links.
When importing an access database table Excel does what?
It will put the fields in Access into columns in Excel, and records in Access will be in rows in Excel. Data will be converted to appropriate data types.
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.
Why use Ms access to create databases and why not use Microsoft Excel?
Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways. +++ It's not "instead of" but "both" - using whichever is the better for the given work. ' It does depend on your purposes. Excel is by far the better if you need only a single table, or if you need to embed a lot of mathematical formulae in the spread-sheet - though MS has ruined what had been its nearly-good graph routines. A database table looks like a spread-sheet page, but it lacks the rapid copying functions that are valuable features in Excel.
How do you create data base?
You use the appropriate tools from your database's system or third-party tools. For MySQL, you can use PhpMyAdmin to create a database. For Oracle, or Microsoft SQL Server, or other applications, they have tools for this purpose.
Why do you need Microsoft Access especially if you have Microsoft Excel?
Microsoft Access is a database application and Microsoft Excel is a spreadsheet application, so they are two different kinds of application. There are things that both can do, but if you want to create a proper database, then Access is better than Excel. It has far more facilities for working with databases than Excel does. Because of that, it is simpler to do lots of things in Access than in Excel. If you want to create a spreadsheet, then that is what Excel is used for, though you can do a lot of things Excel does in Access. If you already have Excel and want to create databases, then you can, but you won't be able to do the really sophisticated things that Access can do and which a really good database needs, such as queries, reports, relationships etc. If you want a really good database that can do those things, then you need Access.
