What are the main differences between Access and Excel

Page 1 of 2 1, 2  Next

View previous topic View next topic Go down

What are the main differences between Access and Excel

Post  Admin on Mon Oct 13, 2008 6:20 pm

Teachers and students use Access or Excel to manage textual and numerical data. But, did you ask yourself what are the differences between these two applications. Experts say that Excel is not a database.

Dr Alaa Sadik

Admin
Admin

Posts : 3
Join date : 2007-09-09

View user profile http://alaasadik.forumotion.com

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u083841 on Mon Oct 13, 2008 8:23 pm

[b]I found this information about the difference between databases and spreadsheet from this webct [b][size=7]http://www.tek-tips.com/faqs.cfm?fid=454

There's a lot, but I'll go into the generals with this:

"Access does not allow for data corruption so easily by a user, such as selecting all but one column, Access will still include all fields for sortings, Excel won't. Excel now has a warning message box that comes up, but in it's early days, it just sorted regardless. Therefore to say the least, Excel is very clumsy with data management.

Access can store X number of records, Excel can only store up to 65536 records on the same sheet without having to use a different set of columns or continue on with other worksheet(s).

Access has a 2GB memory usage limitation as opposed to Excel having a 80 MB RAM (160 in XP and 03) usage limitation before it crashes.

Access can query data very easily and NOT run into issues too easily. In Excel, if using multiple files to compensate for the RAM usage limitation not to mention that calculation also eats away the RAM, try using External Link formula. This works fine at first, but when it references at least roughly 13,000 cells externally, Excel crashes.

Access Forms has lots of form events that one can use (though I don't care for how data validation works on bound forms/objects cause it not so user friendly for those that's predominantly mouse users, so I had to build with UNBOUND objects to make the forms more user friendly without sacrificing the strict data validation checks), Excel UserForms has very little Events to work off from.

Access has a fairly good security model, but I'm still not saying it's real good as it still lacks a few things for what I would like to see from a security stand point of view. Excel Security is nearly non-existent. Yeah, it does have security items, but it's not that great as I can demostrate too many issues such as users can still copy hidden cells on a protected worksheet and paste the information onto another worksheet that's not protected. That's just one issue of several.

Access is designed to have multiple users working in the same DB file(s) along with the various safety precations items to help protect the data such as record level locking. Excel has very limited multiple user capacity within the same file.

[quote][code][list][*][img][spoiler]Excel has a lot of calculations/functions that is easily and quickly used for small scale projects. When you need to find the result of some expression, Excel is the way while finding some information based on some data criteria, querying the data in Access is the way"
But if anyone wants to ask me how is the best to use Access and Excel?
I can replay "Access should be used for all of it's DB means, and maybe even a lot of the analytical stuff via VBA coding.

Excel is good for 2 things

If you need to create a prototype, you can do this very quickly in Excel unlike in Access, it may take a while to do. However, don't spend much time creating this prototype as it's only meant to give a feel for how it would work on a general level basis in Access.

Excel is very easy to create things like charts and other data analytical tools from the data that may be retrieved from Access.

Excel is good for SHORT-TERM solutions and small scale projects while Access is good for LONG-TERM solutions and large scale projects".

u083841

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  N-AlSulti on Mon Oct 13, 2008 9:17 pm

احسن اشرحلكم بالعربي
بس لا يعصب الدكتور علينا

طبعاً يوجد فرق شاسع بين الاكسل والاكسس




الاكسل برنامج لعمل الجداول الالكترونية . . . .
فمن خلال الاكسل يمكنك عمل معادلات كثيرة جمع وطرح وضرب وقسمة ومعادلات جبرية ومحاسبية ومقارنات وكل شيء . . .
أما الاكسس فهو برنامج قواعد بيانات فيمكنك من خلال برنامج الاكسس تخزين البيانات بداخلة ثم يتم استعراضها مرة أخري عن طرق البحث المختلفة أو عرض هذه المعلومات داخل التقارير
فأي برنامج قواعد بيانات يستند علي اسس رئيسية وهي RMDS
وهذه الحروف اختصار لــ relational Managment DataBase Systems وهي نظم إدارة البيانات العلائقية

اختلاف آخر بين برنامج الاكسل والاكسس
برنامج الاكسل لا يستطيع تخزين بيانات بداخلة (Database)
أما برنامج الاكسس فله القدرة علي اسيعاب مساحة كبيرة من البيانات
أساليب التعامل مع الاكسل مبني علي الخلايا
أساليب التعامل مع الاكسس الاحداث والنماذج والتقارير والاستعلامات والوحدات النمطية والجداول[/font]

N-AlSulti

Posts : 2
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u082920 on Tue Oct 14, 2008 1:32 am



Good Evening


One of the differences that I have found till now is :

MS Access gives user the ability of making Queries while this option is not available in MS Excel
Well I Think this is one of the main differences between these two softwares .



Regards
AL-Zadjali
















u082920

Posts : 1
Join date : 2008-09-14
Age : 26

View user profile http://ozear.eu

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068707 on Tue Oct 14, 2008 2:30 am

Spreadsheet applications don't provide the depth of functions that ensure good data such as restricting data to specific ranges or formats and maintaining links among related data. Databases are better at providing data access by supporting complex searches, intensive data entry, and multiple user access.

u068707

Posts : 2
Join date : 2008-10-12

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068707 on Tue Oct 14, 2008 2:32 am

If you currently use a spreadsheet to store data, ask yourself the following questions:

Do changes made in one spreadsheet force you to make changes in another?

•Do you have several spreadsheets containing similar information (such as separate sheets with inventory for Dallas, D.C., and Detroit)?

•Do you want some data to be hidden from some users?

•Can you see all pertinent data on one screen or do you have to keep scrolling?

•Are several people accessing the data at the same time?

•Do you have a hard time viewing specific sets of data you want?

u068707

Posts : 2
Join date : 2008-10-12

View user profile

Back to top Go down

I HOPE THIS IS THE SUITABLE ANSWER FOR THE QUESTION!!

Post  u068698 on Tue Oct 14, 2008 1:22 pm

WHAT DO YOU THINK ABOUT THIS DIFFERENCES:

Like a Star @ heaven Ms access and ms-excel are both used for databases
but ms-access is more power ful than ms-excel

Like a Star @ heaven Both are for different purposes
1)MS-Access has rdbms concept but ms-excel doesn't.

2)Ms-excel is used for calculation and making graphs etc but in access we dont have such a facility;

3)We have a table in access but in excel we have sheets
however it is possible to transfer data between excel and access .

@ Moreover ms-access has a relational concept for making relationship between tables.

Exclamation Access is mainly for handling databases not for calculation.
-------------------------------------
Like a Star @ heaven Excel cannot easily be shared
Like a Star @ heaven Excel is not scalable (limited rows)
Like a Star @ heaven Access can do calculations (incorrect above) in forms, reports and queries
Like a Star @ heaven Excel has limited validation rules
Like a Star @ heaven Excel is limited in forms and reporting in comparison to Excel>>>

________________________________________________________________________________

ANOTHER ANSWER:
Very Happy Before knowing the difference between MS Excel and MS Access you must know that both of these application softwares are developed by Microsoft Corporation, in addition to these Microsoft Office packages include MS Word, MS PowerPoint, MS FrontPage MS Outlook. All of this software has different usability and functions.

Cool MS Access, in fact is a database that is used to store data in the form of tables, here the data inside the table is stored in the form of columns and rows and one complete set of data is called a record. In Ms Access you can query the database and can see only your required data in the form of Reports (A printable format containing the result of query).


Evil or Very Mad Now looking at MS excel, it not a database but it is something more technically known as a spreadsheet, it is a perfect software for maintaining the data on a limited scale, it should be used for small organization salary calculations, and for some research analysis comparison Ms Excel is the right software. MS Excel contains rows as columns, and the area where every row and column intersects is known as "cell". Ms Excel also provides the solution for automatic formula calculation and has features like sorting, data forms, formatting and many useful features for home and commercial inventory and accounts management...........


Cool MAZIN (u068698) Cool

u068698

Posts : 2
Join date : 2008-10-14

View user profile

Back to top Go down

Difference between microsoft excel and microsoft access?

Post  u068719 on Tue Oct 14, 2008 1:50 pm

Answer:

excell is not a database

Like a Star @ heaven Access can hold larger amounts of data than Excel
Like a Star @ heaven Easier to enter a query into Access
Like a Star @ heaven Faster to manage and find files in Access
Like a Star @ heaven Can create and use an interface in Access
Like a Star @ heaven Can handle many users accessing the database
Like a Star @ heaven Access can hold image for ID
Like a Star @ heaven Excel is easier to use

Hope that gave you some ideas



u068719

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068714 on Tue Oct 14, 2008 6:47 pm

Relational databases keep the file size smaller, make data access faster, and reduce the chance of incorrect information by recording everything only once.

u068714

Posts : 2
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068714 on Tue Oct 14, 2008 6:48 pm

Also,spreadsheets are a poor choice for data management. Their strength is in crunching numbers, not organizing records.

u068714

Posts : 2
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  Admin on Tue Oct 14, 2008 7:08 pm

So, if the answer is YES to all of some of these questions?

Admin
Admin

Posts : 3
Join date : 2007-09-09

View user profile http://alaasadik.forumotion.com

Back to top Go down

Re: What are the main differences between Access and Excel

Post  AlSalmi on Wed Oct 15, 2008 1:16 am

from my research that is what I have found
If multiple users, and especially non-technical users, will use your system, then Access is probably better. If more than one person needs to update the contents of your data store at one time, then Access is better (because Excel will lock the whole spreadsheet for one user).

AlSalmi

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068712 on Wed Oct 15, 2008 4:37 am

Asalaam 3likom

I think the differences between axcel and access that You would use Access to collect, manupilate and sort data.
and we use excel to create financial spreadsheets. Excel has some limited capabilities to sort data but its primary function is to create financial spreadsheets.

u068712

Posts : 1
Join date : 2008-10-15

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u082925 on Wed Oct 15, 2008 4:48 am

Asalaam Alaykoom

In my view the main differences between spreadsheet and database are:

Excel is basically number driven You can use it for Accounting / Club membership Subscriptions / Basic Add subtract / and formulas.
Access is a program that can store information and retrieve it in any form.

A database is more for storing lots of information about different examples of something.
A spreadsheet, such as Excel, on the other hand, deals with calculations.

u082925

Posts : 1
Join date : 2008-10-15

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u069635 on Wed Oct 15, 2008 1:42 pm

alsalam alikom,,,

Ithink the differances between these tow application is that:the database allow to creat switchboard and query but the spreadsheet doesn't allow for that..


thank you

u069635

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u082932 on Thu Oct 16, 2008 3:57 am

MS Excel is the cheapest way to obtain database capability because you can use it to merge with MS Word and vice versa. For example, you maintain your suppliers information in one spreadsheet in a workbook and use MS Word to generate letters with common contents to them by Mail Merge. Instead of keying one by one to series of MS Word files, you use one MS Word file to generate multiple letters in one go.

MS Access can used for inventories, contacts, time management, sales/purchase, and many others. You have SQL capability, web-based database capability for your web site, and among other uses that require database. Similar to MS Excel, it can be linked up with other MS Office applications like MS Word and MS Excel for integrated use.
[/size]
Smile

u082932

Posts : 1
Join date : 2008-10-14

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  AL-abri on Sat Oct 18, 2008 2:06 pm

Excel is a general spreadsheet program, which will allow BASIC database functions - however, it is "flat file" which means that you can only have one table in your database. It's also single user in that only one person can safely edit the data at any one time (yes, you can share the workbook, but this only works if you know that any one record will be modified by only one user!)

Access is much more flexible, allowing relational database functionality - and has a better query functionality. Other alternatives are any database system (eg SQL Server if you want to go the whole hog!) and is of course multi user.

AL-abri

Posts : 1
Join date : 2008-10-15

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u082930 on Sat Oct 18, 2008 6:01 pm

Ms access and ms-excel are both used for databases
but ms-access is more power ful than ms-excel

Both are for different purposes
1)MS-Access has rdbms concept but ms-excel doesn't.
2)Ms-excel is used for calculation and making graphs etc but in access we dont have such a facility;
3)We have a table in access but in excel we have sheets .

[1] Report Excel cannot easily be shared
Excel is not scalable (limited rows)
Access can do calculations (incorrect above) in forms, reports and queries
Excel has limited validation rules

u082930

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u082910 on Sun Oct 19, 2008 3:48 am

we would use Access to collect, manupilate and sort data. The primary use of excel is to create financial spreadsheets. Excel has some limited capabilities to sort data but its primary function is to create financial spreadsheets.

With Excel you can create extremely complicated financial "what if" scenarios where you can change some variables and get a good look at the financial consequences. It is an extremely powerful spread sheet. It does have some sorting capabilities but you would not want to try to create and maintain a complex database in Excel.

With Access you can collect, sort and manupliate data. For example you could do a data base on a large number of employees or members of a club, storing all the personal information. Then you could ask the program to give you just those that fit in any set of parameters. For example, employees with over ten year service, or employees in a certain state, division, zip code. Access can be used for any application where there is a large amount of data and you want the ability to sort it by different criteria.

I got this information from this website ... Idea
http://hubpages.com/hub/What-are-the-differences-between-Microsoft-Access-and-Excel-Why-would-you-use-one-as-opposed-to-the-other_1

u082910

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Malik Alnou'mani

Post  u068718 on Sun Oct 19, 2008 12:32 pm

in my opinion,and just an opinion:

MS excel was developed to contain numerical data and apply mathematical functions on them and that why the FX effects are more specific and professional in excel. also, excel can't relate between any two cells or sheets without applying difficult mathematical functions.

while in MS access, it was developed to contain any type of data and classify it according to the forms or queries. and you can manage your data and classify it easily in access more than excel because you do not have to enter any mathematical functions to it except in desire.

u068718

Posts : 1
Join date : 2008-09-24

View user profile

Back to top Go down

What is the different between database and spreadsheet?

Post  3bdo on Sun Oct 19, 2008 7:26 pm

A database is more for storing lots of information about different examples of something. So for example, if you were car salesmen you may have a database of cars for sale. You open it up, and you can look at, say, the 56 different cars for sale, and check out the prices, top speeds, deals, mileage etc and compare different models together. Each area of information, such as price, top speed etc is called a field. Most databases allow searching in fields, so that of the database of 56 cars, you can search for red ones only, for example.

A spreadsheet, such as Excel, on the other hand, deals with calculations. So the same salesmen may have a spreadsheet, detailing how many cars he has sold each month, how much he has sold each for, how much commission he is getting, how much profit etc. You can use the spreadsheet to perform calculations for you, so if he has a commission of 7%, he can enter the profit for the company he has ade, and the commission he gets from this will be calculated for him. Then, if he sells another vehicle, he can update the profit, and the change in commision is updated for him automatically.

Hope this helps.

3bdo

Posts : 1
Join date : 2008-09-15

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  N-AlSulti on Wed Oct 29, 2008 2:34 pm

there is alot of tutorials that related to the excel and database

for example :
1_ excel
http://www.usd.edu/trio/tut/excel/
http://spreadsheets.about.com/od/excel101/a/Excel_beg_guide.htm

2-database

http://articles.techrepublic.com.com/5100-10878_11-1050135.html

N-AlSulti

Posts : 2
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068698 on Wed Oct 29, 2008 2:40 pm

In my opinion

MS access are more effective in use than Ms excal.

Becouse the most common things in Excel is multiplications processes

while Ms Access had a link with MS access to make Multiplication things in

this software which are called it (offece tool)>>>>

u068698 (MAZIN) Very Happy

u068698

Posts : 2
Join date : 2008-10-14

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u063041 on Wed Oct 29, 2008 2:59 pm

there are many differences between them just like:

-to make a query in Access is more easy,

-managing and finding files is more fast in access

-we can create and use an interface in Access

-Can handle many users accessing the database

-Access can hold image for ID

-Excel is easier to use

u063041

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

diffrent between

Post  Alabri on Wed Oct 29, 2008 5:28 pm

hello
•Access can hold larger amounts of data than Excel
•Easier to enter a query into Access
•Faster to manage and find files in Access
•Can create and use an interface in Access
•Can handle many users accessing the database
•Access can hold image for ID
•Excel is easier to use

Alabri

Posts : 1
Join date : 2008-10-13

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  Sponsored content Today at 7:46 am


Sponsored content


Back to top Go down

Page 1 of 2 1, 2  Next

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum