answersLogoWhite

0

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.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

Is there any other software available to create a database than Microsoft Excel?

While you can create them with it, Microsoft Excel's main use is not for creating databases, but for creating spreadsheets. Microsoft Access is the main Microsoft product for creating databases. There are also many other applications that you can create databases with too, like Oracle, Open Office, or MySQL


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.


How is Access different from other Microsoft Office applications?

Each of the Microsoft Office applications are completely different to each other. Microsoft Access is for creating databases. Microsoft Excel can do some databases, but it is not designed to do them, as it is a spreadsheet application. Microsoft Access has many facilities to create databases. Those things are not present in the other applications, which are each designed for their own tasks. Microsoft Access allows you create tables, queries, forms and reports as the main elements of its functionality.


What type of a database is Microsoft Excel?

Microsoft Office Access uses a database type known as the Microsoft Jet Database Engine. You can learn more about Microsoft Access online from the Wikipedia.


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 can be a data source for a mail merge?

Databases and spreadsheets make good data sources for mail merge.


Is Microsoft Excel Ms Access Ms Word Ms Outlook are these examples of different databases?

Access is the database applicaton. Excel has some database capability, but it is very limited. Outlook is an e-mail client, but it has a database for keeping details of contacts. Word is a word processor and can create tables, but with little database capability.


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Is Microsoft Excel the database software of the Microsoft office suite?

No. Excel is a spreadsheet. Access is the database.


Which softwares are required for hotel?

Microsoft access+Microsoft word+Microsoft excel


How is company data stored?

Company data, such as employee salaries, expenses, etc are usually recorded in Microsoft Word (documents), Excel (spreadsheets), or Access (databases) files.


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.