0
They are separate applications, but they can do a lot of the same things as each other and can also share data. You can copy and paste data between them and also link them. So yes, they can work together in lots of ways.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Is Excel a collection of related info?
No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.No. Excel is an electronic spreadsheet application. Using it, you can work with collections of related information. You can also do that with other applications, particularly Access, which is a database. Excel is more useful for numerical data.
When is Excel and Access used together?
There are lots of occasions when you want to do different kinds of things with the same data. Excel and Access can easily transfer data between each other. If you are doing lots of calculations, then Excel is better. If you are processing lists of data, the Access is better. Sometimes you want to do both. Sometimes you want to generate results from one and use those in the other. There are so many situations, that it is not practical to list them, but the two applications can work well together.
What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?
the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer
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.
What ways are there to work together in cooperation on a document with other excel users?
Collaboration
What can you do in Excel that you cannot do in Access?
There are lots of differences as they are two applications designed for different tasks. Access is mainly for storing lists of data of different kinds. Excel is for Numerical Analysis and Manipulation. So its focus is on working with numbers. As such it provides a much wider range of functions than Access does. Access stores data in tables, but with Excel it is easier to lay out tables visually and put all sorts of calculations around them, like totals and averages, together with the original data. Access can store the data in tables and do calculations, but they are not done together. Excel provides a wide variety of charts, many very specialised, which Access does not. Excel has the power of doing extensive pivot tables and gives other ways of analysing data, which Access does not. There are a lot of things both can do, but Excel is more versatile in what it does and it can be used in many creative and imaginative ways. Access is good at what it does, but it is designed for different kinds of tasks than Excel is. There are many other differences. When it comes to processing numeric data of any kind, Excel does far more.
When you data from Access to Excel a copy of the data is created in Excel?
You can copy data from Access and paste it directly into Excel. From a table or query, data can be selected and then copied and pasted into Excel. In that case, data changing in the original Access file will not change data in the Excel file. To do that there must be a link between the data. You can also import data from Access into Excel and from Excel into Access, again maintaining a link to the source if you want.
What is the motto of Broadgreen International School?
Broadgreen International School's motto is 'Care together , Work together , Learn together , Excel together'.
Can you export information from Excel into Access?
Yes, but you would use the Access import option, instead of an Excel export option. You also can use Excel to SaveAs various formats that Access could import, but direct import from Access probably would be the most efficient method. See related links for various options for sharing data between Excel and Access.
What is the best application to chart the average temperature for the year?
Excel
What is better in call centers Excel or Access?
You can't really say, as Excel and Access are for different kinds of tasks. Excel is a spreadsheet and there would be lots of things that it would be used for in a call centre. Access is a database and it also could be used for lots of things in a call centre. It depends on what you want to do. If you are doing lots of calculations in your work in a call centre, you are more likely to be using Excel. If you are keeping lists of data, then you would be more likely to use Access.
Vertical columns and horizontal rows?
Columns are always vertical and rows are always horizontal. Together they form a table. These appear in different applications, such Word, Access and Excel. In Excel they are known as a worksheet.
