2006-11-22 01:18:08 · 9 answers · asked by correlle4272 1 in Computers & Internet ➔ Software
Excel is a spreadtsheet program. Access is a database program used primarily to store very large databases and can sort them and aid you in searching. To give an example:
You own a business with 23,000 employees. You need to find out which employees, in a certain department, have a salary within a certain range AND have been employed since before a certain date. Access will sort the data meeting all of your criteria and provide you a list of the proper employees.
2006-11-22 01:25:18 · answer #1 · answered by ***~BiGgDaWg~*** 1 · 0⤊ 0⤋
Microsoft Access is a program that works with databases. Microsoft Excel is a program which creates spreadsheets, which are functional elements of databases.
If you have a business with many customers, you would enter all of their information, addresses, sales, names, phone number, etc; into an Excel spreadsheet. You could then create a form in Access to create invoices and statements from the data on the spreadsheet.
Basically, Access organizes the data you enter into Excel and allows you to make forms and interfaces which will interpret the information and print it for distribution.
2006-11-22 01:24:16 · answer #2 · answered by somewherein72 4 · 0⤊ 0⤋
Microsoft Access is a relational database, and can provide the in depth data mining that may be required, a relational database is an asset to a business that may require more analysis of information that it has on customers and products. etc.....
Microsoft Excel is a powerful spreadsheet and also a powerful tool, but it's not relational although it is a database. It does provide some search capabilities, and pivot reports.
One could use either to create and maintain a list of say entertainment materials that you have. With a relational database one could quickly and easily sort by type of media, or location of media, or subject matter of media, or multiples of criteria with a predetermined control button.
although a spread sheet can do these it would be a tedious process.
hope that helps
2006-11-22 01:35:17 · answer #3 · answered by mhp_wizo_93_418 7 · 0⤊ 0⤋
Microsft Access is a database application used to store data for transaction processing whereas Microsoft Excel is a spreadsheet application used to perform simple calculations, graphs and for some accounting and MIS purposes.
BYE
2006-11-22 01:26:26 · answer #4 · answered by Imtiyaz G 4 · 0⤊ 0⤋
Access is a database program. It is used for storing large amounts of data that needs to be sorted, searched, and organized. Excel is for spreadsheets. Those are mainly used for data requiring lots of math, etc.
2006-11-22 01:20:42 · answer #5 · answered by thebman990 2 · 1⤊ 0⤋
Access is a database program. Excel is a spreadsheet program.
2006-11-22 01:20:51 · answer #6 · answered by Thor 5 · 0⤊ 0⤋
MS access is one of the database. but exel is one of the worksheet for entry level to create a format.
an access to use create a mini database software itself.
more function to be it self for example create form's,button's,macrow's,listbox,ect moreless then using VB component.
But is there not support Excel okj Baby
2006-11-22 01:24:52 · answer #7 · answered by Arul D 1 · 0⤊ 0⤋
Excel is a spreadsheet application
Access is a database application.
2006-11-22 01:20:25 · answer #8 · answered by timc_fla 5 · 1⤊ 0⤋
that's common getting to understand. you would be extra useful off clicking on the help function ? or pressing F1. and typing in those matters. MS permit you recognize and additionally you will study a thank you to apply help. the 1st one is click in B4 and form =B2*B3. the 2nd is One or 2 areas - look on the examples from classification
2016-10-17 09:27:38 · answer #9 · answered by Anonymous · 0⤊ 0⤋