Answer to Question #44025 in Other Programming & Computer Science for faisal
Explain any four options supported by MS Excel to handle databases in MS Excel.
Flat data To help decide which program isbest for storing your data, ask yourself the following question: is the data relational or not? Data that can be efficiently contained in a single table or worksheet is called flat or nonrelational data. For example, if you want to create a simple list of customers, with only one address and contact person for each customer, Excel might be the better choice.
Data You can use Excel to connect to awide variety of data sources including Access, SQL Server and Analysis Services databases, text and XML files, and ODBC and OLE DB data sources. However, you cannot edit the data to change the source data through the Excel user interface. Modeling InExcel, you can use what-if analysis tools to forecast the outcome of a worksheet model. What-if analysis allows you to run different scenarios on your data, such as best case and worst case scenarios, and compare the resulting data of several scenarios in a summary report.
Multiple user access to data In Excel, you can share a workbookwith other users, but multi-user collaboration functions best when users work on the data in that workbook at different times instead of simultaneously. In effect, users of an Access database collaborate on a set of data, and users of an Excel workbook collaborate on a document.
Going back to school after summer vacation is not the easiest thing to do. In fact, it takes more mental…
APPROVED BY CLIENTS
I was satisfied with my service. The homework was delivered before my deadline date. I will use you again in the future. I will tell others about your service. Assignment Expert responded to my requests in a timely manner.