What are the main differences between Access and Excel

Page 1 of 3 1, 2, 3  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 1: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 3: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 4: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 Mon Oct 13, 2008 8:32 pm



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: 25

View user profile http://ozear.eu

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068707 on Mon Oct 13, 2008 9:30 pm

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-11

View user profile

Back to top Go down

Re: What are the main differences between Access and Excel

Post  u068707 on Mon Oct 13, 2008 9:32 pm

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-11

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 8:22 am

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 8:50 am

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 1: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 1: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

Page 1 of 3 1, 2, 3  Next

View previous topic View next topic Back to top


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